(Kenneth Fisher) Similar to the default trace the system_health session is automatically started up when the instance starts and collects information about what’s going on.

(Pinal Dave) In our real life, there are lots of dependencies and same is true with SQL Server as well. This blog also talks about inability to drop a login due to a dependency. Let us see the error related to login is the owner of the 1 job(s).

(Denny Cherry) One of our customers ran across some interesting data within their Azure bill. Specifically they were looking at the billing for their SQL DW, but this same issue can show up in the billing statement for other services as well.

(Glenn Berry) On July 11, 2017, Intel officially launched their new 14nm Intel Xeon Scalable Processor family (Skylake-SP) of server processors. This family replaces the previous generation of 14nm Intel Xeon E7 v4 and 14nm Intel Xeon E5 v4 (Broadwell-EX and Broadwell-EP) processors.

(Tim Smith) We were recently trying to drop a SQL Server table in a subscriber database that did not receive replicated data, but threw an error as if the table did.

(Manoj Pandey) After creating a new Azure Windows Server VM with SQL Server installed, I was not able to connect it from my PC via SSMS. Everytime I tried to connect I was getting following error:

(Srinath M S) The datatable1.Merge(datatable2) statement will merge datatable2 into datatable1.

(Chris Webb) In the first two parts of this series (see here and here) I showed how Power BI/Power Query/Excel Get & Transform’s data privacy settings can influence whether query folding takes place or even whether a query is able to run or not.

(Pinal Dave) Recently, one of my client was trying to troubleshoot the below error which they were getting while trying to start the SQL Server service under the domain account.

(Grant Fritchey) The best way to learn any software is to start using it. There are a bunch of software tools in the SQL Server toolbox, but the biggest and most important is SQL Server Management Studio (SSMS).