meta user
network profile
| bio | website | DBADepot.com |
|---|---|---|
| location | Ottawa, Canada | |
| age | 93 | |
| visits | member for | 2 years, 1 month |
| seen | 4 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.
|
Nov 9 |
comment |
Possible attack on my SQL server? Yes, mrdenny, that goes without saying. But they shouldn't be using SQL authentication in the first place, unless they are connecting from a non-microsoft network. |
|
Nov 8 |
comment |
Downgrading from SQL Server 2008 to 2005 Is this because you are developing in 2008 but your production servers are still 2005? Any solution you provide is just going to delay the inevitable while at the same time making your life miserable, as you will likely end up doing these downgrades on a regular basis. |
|
Nov 8 |
answered | Possible attack on my SQL server? |
|
Nov 2 |
comment |
Query Running Differently on SQL 2005 vs SQL 2008R2 Do you have the same amount of data in each environment? If the databases are recent copies, then I say the difference in SQL is enough to warrant rewriting your query. It should be re-written anyway. Sorry, it's the truth. |
|
Nov 2 |
revised |
Query Running Differently on SQL 2005 vs SQL 2008R2 I fixed the list. Supposed to be a number 4. |
|
Nov 2 |
answered | Query Running Differently on SQL 2005 vs SQL 2008R2 |
|
Nov 2 |
answered | Does it make sense to use SQL Server's bracket notation in hand written code? |
|
Nov 2 |
comment |
Does it make sense to use SQL Server's bracket notation in hand written code? Leading commas make it easier to comment out one line at a time in a large query, but it just does not look right, at least from a human language point of view. :) |
|
Nov 1 |
awarded | Autobiographer |
|
Nov 1 |
awarded | Analytical |
|
Nov 1 |
answered | How to delete a Backup from a backup set in SQL Server 2008 R2 |
|
Oct 27 |
awarded | Commentator |
|
Oct 27 |
comment |
Access exporting to CSV is weirdly slow King, yes that is what I meant. There is something definitely wrong with your computer, either at the OS level or at the drive level. This does not sound like a SQL Server problem at all. I suggest you start making backups and look into the matter asap. |
|
Oct 27 |
answered | Can I Simply Change A Transaction Log From Unrestricted to Restricted? |
|
Oct 24 |
answered | Access exporting to CSV is weirdly slow |
|
Oct 21 |
answered | Diet and exercise schema |
|
Oct 18 |
answered | Ordering by date and other columns |
|
Oct 5 |
comment |
How to know dependency on a table Peter, you could generate table scripts separately form the constraint scripts. Honestly though, 40 tables is not a huge amount. |
|
Oct 5 |
answered | Trigger shouldn't block insert |
|
Oct 3 |
answered | File MDF growth SQL Server 2008 |
