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


2d
reviewed Approve I can't divide 2 count(*) values without returning zero
Nov
27
comment SQL Server doesn't use expected index
Are the statistics up to date?
Nov
2
revised sql server license
added 153 characters in body
Nov
2
comment sql server license
Nope. With SQL 2008, cores are NOT counted towards a licence. It is the big old chip that fits in a the socket. Does not matter how many cores are in it. However, not many production class servers only have one CPU.
Oct
23
awarded  Notable Question
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 Parallel Plan Selection
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 AWS RDS MSSQL Extremely Slow compared to EC2 with MSSQL
Sep
12
reviewed Approve 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 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 Creating a table with many optional fields
Aug
6
reviewed Approve Selecting data from multiple rows and insert it into a column