Enterprise wide Backup Audit
Enterprise wide Backup Audit that produces backup information in a csv format.
2010-08-06 (first published: 2009-11-10)
1,813 reads
Scripting
Using the Script Component With Multiple Outputs
This article demonstrates the use of the SSIS Script Component to create multiple outputs from unconventional data files.
2009-04-15
9,971 reads
Scripting INSERTs
A little procedure to quickly product a script for copying data from one database to another.
2008-12-29
11,455 reads
A Little DOS for a Poor DBA
Yakov Shlafman brings back the world of the command prompt to make life easier for a DBA that must deploy a series of scripts to their servers.
2008-11-06
12,599 reads
RE: Table rowcount
As you pointed out the sysindexes script only works if the index statistics are kept up-to-date. I think your best bet would be to keep them up-to-date and use the script otherwise you would have to use a script to run SELECT COUNT(*) FROM etc which would definitely not be efficient.
2005-05-27
2004-09-28
1 reads
RE: Ronald Reagan, 1911-2004
I was able to serve at his second inaugaration while in the military. I was proud to serve in the military under him. It hasn't been until I grew up a little more to finally realize what an incredible man he was who had clear ideas of right and wrong and was able to work […]
2004-06-08
RE: Command line network configuration
Look into the command line switches for MSDE2000 setup. I believe DISABLENETWORKPROTOCOLS=0 will install MSDE with tcp/ip enabled. Mike
2004-05-28
RE: Refer to a certain line of the DB
David - Wow! I'll test it, and return to You, soon! Thanks a lot, once again! Dalton
2004-01-28
1 reads
Newbie Replication attempt - getting "strange" error
Have SQL Server 2003 setup with 3 local instances of SQL Server 2000 (one default, two named) plus one named MSDE instance. Trying to setup replication on one of SQL instances. All are using Windows security exclusively. Have tried default and named instances going through the wizard. I try setting them up as their own […]
2004-01-09
2 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers