4,314 reputation
11232
bio website DBADepot.com
location Ottawa, Canada
age 94
visits member for 3 years, 4 months
seen 5 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
awarded  Famous Question
Sep
14
reviewed Approve suggested edit on AWS RDS MSSQL Extremely Slow compared to EC2 with MSSQL
Sep
12
reviewed Approve suggested edit on Best practice for testing database disaster recovery
Sep
11
comment Create food database
Is this a homework question?
Sep
11
comment Import from one table in two tables where I need the auto-generated primary key in the second table
Look into the OUTPUT INTO clause of the insert command (mssqltips.com/sqlservertip/2183/…)
Aug
21
reviewed Approve suggested edit on average record hourly
Aug
8
comment LDAP in SQL Server 2012
@mrdenny, were you trying this with SQL Server 2012 and Windows Server 2012? I can't get it to work, even after following the instruction you provided.
Aug
6
reviewed Approve suggested edit on Creating a table with many optional fields
Aug
6
reviewed Approve suggested edit on Selecting data from multiple rows and insert it into a column
Jul
31
awarded  Necromancer
Jul
31
awarded  Enlightened
Jul
31
awarded  Nice Answer
Jul
30
reviewed Leave Open Can I automate data pulling from VistA databases using MUMPS?
Jul
30
reviewed Leave Open How to provision the SQL Server Agent service after SQL Server Edition upgrade
Jul
30
awarded  Custodian
Jul
30
reviewed Leave Open SQL Server Deadlock - Two SELECT Exclusive Locks on Exact Same Index and Key
Jul
30
reviewed Leave Open Find out which client IP and Query using highest network Bandwidth from SQL Server
Jul
30
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