Rotating Header Image

Posts from ‘April, 2009’

EDMPASS Initial Meeting!!

OK here we go… In May the Edmonton Chapter of PASS is going to have it’s 1st meeting. Details below: Date:  May 28th 2009 Time: 5:00 pm – 7:00 pm Location: Stanley A. Milner library Map: 7 Sir Winston Churchill Square Meeting Room: 6th Floor – Room 7 Speaker: Scott Gillespie Topic: To Be Determined […]

Server Role Audit – a quick and dirty script

Every now and again I like to run a quick audit of the SQL Servers I support and ensure that logins do not have any elevated permissions on a server. With properly auditing and tracking you should be able to identify any problems when they happen but it doesn't hurt to give the server(s) a […]

Moving Blues… did I mention I hate moving? lol

So I moved this weekend and when I finally got things setup and logged into my google reader I was met with over 50 new unread items. I always do a quick scan and mark off the articles I’m going to read first and then go back and read those and then continue on with the […]

Leading Zer0000000000s

So I got an email question asking for a way to pad a column with leading zeros into a 10 digit text/number (the person had an Oracle background and was cursing at the lack of LPAD in SQL Server). There are a few different ways to solve this problem so we're going to look at […]

Great EXCEPTations

(OK I fully understand how lame the title of this post is but hey it’s the best I could do so live with it) I am guilty of favoring particular syntax over other options. This is mainly due to habit so every now and again I like to take some time and look at other […]

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.