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


Oct
23
awarded  Notable Question
Oct
21
reviewed Edit suggested edit on How do I select all child table records based on condition
Oct
21
revised How do I select all child table records based on condition
formatted sql query
Oct
21
comment Performance first low, then high after adding index, then keep high after drop index
Those commands were for SQL Server. When I commented, the original article did not specify the RDBMS. I assumed SQL Server. I was wrong.
Oct
17
answered Performance first low, then high after adding index, then keep high after drop index
Oct
17
comment DB Model for Small requiremnt
Is this homework?
Oct
10
comment Terrible Bad Query Plan
You are performing a double ended wildcard search on a string. No amount of indexes will help in that situation.
Sep
30
awarded  Explainer
Sep
23
awarded  Notable Question
Sep
16
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