Testing a SQL Server environment before an upgrade
Learn how application and full regression testing can ensure a successful SQL Server upgrade – and save on money and performance headaches.
2009-04-09
2,403 reads
Articles
SQL Unit Testing
This article talks about an easy way to add hundreds of unit tests in your solution using SQL Load Test from Codeplex.
2009-04-08
9,754 reads
Container Tasks in SQL Server 2008 Integration Services
Learn how container control flow tasks within SSIS can be used by database developers to provide a structure to a package and repeat control flows.
2009-04-08
1,619 reads
Database level permissions for SQL Server 2005 and 2008
I am new to SQL Server 2005/2008 having administered SQL Server 2000 and below. I have heard there are a lot of new permissions at the database level. What are they and what do they give rights to perform?
2009-04-08
4,866 reads
Ruthless
Managing your time is a skill that is important in your career. Steve Jones talks a little today about why you might want to develop this skill.
2009-04-08
739 reads
Ruthless
Managing your time is a skill that is important in your career. Steve Jones talks a little today about why you might want to develop this skill.
2009-04-08
486 reads
Ruthless
Managing your time is a skill that is important in your career. Steve Jones talks a little today about why you might want to develop this skill.
2009-04-08
473 reads
Why Tape is Good
I write an editorial about why I thought tape still had a place in backups . There were some interesting responses that said disk works well for them and they wouldn’t go back to tape. I used to think the density was a big deal, along with cost, but maybe...
2009-04-08
1,399 reads
Creating a Linked Server - SQL School Video
Linked Servers allow SQL Server to access data on other systems, SQL Server, Oracle, Access, Excel, and others. MVP Andy Warren shows how to set one up in this SQL School video.
2009-04-07
6,702 reads
Dynamic SQL Merge
This article by new author Glen Schwickerath uses dynamic SQL and SQL Server 2008's MERGE statement to create a useful stored procedure tool for synchronizing tables.
2009-04-07
18,962 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers