Posts from ‘April, 2009’

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 (will be included in the newsletter coming [...]

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) [...]

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

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

(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 ways [...]