This articles covers a variety of techniques to let you bypass or conditionally execute code in a trigger based on criteria outside of the inserted/deleted tables. It also includes a contest that gives you a chance to win a copy of our book The Best of SQLServerCentral.com 2002!
2003-11-24
12,609 reads
This article by Andy Warren discusses how to use if update() in your update triggers to simplify your code. They are easy to use and quite effective!
2003-11-12
18,047 reads
This article by Andy Warren introduces some additional SQL-DMO methods that are very useful when automating administrative tasks.
2003-11-05
11,573 reads
We agree with Andy that Terminal Services is definitely a tool to have in the DBA toolbox. Like most tools, everyone uses them differently. Andy starts the discussion with some comments on how he uses TS - what about you? Do you use TS at all? Use it differently than Andy does? Prefer a different solution? Read the article and post a comment.
2003-10-14
7,467 reads
This article covers four of the fixed database roles (db_datareader, db_datawriter, db_denydatareader, and db_denydatawriter). If you're new to SQL security (and maybe even if you're not) this article is worth reading.
2003-10-10
10,606 reads
Andy discusses the low tech tools he uses at the office to convey problems and describe solutions. He also provides some interesting links you will want to browse.
2003-10-02
4,658 reads
We can only guess that someone somewhere put spaces in an object name that Andy works with and gave him the idea for this worst practice. Funny as the topic may sound, we agree - why make your lifer harder?
2003-10-01
7,781 reads
SP_addalias isn't a well known stored procedure to most DBA's - do you know what it does? In what situations you might use it? This short article gives very quick and clean answers to both of those questions.
2003-09-23
9,647 reads
We've had a soft launch under way for the past week, but now we'd like to sell the rest of the books stacked up at Andy's house! $15 plus shipping will get you a book that you'll be proud to put on your bookshelf. Read this to get latest pricing and answers to the most recent questions we've gotten.
2003-09-19
2,968 reads
This article by Andy Warren offers a free utility that will generate DSN's for all or just a subset of the databases on a server in seconds.
2003-09-19
10,046 reads
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Scientia Garden, Jl. Gading Serpong Boulevard No.1 Blok S, Curug, Kecamatan Kelapa Dua, Tangerang...
Jl. Cideng Barat No.53, Cideng, Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers