4,045 reputation
925
bio website DBADepot.com
location Ottawa, Canada
age 94
visits member for 2 years, 11 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.


Nov
28
answered Possible pitfalls of condensing 2 SQL Server instances into 1
Nov
25
answered Can an article in Sql Server replication be based upon a query?
Nov
25
revised Is it possible to have 2 or more databases active, and synchronized between them?
fixed my own typo
Nov
25
answered Why are views not copied over when using SQL Server Log Shipping?
Nov
24
answered Querying special characters
Nov
23
comment How do I get back some deleted records?
When's the last time you tested a RESTORE of your backups?
Nov
23
comment How do I get back some deleted records?
Great answer, Brent. I just went through the same exercise this morning.
Nov
23
answered SQL Server Express 2008 installation problem
Nov
21
comment How to get super parent from table with self relationship
If you are still modelling the table, I suggest you take a look at the HeirarchyID datatype in SQL 2008.
Nov
21
comment How can I make my SSIS process consume more resources and run faster?
You are assuming that the process is CPU bound, which from your own graphs shows that it is not. My guess is that the perceived performance problem is I/O related, not CPU. What type of drive configuration are you using?
Nov
21
accepted Is there any way to turn off the “loading” message when a page refreshes in Reporting Services?
Nov
18
comment Is there any way to turn off the “loading” message when a page refreshes in Reporting Services?
SSRS 2008R2, built-in refresh every 30 seconds. When I look at the code of the webpage, I can see "WaitControlBackground" class, with some configured values. I just wish I could find the same thing in BIDS.
Nov
18
asked Is there any way to turn off the “loading” message when a page refreshes in Reporting Services?
Nov
18
comment What's better for large changes to a table: DELETE and INSERT every time or UPDATE existing?
It is faster than updating then inserting the ones that did not already exist.
Nov
18
answered Storing Passport Numbers in a database
Nov
18
answered What's better for large changes to a table: DELETE and INSERT every time or UPDATE existing?
Nov
18
comment How to optimize this dynamic stored procedure
Why do you want to avoid using a temp table? They are quite handy for simplifying code.
Nov
17
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. The license fee you pay is per year.
Nov
17
comment sql server license
You must have a starting figure. 10? 20? And the 5000 is per CPU. How many CPU's will you have?
Nov
17
comment sql server license
I would add to gbn's comment...CAL's apply to devices as well as people. Any hunk of code that has to connect to the database would require a CAL.