Using WMI Data Reader and WMI Event Watcher Tasks in SSIS
Windows Management Instrumentation (WMI) Tasks within SSIS can be used by to read WMI data and to watch for WMI events.
2010-01-14
2,270 reads
__Briefcase
Changing a Non-IDENTITY column to IDENTITY and vice versa
This article from new author Thomas Pieries, brings us a few methods for changing a Non-IDENTITY column to IDENTITY and vice versa as well as examining the advantages and disadvantages of each way.
2009-04-10 (first published: 2008-02-21)
36,633 reads
Using Parameters with Stored Procedures
It seems that SQL Server developers avoid stored procedures whenever possible, especially if they are new to the product. Kathi Kellenberger brings us a basic article that you can give to developers that explains the basics of how you use parameters with ADO.NET, especially output parameters.
2019-05-23 (first published: 2005-08-08)
118,959 reads
RE: Check SQL Server Uptime
checking SPID 1 login time versus current time will give you SQL server uptime. I use the following T-SQL to calculate number of Days my SQL servers are up: SELECT CAST((CAST(datediff(ss, login_time, getdate()) as Decimal(9,2)) / 86400) as Numeric(6,2)) FROM master..sysprocesses WHERE spid = 1
2003-07-07
1 reads
RE: Reading a system variable with TSQL
quote: I just need to create a windows system environment variable sql_backup_drive="X:\" for each SQL server and use it to determine the location of backup folder for each server in a multiserver job. I planned to use "subst" command for it, but it works really bad, if MSSQLSERVER service uses a domain account. Of all […]
2003-06-11
1 reads
2003-05-12
Logging logins
I am new to this site and to working with mssql. My question is this: we are running sql server 7.0 on windows NT. We are having a problem with logins being recorded in the log and eventviewer every few seconds while users are connected. The database as far as I can tell is set […]
2001-12-20
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