4,542 reputation
11640
bio website DBADepot.com
location Ottawa, Canada
age 95
visits member for 3 years, 11 months
seen 11 hours ago

I am a SQL Server DBA in Ottawa Canada.

I am the founding partner of DBA Depot and the president of Metropolis Dreamware and Cooking With SQL. We provide database consultants to various public and private sector organizations.

I am a technical editor for SQL Server Magazine and the author of the T-SQL 101 series of articles / e-book.

I have been a SQL Server DBA since the bad old days of SQL 4.2.


Apr
5
answered SQL Server 2008 R2 - Set tempDB size on full disk
Apr
4
comment How to scale my SQL Server 2008?
Before undertaking the upgrade process, have tackled performance tuning the most expensive queries?
Apr
4
comment Using SSIS to get record counts for tables that may not exist
Cool. Learn something new every day.
Apr
4
accepted Using SSIS to get record counts for tables that may not exist
Apr
4
comment Using SSIS to get record counts for tables that may not exist
I thought of that, but then the problem of how to pass the value of the count back to a variable, which in turn is being passed back into SSIS so I can further manipulate it.
Apr
3
asked Using SSIS to get record counts for tables that may not exist
Mar
31
revised Upper or Lower Case Optimisation on MS SQL Server
fixed a typo
Mar
30
answered Upper or Lower Case Optimisation on MS SQL Server
Mar
29
awarded  Popular Question
Mar
22
awarded  Self-Learner
Mar
21
comment Are Views optimized when I add a WHERE clause to them?
Be warned: views that make your life simpler, will make somebody else's life simpler. Somebody is eventually going to discover your view and say "Wow, this is great! I can't wait to join this view to 5 other views". Pretty soon you a very slow processes, and you won't be able to change your view because so many other queries out there rely on it.
Mar
21
answered What is an appropriate datatype for an RFID, and is there a standard definition for the format?
Mar
21
comment What is an appropriate datatype for an RFID, and is there a standard definition for the format?
After posing this question, I found my answer on Stackoverflow: stackoverflow.com/questions/925002/…
Mar
21
asked What is an appropriate datatype for an RFID, and is there a standard definition for the format?
Mar
20
comment Can you recover to a point in time using the LDF?
Step 0: put the database into administrative use only. You don't want other updates to be happening while you research the issue.
Mar
16
answered Why does my SQL Server database triple in size after deleting millions of records?
Mar
16
comment Can I be automatically notified of prolonged blocking in SQL server?
I was just trying to show how start investigating...it is an old proc though...likely won't work on 2012
Mar
15
answered Can I be automatically notified of prolonged blocking in SQL server?
Mar
14
comment Microsoft SQL server 2008 and linked servers
Linked servers are fine for simple queries, but dont' expect great performance when dealing with cross server joins and whatnot. I recommend using linked servers mainly for administrative tasks / batch imports, etc.
Mar
13
comment Which SQL Server system database is more important: master or resource?
What is more important, front end or back end? You need them both.