(Artemakis Artemiou) In-Memory OLTP in SQL Server is a very powerful feature. In one of my previous tips, I suggested three approaches you can follow in order to get an indication whether you can benefit from using this feature for your specific workload.

(Pinal Dave) I break a lot of things on my SQL environment and I believe that is a very good way to learn things. Today, I wanted to perform a restore of a database using a backup which I took earlier. In this blog post, let us learn how I fixed Property BackupDirectory is Not Available for Settings

(Simon Liew) SQL Server Developers have a variety of innovative ways to use the COUNT function in SQL Server. Often times the assumption is that one syntax provides better performance than the others.

(Pinal Dave) In the recent past, I have heard this issue, at least once or twice every month. Whenever I try to help a such client and I think I know the issue, I get something new. They said that they have applied a patch and after that they were not able to access the SQL server and it is […]

(Jen McCown) People new to SQL often have trouble with the difference between WHERE, GROUP BY, and HAVING…three separate clauses in the SELECT statement. The summary of each of these is simple to tell:

(Joe Celko) Triggers are generally over-used in SQL Server. They are only rarely necessary, can cause performance issues, and are tricky to maintain If you use them, it is best to keep them simple, and have only one operation per trigger.

(Niladri Biswas) The objective of this article is to demonstrate the various ways of transforming Rows to Column in SQL Server

(Rajendra Gupta) Microsoft has recently released SQL server 2014 SP2 in which a new DBCC command – DBCC CLONEDATABASE is introduced. I found this command very useful and interesting too. In this tip we will explore the functionality of DBCC CLONEDATABASE.

(Kevin Conan) This is the start of a series of posts about one of my favorite new features of SQL 2016, Temporal Tables. Temporal Tables allow you go back in time and see what the data in table looked like at that point in time. Unlike the movie series Back to the Future, you do not need a flux ca

(Pinal Dave) Working with SQL Server is fun. Since SQL Clustering, and AlwaysOn availability group needs Windows Clustering so sometimes there are some cluster issues which I have to deal with and fix. Let us learn about an error related to core resource.