4,414 reputation
11536
bio website DBADepot.com
location Ottawa, Canada
age 95
visits member for 3 years, 9 months
seen 22 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.


22h
comment Sql Server - Running a Job on Multiple servers
@AaronBertrand, I guess I was thinking more of querying WMI from powershell. WMI does not exist on Windows 2000/2003 servers. Sadly, there are still a few of those kicking around.
1d
comment Sql Server - Running a Job on Multiple servers
Powershell does not exist on older version of SQL Server. Sometimes the wrong tool is the only tool.
Jan
27
awarded  Custodian
Jan
27
reviewed Close Any experience with cstore_fdw?
Jan
27
reviewed Leave Open How to convert postgresql dump files to oracle dump files?
Jan
27
reviewed Leave Open How to convert mysql to postgresql?
Jan
27
reviewed Leave Open Alternatives to MySQL Workbench
Jan
27
reviewed Leave Open Converting SQL Server 2005 schema to PostegreSQL 9
Jan
27
reviewed Leave Open Open Source Business Intelligence/DWH solutions
Jan
27
reviewed Close stored procedure examples
Jan
27
reviewed Leave Open tune MySQL with results from mysqltuner?
Jan
27
reviewed Close What are the implications of upgrading statistics SQL Server
Jan
27
reviewed Leave Open Is there a better way to filter error logs?
Jan
27
reviewed Leave Open Migrating a database from SQL Server 2012 to the cloud
Jan
21
awarded  Nice Question
Jan
10
awarded  Notable Question
Jan
8
awarded  Popular Question
Dec
16
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