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

Can an EKM Save The World of Data? - WaterOx Consulting

Reading Time: 4 minutesQuis custodiet ipsos custodes? Who will guard the guards themselves? – Latin...
The post Can an EKM Save The...

Azure Data Factory

What is the Azure Data Factory?
The Azure Data Factory is a managed service for data storage and processing.  It allows...

Making Sense of PCIe SSD Use with SQL Server

When Fusion IO burst onto the scene in 2007, offering a PCIe card that was said to be able to...