(Arun Sirpal) I used to be on the fence regarding whether or not Automatic Tuning should be on as the default when creating Azure SQL Databases.

(Pinal Dave) In the last 11 years of blogging, I have never received a question which I have received yesterday. The question which I often receive is about how to add TempDB files in SQL Server but I have never received a question about how to remove a TempDB file.

(Grant Fritchey) There’s a war on in the SQL Server world. On the one side is Profiler (although, really, everyone uses Trace Events). On the other, the “new” (they came out in 2008 with a full GUI in 2012, so…) Extended Events. Lots of people have picked sides on this, including Microsoft.

(johnsterrett) In some DBA circles, backups are just as popular as politicians! However, recoverability is the most important task for database administrators. While SQL Server 2017 added so many great features like graph, SQL on Linux, and more.

(Greg Larsen) Have you ever wanted to know how many pages in your database have changed since the last full backup? If so, then you will be glad to hear that SQL Server 2017 version of the DMV sys.dm_db_file_spavce_usage has a new column named modified_extent_page_count.

(Jack Vaughan) While SQL Server 2017 continues to get attention for opening up to Linux, many of Microsoft’s database advances revolve around various ways the company is opening up analytics on its flagship database. Case in point: SQL Server machine learning services.

(Kenneth Fisher) Have you ever had a query change performance unexpectedly? Intellisense all of a sudden stops working, or gives inconsistent results? AutoSave should have worked and saved your work after that unexpected (unexplained) crash? Ever had a query that was taking a long time and you can’t

(Ajeta Singhal) If your Data Lake Analytics account is heavily used, you might have to scroll through a long list of jobs to find just the ones you submitted. Relief is here. The new My Jobs quick filter in the portal makes it easy for developers to focus on just their jobs.

(Pinal Dave) Today, we are going to talk about one of the most popular errors which user see every day. There are many users who often get stuck at this error and have no clue how to move forward with this error in SSMS. It is quite possible you may say this is a very simple error and you knew […]

(Pinal Dave) Two days ago, I wrote an article SQL SERVER – How to Create Table Variable and Temporary Table? It was a very basic article for beginners. However, to my surprise, I have got tremendous response to that blog post and also got quite a lot of feedback about the it.