New home for SQL Server Citation

Change is inevitable, it's natural. I would like to quote few lines from Shrimad Bhagavad Gita says     Change is the...

Attaching Database Using SMO & Powershell

Steve Jones wrote a great article on using this automation here titled The Demo Setup-Attaching Databases with Powershell. I threw...

Book Review: Marshmallow Test

Different people approach their career in different ways. My working assumption, all the time, is that I don’t know enough...

Delayed Durability in the wild…

Background
We have recently been working on large data migration project for one of our clients and thought I would share...

Friday Reading 2016-11-18

Another week almost over so in-between daydreaming about relaxing this weekend I’ll be reading…
https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/

SQL Server 2016 SP1 has been released....

More dbatools–Get-DbaTcpPort

After the MVP Summit, I was excited to check out more code and features in all aspects of SQL Server,...

#SQLNewBlogger – T-SQL ESCAPE for Wildcards

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Microsoft Connect(); announcements

Microsoft Connect(); is a developer event from Nov 16-18, where plenty of announcements are made.  Here is a summary of the...

Query Store changes in SQL Server vNext CPT1

Not only did we receive a brand new Service Pack for SQL Server 2016 this week, since yesterday we are...

Residual Predicate and "Number of Rows Read" in Execution Plans

What is Residual Predicate?

Lets say one gets a query to fine tune. While checking the execution plan, if there is...