Microsoft Corp. is planning to deliver updates to its Exchange Server product every two years and is considering a similar move to deliver SQL Server updates in a more timely manner, company officials said at the TechEd 2004 conference.
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.
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.
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.
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.
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.
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.
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 🙂
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.
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.
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
Recently I received a cry for help over Teams. The issue was that an...
By davebem
I was the principal author of this SIOS whitepaper, which describes how to build...
Hi - I'm looking for advice regarding the best & quickest way to establish...
Hello. I am looking for a tool Data cleansing/conversion, was recommended HPE any...
I have a query that runs in a job to check on orphaned users....
I have this data in a SQL Server 2022 table:
player yearid team HR Alex Rodriguez 2012 NYY 18 Alex Rodriguez 2013 NYY 7 Alex Rodriguez 2014 NYY NULL Alex Rodriguez 2015 NYY 12 Alex Rodriguez 2016 NYY 9If I run this code, what are the results returned in the hrgrowth column?
SELECT player , yearid , hr , hr - LAG (hr, 1, 0) IGNORE NULLS OVER (ORDER BY yearid) AS hrgrowth FROM dbo.playerstats;See possible answers