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,995 reads
Microsoft has the #1 OLAP product according to a new survey from Survey.com
2001-10-25
4,539 reads
Microsoft has announced that it is now accepting applications for beta testers for the latest service pack.
2001-10-22
5,776 reads
This article looks at some of the undocumented DBCC commands that exist in SQL Server 7.0
2001-10-22
7,518 reads
Microsoft has announced a new security program to help system administrators secure their sites. Worth a read.
2001-10-19
4,120 reads
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,813 reads
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
Alexander Chigrik presents a few UDFs he has developed for getting meta data about your database objects.
2001-10-17
4,102 reads
Running a script automatically from SQL Server is easier than you think. Here are a few methods you can use.
2001-10-17
17,096 reads
2001-10-15
3,969 reads
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
By Steve Jones
It’s been a good year for me. With my sabbatical, I felt like I’ve...
By alevyinroc
In less than one month, I will be speaking not once but twice at...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Powershell script to generate SQL...
Comments posted to this topic are about the item Database Ledger in SQL Server...
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers