4,259 reputation
1030
bio website DBADepot.com
location Ottawa, Canada
age 94
visits member for 3 years, 3 months
seen 20 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 Approve suggested edit on Need Advice on Normalizing Database
2d
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
23
revised SPARSE Column in SQL Server
I added a link to Microsoft's description of sparse columns
Jul
23
comment Setting up a new database
This question appears to be off-topic because it seems to be a homework type question, or a general design question.
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
21
comment Is there a better way to filter error logs?
It should be noted that if you have not cycled your errorlogs lately, this script will take a while before it finished chugging through it all
Jul
21
answered Is there a better way to filter error logs?
Jul
16
awarded  Popular Question
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
11
comment Slow SQL Server query using a DB2 linked server in virtual environment
Make sure the query is optimized first. Run it directly on the linked server (i.e. run it locally on the DB2 machine) and make sure the indexes support your query. I also noticed you are not wrapping your dates in quotes. This may end up in a non SARGable query, causing a table scan on the target. Do you need every single column returned? If not, name the columns specifically.
Jul
11
comment Data modeling with many attributes where few apply to each record
I don't understand why option 1 has to be a very wide table as opposed to a series of small related tables i.e. what is wrong with a traditional relational database design?
Jul
10
comment Are these linked server queries susceptible to SQL injection?
I am not positive, but I would think that given enough effort a malicious person could abuse it. I will run some tests.
Jul
10
answered Are these linked server queries susceptible to SQL injection?
Jul
7
reviewed Approve suggested edit on SQL Server shows database in recovery
Jul
4
answered Create and fill temp table
Jul
4
answered removal of GUIDS used for all PK's, FKs & Clustered indexes