New Articles About Datazen, Microsoft’s Mobile Dashboard Platform

I’m pleased to share the first two articles in a series for SQL Server Pro Magazine.  Here’s a short excerpt...

Full Domain Trust and Natively Compiled Stored Procedures – In Memory OLTP

Recently one of my developers brought this specific problem to my attention. He was trying to create a natively compiled stored...

Migrating SQL Agent Jobs with Schedules using T-SQL

I’ve seen many a blog post about migrating SQL Agent jobs across instances using PowerShell, SMO, T-SQL, and the like....

Tuesday Morning SQL Break – May 26, 2015

It’s Tuesday (Monday was a holiday for me this week) and time for this week’s weekly blog and twitter round-up for...

Database Engine Tuning Advisor

I would love to see the Database Engine Tuning Advisor (DTA) pulled from the product. Completely. Heck, I feel bad that...

SQL Agent Job Wrapper Part 3 – Handing the Errors in the Wrapper Script

This is the 3rd installment in a small series of blog posts on how to create a PowerShell wrapper for...

Default database

What?

The default database is one of the options when creating a login in SQL Server. This is the initial database...

Microsoft Azure SQL Database – Dashboard

By David Postlethwaite
Once you have created your database you can now start to manage and configure it.
There are six...

SQL Server 2016 features I’m interested in

Microsoft announced this month what features/improvements will be in the next version of SQL Server, SQL Server 2016. You can...

SQL Server 2016 features I’m interested in

Microsoft announced this month what features/improvements will be in the next version of SQL Server, SQL Server 2016. You can...