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
5,000 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,779 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,549 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,836 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,108 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
17,385 reads
Blogs
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers