Exam Prep 70-463: Deploying projects in SSIS 2012

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...

Monitoring for Timeouts

The question came up at SQL Rally, “Can you use Extended Events to monitor for query timeouts?”
My immediate response was...

Lessons Learned from a Poor-performing VIEW

It is a “common knowledge” among SQL practitioners that VIEWs don’t perform well. Recently during an application’s development I put...

SQL backup directly to Azure storage

Most companies required to keep their database backup offsite (on tape) for many years due to audit requirement. This normally...

Future of Database Mirroring

One of the beloved feature of SQL server standard edition for HA is database mirroring, since you only have 2-node...

Data Compression–A unique feature PART–II TIP #92

In last post TIP #91  we talked about  What is Data compression ? What are the  features ?  Now in this tip...

Why I don’t (yet) recommend In-Memory OLTP to my customers

Ok, some of you will hate me after this blog posting, but it has to be said. Over the last...

T-SQL – How to get the Financial Quarter details of a date field

declare @table table
(
[Paid Date] date
)

insert into @table
values('20150102'),('20150512'),('20150830'),('20151231'),('20141230')

;WITH Quarters AS (
SELECT Q = 'Q1', MonthBegin = 1, MonthEnd = 3 UNION
SELECT Q = 'Q2',...

Using Solutions in SSMS

There are a handful of scripts I use on a regular basis. Adam Mechanic’s (b/t) sp_WhoIsActive, My sp_DBPermissions and sp_SrvPermissions,...

Audit Schema Change Report

In a recent article on SSG, I discussed how to use Extended Events to function in a Profiler like fashion.  You can read about that here.  I recommend reading...