Having a consistent SQL Server environment is important. Gregory Larsen discusses one method of scripting your installation to ensure all of your SQL Server 2005 machines are set up the same.
2007-04-27
2,692 reads
The Maintenance Plan Wizard is a graphical interface for creating a variety of database housekeeping tasks. This article focuses on using SQL Server 2005 Maintenance Plan Wizard for creating Database Backup operations.
2007-04-25
2,582 reads
2019-05-30 (first published: 2007-04-23)
123,175 reads
DBAs have always been warned against using system tables in their code, but often there has been no other way to get information about the server. In SQL Server 2004, Dynamic Management Views have been provided that give you insight into almost every aspect of SQL Server. S. Srivathsani brings us a look at some of the DMVs and functions you can use.
2008-03-18 (first published: 2007-04-23)
17,603 reads
Service Pack 2 for SQL Server 2005 has had a few issues and one of the big ones is maintenance plans. Longtime DBA and developer Robert Pearl, of Pearl Knowledge Solutions brings us a fix for your maintenance plans.
2007-04-18
10,411 reads
2007-04-13
1,552 reads
What's the best way to change the default backup directory for a server, using SSMS or Enterprise Manager, without changing all the default directories at the same time? What is the TSQL to do it? A prize for the best correct solution.
2007-04-06
3,467 reads
2007-04-04
1,667 reads
his white paper covers some of the operational and administrative tasks associated with SQL Server 2005 security and enumerates best practices and operational and administrative tasks that will result in a more secure SQL Server system.
2007-04-04
3,297 reads
2007-04-03
1,378 reads
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item No Defaults Passwords Ever
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?