As a DBA, we often need a way to track what events are occurring (changes that are being made) on SQL Server or at the database level. So what is a way to track these changes without much impact on SQL Server performance?
2010-10-08
5,125 reads
Another weekend, another new city, another SQL Saturday. This was my first trip to Kansas City, and it was a...
2010-10-08
1,401 reads
2010-10-07
799 reads
In this article Mohammad Meimandi explains an issue faced while using SQL-DMO to copy database objects.
2010-10-07
8,001 reads
Part 2 of the series on using MAP 5.0 looks at using the toolkit to inventory servers, preparing audit reports and server virtualization planning.
2010-10-07
2,031 reads
As I discussed in my first part of replication SQL Server 2008 Replication: High Availability Solution Part One, replication is...
2010-10-07
2,168 reads
A new series from David Ziffer describes a way of building applications in a more standardized fashion, and it provides a basic review of some software that can help.
2010-10-06
18,416 reads
The following production code is what I used for inserting and updating database tables using XML as the input. These scripts are for processing data for any table to insert or update data. The support functions provided, retrieve the table schema with their data types, functions to deal with XML dates, primary keys of the table and what fields can be updated. The following article breaks down this process from beginning to end.
2010-10-06
4,867 reads
Here is another one of those strange but true things that I come across every so often which I thought...
2010-10-06
3,573 reads
A look at Idera's Diagnostic Manager and how it can help you diagnose performance issues on your server instance.
2010-10-05
2,027 reads
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers