(Kenneth Fisher) We all know indexes are good and I’m hoping everyone knows you can have too many indexes. That means we should be careful when adding new indexes right? So when should we add a new index?

(Thomas LaRock) When discussions about upgrading to SQL Server 2016 are brought up the usual first question is this: “Why should we upgrade?” Someone, somewhere, wants to know why they should take a perfectly good system that runs just fine and make a bunch of changes.

(Arshad Ali) Microsoft introduced Azure SQL Data Warehouse, a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In my last article of the series, I talked about the different types of tables we can create in S

(Pinal Dave) One of my clients contacted me and informed that they have a node production clustered server and they recently noticed that the nightly error log had stopped cycling ERRORLOGs.

(Jack Vamvas) The Data Migration Assistant (DMA) has replaced the SQL Server Upgrade Wizard. The big difference is the Data Maigration Assistant also offers an option to Migrate the databases.

(Pedro Lopes) There are many instances in SQL Server management where one person would like to find all the TCP ports that SQL Server is binding to. Finding all the TCP ports that SQL Server is listening on might be for security related auditing, connectivity troubleshooting, or for some form of aut

(William Brewer) You can produce HTML from SQL because SQL Server has built-in support for outputting XML, and HTML is best understood as a slightly odd dialect of XML that imparts meaning to predefined tags. There are plenty of edge cases where an HTML structure is the most obvious way of communica

(Kenneth Fisher) tl;dr; While at one point the cost of a query was an estimated time to run in seconds, today it’s just an estimated number used to give an idea of scale.

(Pinal Dave) This error might have seen by DBAs and they know how to fix it. This blog goes in little details about what are the various options available. Here is the simple reproduction of the error message related to exclusive access.

(Jason Brimhall) Today I am doing a quick entry for my participation points in the monthly blog party called TSQL Tuesday. I have missed the past few opportunities for various reasons.