What Permissions do I need to generate a deploy script with SSDT?

It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or still automatically but at a later date plus you...

Creating a Self-Contained Multi-Subnet Test Environment, Part I – Networking

For a recent presentation on using availability groups for disaster recovery, I needed a test environment that contained multiple separate...

Excel Tip #25: Overlaying Charts

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

Speaking at IT/Dev Connections

I am very happy to announce that I will be presenting two sessions at this year’s IT/Dev Connections conference in Las Vegas!...

Query Hash Formula Changes Between Versions

The question came up on SQL Server Central that someone wanted to track queries on their 2008R2 instance and on...

How to Configure E-mail in SQL Server Step by Step–TIP #96

 
For different reason we need to send database report , data and other SQL Server database related stuff using E-mail . SQL ...

Follow the yellow brick what? My road to public speaking.

Follow the yellow brick Road!
Original Image Credit: airdiogo on flickr
If you would have asked me 2 years ago if...

Moving SQL Server data between filegroups – Part 1 – Database Structures

Why is moving data between filegroups hard?
****As a consultant its common to walk into a customer site and find databases that are contained in one very large file. For...

SQL 2014 CU5

By David Postlethwaite

If you are using SQL Server 2012 or 2014 RTM you will find that SSMS offers very limited...

In-Memory OLTP: Part 3 – Checkpoints

This post follows on from In-Memory OLTP: Part 2 – Indexes
So far in this blog series memory optimised tables have been...