SQL Server has no change management integrated with the native tools. This means that each person must develop their own method of handling changes, or live with the chaos that will inevitably ensue. There are a number of articles written about various ways to handle change management and Dinesh Asanka shares his here. Read on and see if this helps you get a handle on changes in your environment.
2004-05-27
7,232 reads
Some days the simplest things go wrong. On this particular day Andy tried to remove a column that was part of an article in a transactional publication, wound up in an inconsistent state that required a snapshot to fix. Deeper investigation reveals the cause and a work around.
2004-05-25
7,549 reads
Do you know which of your databases are being backed up? Everyone answers "Yes", but I'm sure that there are times that someone creates a new database and you don't know about it. I know in my job, with hundreds of servers, it happens. Here's a technique for keeping track of those databases from Leo Peysakhovich.
2004-05-24
13,489 reads
Production DBAs may be a dying breed. At least according to some sources. While we're not sure that we agree with that, there is definitely a trend that should have you working on your career. The day of the DBA that only manages the operational data store is waning. Today's DBAs need to be flexible and have a number of other skills. Brian Knight looks at a few of the skills that you might to add to your arsenal to be prepared for the future of SQL Server.
2004-05-21
10,941 reads
Quest Central® for SQL Server is an integrated database management solution designed to enable administrators to manage complex database environments and simplify everyday tasks. Quest Central for SQL Server provides DBAs with a set of tools to achieve higher levels of availability and reliability, leverage and extend native SQL Server administration capabilities, and adds multi-server and change management capabilities to make database management easier.
2004-05-21
649 reads
Creating a system stored procedure isn't hard. You're always cautioned from making changes to the system, depending on the system for a particular functionality, etc., and you should be cautious. However adding system stored procedures to your servers can be beneficial and make your administration much more convenient. Read on the see how easy this can be to do.
2004-05-20
13,989 reads
The ORDER BY clause is one of the basic keywords that defines the SQL Language. And it can help prevent strange results from being returned to the average user. Read on to see how and why this addition to your queries can help ensure more "ordered" results 🙂
2004-05-19
11,528 reads
Apex SQL Tools has released Apex SQL Script 3.0, database Tools for database scripting. Apex SQL Script scripts both database structures (tables, views etc) as well as database data, which it converts to insert
scripts. The new release has a completely redesigned user interface, faster database scripting engine and many more database scripting options.
2004-05-18
518 reads
Do you have to refresh a test or QA server from the production system? Do you have a good process or is it a spur of the moment, let's get it done thing? Here's a look at Steve Jones' process, which was used weekly for well over a year.
2004-05-17
7,766 reads
What happens when you have a day job, a web site, a new job at work, and a baby? Chaos! See what Andy's been up to the past few months. It's off topic from SQL of course, but it contains an interested bit or two.
2004-05-14
5,534 reads
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers