4,279 reputation
1232
bio website DBADepot.com
location Ottawa, Canada
age 94
visits member for 3 years, 3 months
seen 10 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.


1d
reviewed Leave Open Can I automate data pulling from VistA databases using MUMPS?
1d
reviewed Leave Open How to provision the SQL Server Agent service after SQL Server Edition upgrade
1d
reviewed Leave Open Lookup tables with long lookup values?
1d
reviewed Leave Open SQL Server Deadlock - Two SELECT Exclusive Locks on Exact Same Index and Key
1d
reviewed Leave Open Find out which client IP and Query using highest network Bandwidth from SQL Server
1d
reviewed Leave Open How do I place leading zeros for numbers less than 10 without affecting those 10+?
Jul
27
reviewed Approve suggested edit on How to use the dbms_sql to get the analyze for insert into statement
Jul
25
reviewed Approve suggested edit on Need Advice on Normalizing Database
Jul
24
reviewed Reject suggested edit on How do I place leading zeros for numbers less than 10 without affecting those 10+?
Jul
23
reviewed Approve suggested edit on Inserting a new lookup value for the SSIS Lookup Transformation
Jul
22
reviewed Approve suggested edit on How I can force the TSQL-Developers to use not deprecated TSQL?
Jul
22
reviewed Approve suggested edit on I am not sure why I am getting the “Invalid column name”, same code works on my other calculators…
Jul
22
reviewed Approve suggested edit on SQL Server 2008 R2 memory issue
Jul
16
reviewed Approve suggested edit on what is '#' in create table statement?
Jul
15
reviewed Approve suggested edit on How to join two tables and fetch in android apps using js
Jul
7
reviewed Approve suggested edit on SQL Server shows database in recovery
Jun
7
reviewed Approve suggested edit on Running a TPC-C Benchmark Without sleep() i.e. key-in + think time
May
7
reviewed Approve suggested edit on MySQL Identifying Connection Attempt
May
7
reviewed Approve suggested edit on MySQL server taking up 100% CPU
May
7
reviewed No Action Needed What could be causing strange query timeouts between PHP and MySQL?