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

Audit Schema Change Report

In a recent article on SSG, I discussed how to use Extended Events to function in a Profiler like fashion....

SQLRally Nordic 2015

Last week I attended SQLRally Nordic 2015 in Copenhagen. SQLRally is a regional conference organized by PASS, kind of a...