More Ideas About Using SQL-DMO
This article by Andy Warren introduces some additional SQL-DMO methods that are very useful when automating administrative tasks.
2003-11-05
11,618 reads
This article by Andy Warren introduces some additional SQL-DMO methods that are very useful when automating administrative tasks.
2003-11-05
11,618 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,481 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,737 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,662 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,807 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,666 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,978 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,068 reads
Andy reviewed v1.51 almost two years ago, this week he looks at the latest release that includes one feature he really wanted - the ability to compare and sync text columns.
2003-09-12
8,568 reads
The columns_updated function gives you the ability to easily test to see if specific columns were modified with less code than you might otherwise need to use. In this article Andy Warren demonstrates how to create a trigger that uses this function and points out some reasons why you may NOT want to use it!
2003-08-21
18,265 reads
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
WhatsApp CS 628218520154 Ruko Atrium Blok E. 12-13, RT.5/RW.18, Sunter Agung, Kec. Tj. Priok,...
WhatsApp CS 628218520154 Jl. Bungur Besar Raya No.32 & 32A, RT.3/RW.1, Gn. Sahari Sel.,...
WhatsApp CS 628218520154 Jl. Cempaka Putih Raya No.118 B,C,D, RT.16/RW.3, Cemp. Putih Tim., Kec....
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers