One of the most pain-staking tasks a developer and DBA must often accomplish is to create an install procedure for the database. This involves creating the necessary DDL to create the tables, relationships and indexes. Inevitably in this process you forget about the data. AutoInserts to the rescue!
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.
Microsoft has the #1 OLAP product according to a new survey from Survey.com
Microsoft has announced that it is now accepting applications for beta testers for the latest service pack.
This article looks at some of the undocumented DBCC commands that exist in SQL Server 7.0
Microsoft has announced a new security program to help system administrators secure their sites. Worth a read.
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.
Microsoft has announced a new certification for system administrators. This is below an MCSE, but includes an elective which may be SQL Server.
Alexander Chigrik presents a few UDFs he has developed for getting meta data about your database objects.
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
We have veeam backups happening everyday on a server where all sql databases are...
Hello All, I am using TRY_CONVERT to parse character data into a decimal column....
Hi I am trying to assign the value of the variable using the output...
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers