Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQLStudies

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at www.sqlstudies.com.

Archives: November 2013

Finding active DTS packages

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

0 comments, 1,537 reads

Posted in SQLStudies on 27 November 2013

Finding the metadata for a query

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

0 comments, 230 reads

Posted in SQLStudies on 25 November 2013

A pattern to do beginning of period calculations.

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

0 comments, 190 reads

Posted in SQLStudies on 20 November 2013

Connection options in SSMS

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

0 comments, 218 reads

Posted in SQLStudies on 18 November 2013

Who’s on call

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

0 comments, 233 reads

Posted in SQLStudies on 13 November 2013

A better way to find missing indexes

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

10 comments, 213 reads

Posted in SQLStudies on 11 November 2013

Physical Join Operators by Ami Levin

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

0 comments, 169 reads

Posted in SQLStudies on 6 November 2013

sp_SrvPermissions & sp_DBPermissions V3.0

These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data sets.

  1. A list of principals and some basic properties about them.
  2. Role membership
  3. Object/Database/Server level permissions

 
Each row of each dataset has not only the appropriate properties but a… Read more

0 comments, 1,259 reads

Posted in SQLStudies on 4 November 2013