2001-10-26
1,436 reads
Articles
Scrubbing Data With DTS : Part 2
Chances are, if you've dealt with any type of data, you know you
rarely receive the data in perfect condition. In this second article in the series on cleaning data, Brian Knight shows you how to scrub data with a more advanced method.
2001-10-25
4,984 reads
Microsoft Analysis Services Trounces the Competition
Microsoft has the #1 OLAP product according to a new survey from Survey.com
2001-10-25
4,539 reads
Service Pack 2 Beta Program for SQL Server 2000 Announced
Microsoft has announced that it is now accepting applications for beta testers for the latest service pack.
2001-10-22
5,770 reads
SQL Server 7: Some Useful Undocumented DBCC Commands
This article looks at some of the undocumented DBCC commands that exist in SQL Server 7.0
2001-10-22
7,239 reads
Microsoft Announces a New Security Program
Microsoft has announced a new security program to help system administrators secure their sites. Worth a read.
2001-10-19
4,120 reads
Understanding the Implications of ANSI SQL92 SET Options
Have you ever experienced a T-SQL query, a stored procedure, view or a trigger returning unexpected results. In this article by Raj Gill, he shows you how ANSI DEFAULTS may be to blame.
2001-10-18
10,483 reads
New Certification - MS System Administrator
Microsoft has announced a new certification for system administrators. This is below an MCSE, but includes an elective which may be SQL Server.
2001-10-18
1,223 reads
A Few Meta Data UDFs
Alexander Chigrik presents a few UDFs he has developed for getting meta data about your database objects.
2001-10-17
4,087 reads
Executing a script from SQL Server
Running a script automatically from SQL Server is easier than you think. Here are a few methods you can use.
2001-10-17
16,002 reads
Blogs
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find...
SQL Server 2022 Administration Inside Out
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
WIT/DEI Mental Health and Wellness Day Challenge to Present
Back in December 2019, I started presenting my session on mental health with lots...
Forums
Get a Date Time Stamp of table when another columns value changes.
I am having Below Table i want to get Result as shown in the...
how to write a query by using some filter patterns in SQL Server?
what I want is to apply some filter patterns to search the data. For...
Tsql query to show currently running sql agent jobs
Hi All, Using Tsql query I want to know currently running sql agent jobs...
Ask SSC