datagod

3,682 reputation

522

bio	website	DBADepot.com
	location	Ottawa, Canada
	age	93
visits	member for	2 years, 1 month
	seen	2 hours ago
stats	profile views	147

I am a SQL Server DBA in Ottawa Canada, and an instructor with Learning Tree International.

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.

	3,682 reputation	bio	website	DBADepot.com	visits	member for	2 years, 1 month
522 badges		location	Ottawa, Canada		seen	2 hours ago

summary answers questions tags badges favorites bounties reputation activity

105 Answers

votes activity newest

23	How could DBAs be more 'programmer friendly'?
11	Why does my SQL Server database triple in size after deleting millions of records?
9	Referencing database programmatically via T-SQL
8	Electricity off while shrinking database, how can I recover my database?
7	How do I run a large script with many inserts without running out of memory?

3,682 Reputation

+15	When is it worth it to use Triggers and stored procedures/functions?
+10	Does a DBA need to know how to program in a system language besides SQL?
+10	Data obfuscation in SQL Server
+10	Converting RTF in a text column to plain text in bulk

19 Questions

votes activity newest

16	Justify NOT using (nolock) hint in every query
7	What is an appropriate datatype for an RFID, and is there a standard definition for the format?
7	What is the preferred method to roll out updates to hundreds of databases
6	What is the best approach to parsing a large amount of strings?
5	Do you know an easy way to generate one record for each hour of the past 12 hours?

101 Tags

145 sql-server × 75	34 sql × 17
63 sql-server-2008 × 29	31 database-administration × 6
38 sql-server-2005 × 11	30 best-practices × 4
35 sql-server-2008-r2 × 15	18 mysql × 6
35 database-design × 7	15 replication × 5