(Jack Vamvas) Question: There is lots of information around the SQL Server Change Data Capture (CDC) feature, and I’m trying to decide if CDC is suitable for the purposes of a project which requires data auditing.

(Jason Brimhall) One of my most favorite things in the world is the opportunity to deal with extremely varying database and environment requirements. Many vendors and databases seem to have a wide swath of different requirements.

(Chris Webb) Maybe this is obvious to more experienced Power Query users, but something I always point out when I’m training people up on Power Query is that the order that you select columns in the Power Query Editor window (both in Power BI Desktop and Excel) can affect the output of certain trans

(Pinal Dave) Most of the time applying service pack for SQL Server is a child’s play. Double click on exe, keep hitting next, next and finally press update. But when it fails, you would need an expert to fix the issue. Recently, one of my clients faced a problem while installing SQL Server 2014 Sp2.

(blobeater) I have come to understand the importance of using columnstore indexes when my queries are aggregating and scanning across many millions of rows.

(Christopher Witte) I ran into an issue where I was running out of storage on the Load Test Repository DB. I knew that there were a ton of old aborted runs and other runs I didn’t need.

(Tracy Boggiano) In most shops you don’t have just one Availability Group, you probably have several Availability Groups to monitor or check the status. Opening up SQL Server Management Studio and drilling down to look at the dashboard for each and every Availability Group to see the status is very

(Anoop Kumar) Microsoft HDInsight is the cloud service that deploys and provisions Hadoop clusters on the Azure cloud. HDInsight is a completely managed and open source analytics service to support enterprise needs. HDInsight supports a wide variety of scenarios with the help of open source framewo

(Thomas LaRock) If you have ever wanted to hide an instance of SQL Server, this is the post for you. Read on.

(Kenneth Fisher) There has been talk of a dark theme for SSMS for years. Does it exist, will it exist? Well, the answers really are yes, and no. And by that I don’t mean yes and no as in maybe. I mean litterally, does it exist yes and will it exist no.