CREATE SCHEMA can do what?!?!?

So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t...

Creating a SharePoint 2013 Demo Environment – Part 1: Setting Up A Domain Controller

Development and demo environments can be hard to come by. Over the course of this series you will learn how...

Digby’s Top 10 reasons you need a DBA

Digby! helps to demonstrate the top 10 reasons you need a dedicated SQL Server DBA.

They can handle unexpected database growth...

Get synonym definitions for all databases in server

If you want to audit your enviroment to look at all your synonyms and see where they are pointing, you...

Microsoft Lync Through the Web

Get an invite to a Microsoft meeting? Are they using the new Lync interface? And, you don’t have a paid...

SQL Saturday Atlanta was incredible

This past Saturday I was fortunate enough to present a session at the largest SQL Saturday EVER in Alpharetta GA....

Sql server 2012 links

Feature of sqlserver 2012 http://arifudin.com/sql_server_2012_features good alternative to dbcc ind in sqlserver 2012 SYS.DM_DB_DATABASE_PAGE_ALLOCATIONS http://www.jasonstrate.com/2013/04/a-replacement-for-dbcc-ind-in-sql-server-2012/

SQL Server Security Webcast Questions – Series Introduction

Earlier this month, I presented an Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s.  A video...

There is currently a lease on the blob and no lease ID was specified in the request

I’ve been using the backup to Azure feature that shipped with SQL2012 SP1 CU2 and generally it works really well,...

Wait Stats – Monitoring and Using

sys.dm_os_wait_stats is one of the most important DMVs out there, and one that you should know the historical values of...