Archives: November 2013
DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS was the wave of the future. Everyone was so thrilled that posts like SSIS’ 15 faults and Why I hate SSIS: Part N+1 were all over the place, and I… Read more
You know I occasionally find it interesting how I learn new things. I was running through a practice test for the 70-461 and one of the questions had an odd command as one of the possible answers.
SET FMTONLY ON
Not something I had ever seen before, and as I… Read more
Beginning of period calculations are common things. Rolling month reports, queries to pull everything from last month etc require beginning of period calculations. Well here is a very simple pattern to get them.
DECLARE @DateConst datetime SET @DateConst = '1/1/2000' SELECT DATEADD(mm, DATEDIFF(mm, @DateConst, DateCol), @DateConst) FROM TableName
Dissecting it… Read more
When connecting to a SQL Server instance in SSMS there are a fair number of options. Most DBAs I know have only ever looked beyond the basics so I thought I would mention a few of the others.
First open a connection window in SSMS: BOL
This is what most… Read more
Every morning we have a daily meeting and my manager asks who’s on call. And every morning some form of the following pops into my head.
The new IT manager (Lou) walks into the DBA manager’s office (Bud).
Lou: Hey Bud I’m trying to get a feel for what’s going… Read more
I recently attended SQL Saturday #255 and specifically the performance tuning pre-con put on by Grant Fritchey. It was a great seminar and well worth the time (a very long day including travel) and money (not much). One of the many interesting discussions was on the missing index DMVs.… Read more
For those who don’t know the three physical join operators are Hash Match, Loop Join and Nested Loops. Understanding these operators is an important part of query tuning and understanding query plans. I had the privilege to watch Ami Levin do his presentation on physical join operators at SQL Saturday… Read more
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data sets.
- A list of principals and some basic properties about them.
- Role membership
- Object/Database/Server level permissions
Each row of each dataset has not only the appropriate properties but a… Read more