This article shows you one of the most time saving stored procedure built into SQL Server and then shows you how you can modify it to affect additional objects like triggers. For example, after this article and the code in the article, you'll be able to disable every trigger in your system in one line of code.
2002-06-17
16,530 reads
This week, SQLServerCentral.com launched its Resource Center all about getting a sneak peak on Yukon. All links are user contributed.
2002-06-14
21 reads
SQLServerCentral.com launched its first online free software, which can evaluate your SQL Server remotely and look for SQL Server security vulnerabilities. This free service looks for weak or no passwords and does a basic penetration test online.
2002-06-13
57 reads
Oleg Dantchenko has updated his very successful freeware product, SQLExecMS to release 1.5. The new release has a new look, more features and is perfect for rapid development and quick DBA work.
2002-06-12
61 reads
Welcome to the first SQLServerCentral.com SQL Server Best of Breed Product Awards. These awards allow you to reward the products that you feel are the best in the SQL Server industry. These awards are user nominated and users vote for the winners.
2002-06-10
21 reads
Andy has written several good articles for us on maintenance plans - including some stuff that makes us a little more likely to use them! This week he talks about how and when old backups are removed by maintenance plans. A page turner! Well, it's only one page, but you know what we mean!
2002-06-10
7,598 reads
Recompilation yields superior performance in some situations, although excessive recompilation can be detrimental. This article will discuss some of these costs and benefits, and will draw on contrasts between different versions of SQL Server to provide further context for understanding recompilation.
2002-06-07
1,291 reads
Ever wonder who an MCDBA helps? Andy has posted the results of a recent survey of MCDBA's conducted by Dr. McKillip of Southern Illinois University. It's interesting reading. If you have time read and add your comments to the discussion!
2002-06-06
6,818 reads
Our friends at Redgate asked us to pass this URL on to our readers. It's a very quick survey, help one our great supports by following the link!
2002-06-06
649 reads
SQLServerCentral.com has now launched it's third Resource Center. This one focuses on giving the reader everything they need to know about licensing SQL Server. All links in this area are user contributed.
2002-06-05
80 reads
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item This Week's AI Trust Problem...
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers