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...

SQL Server 2016 SP1 Release - Thoughts and Comments!!!

SQL Server 2016 SP1 has released last night and most of the features that were previously part of enterprise edition...

Why would you never use SSIS Fast Load…?

We all know that if you want SQL Server to push data into a table then you want to batch the...

DLM Automation–Making a Database Connection

One of the things I’ve been wanting to do is dig more into the command line automation cmdlets from the...