SQL Tips and Tricks Archives - Page 171 of 536 - SQL Authority with Pinal Dave

MySQL – UDF – Validate Integer Function

July 26, 2014

There is a default function in SQL Server called ISNUMERIC to determine if the string is numeric. In SQL Server ISNUMERIC returns 1 for non numerials also. Ex ISNUMERIC (‘,’) returns 1. To avoid this you can write a user defined function as shown over here. In MySQL, there is…

SQL SERVER – Andy Defines Basic RDBMS: Isolation in Processes – Notes from the Field #038

July 24, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SSIS

[Note from Pinal]: This is a new episode of Notes from the Field series. Every time I give an introductory note, however, this time there is no need of intro note. This note is from Andy and as we all know he is amazing person when we have to understand the fundamentals. He…

SQL Authority News – Webinar: SQL Server 2014 In-Memory OLTP and SafePeak In-Memory Caching

July 23, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

In the past couple of months many of us heard about the new SQL Server 2014 and its In-Memory technologies, such as In-Memory OLTP for high-transactional application and the ColumnStore INDEX’s for BI apps. This comes in addition to various in-memory technologies outside of the SQL Server world, such as…

SQL SERVER – Finding Object Dependencies in SSMS – SQL in Sixty Seconds #071

July 23, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

SQL Server Management Studio

While we are doing development, we create and drop objects. We build new things and we need to understand the relationships between database objects when we are doing various activities in SQL Server. Well, it is indeed very hard to know all, the relationship between various objects in SQL Server.…

SQL SERVER – Free Entry to SQLPASS 2014 is Possible

July 22, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL PASS

The other day, I received an email from Dell and I was extremely delighted to read it. It contained details how one can go for FREE to SQLPASS. What is SQLPASS? The three-day event will be marked by a lot of learning, sharing, and networking, which will help me increase both my knowledge…

SQL SERVER – SSMS: Activity – All Blocking Transactions

July 22, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Reports, SQL Server Management Studio

Working out of India has its own challenges and I enjoy here despite these challenges thrown at me. One of the biggest advantage I have working with Pluralsight is, I can still get my job done by working-from-home occasionally. And this is one of the perks I wish most of…

SQL SERVER – Activity Reports – Dormant Sessions

July 21, 2014

Pinal Dave

SQL Tips and Tricks

SQL Reports, SQL Scripts, SQL Server, SQL Server Management Studio

With schools starting for my daughter, I rarely get involved in her daily routine activity. But there is one thing that I don’t try to miss – the parents-teachers meet. Sometimes it is not about the report card on how my daughter faired against the rest in the class but it is more than that. I am curious to understand how she behaves in the class, how she makes friends in class, how her extra-curricular activities are, is she disciplined overall etc. Those are key attributes and traits I am looking at getting as feedback from the teachers in that hour of interactions. Let us learn about Dormant Sessions in this blog post.