One could be forgiven for thinking that there's little more you can do with third-party backup software than just ...er... backup databases. Shawn McGehee gives us his personal take on the implications of the improvements that have been made to SQL Backup for version 6.
Hiring a new employee can be a hit or miss proposition. We often don't learn much about how someone will work from an interview. Steve Jones talks about an alternative way to hire someone by taking them for a test drive.
Hiring a new employee can be a hit or miss proposition. We often don't learn much about how someone will work from an interview. Steve Jones talks about an alternative way to hire someone by taking them for a test drive.
Hiring a new employee can be a hit or miss proposition. We often don't learn much about how someone will work from an interview. Steve Jones talks about an alternative way to hire someone by taking them for a test drive.
To mentor or to protect data, what is the role of the DBA? A guest editorial from Matt Simmons.
Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often viewed as much art as science. A best practice that is essential yet often overlooked is disk partition alignment. Windows Server 2008 attempts to align new partitions out-of-the-box, yet disk partition alignment remains a relevant technology for partitions created on prior versions of Windows.
/*
A couple
of years ago, when I wrote the Simple-Talk Prettifier that is really no more than a stored
procedure...
Everything I've read about the built-in configuration options is that you can retrieve values from a SQL Server table, an XML file, etc. but I really prefer to just use the command line options. I'm currently specifying 10 or more command line options on average. Do you have any ideas on a better way to do this?
Take the new challenge from MVP Jacob Sebastian. Deadline is next Monday.
The wording of the statement about MySQL that came out from Oracle after the merger was downbeat. The implication was "Oh no! Another Blooming Database to deal with". But surely they don't plan to just let it drift?
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
When the schema of an object is changed, SQL Server wipes out the previous...
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
Comments posted to this topic are about the item The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers