(Derik Hammer) In the last post of this blog series, I discussed what a B-Tree index was and briefly explained its history.

(Bridget Botelho) SQL Server 2016 is on the launch pad for a June 1 release with a number of notable built-in features along with improvements to some long-neglected capabilities.

(Pinal Dave) Even if you are a DBA, sometime you need to deal with issues which are not related to SQL Server. It is not by design, but this is part of our job description. It is always interesting to troubleshoot such issues and find a solution.

(Hannes du Preez) Ever wondered if you could determine how the SQL Statements will be executed?

(dbafromthecold) One of the new features that’s coming with SQL Server 2016 is Dynamic Data Masking. DDM is designed to allow DBAs to limit exposure of sensitive data within a database with minimal (if any) changes required to existing queries.

(Colleen M. Morrow) This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database Engine.

(Derik Hammer) If you’re not familiar, T-SQL Tuesday is a blogging party hosted by a different person each month.

(Greg Larsen) In my last two articles (Allow Access to Only a Subset of Rows Using Row Level Security, and Blocking Updates at the Row Level) I discussed implementing Row Level Security using SQL Server 2016. Row Level security is all about restricting database users from being able to view, or upd

(Prashanth Jayaram) One of my blog reader requested me to get the DB details(Server,DBName,Size,SpaceAvailable,LogSize,PercentUsed Log Space,compatiblilty mode, recovery model etc:-) using PowerShell hence this post is written.

(Ghanesh Prasad) My Excel source file has data in multiple worksheets and I need to read data from all of these sheets and load it into SQL Server destination table, how can I do this using SSIS?