SQL Server 2000 brought us DTS, a new way of working with data movement for SQL Server DBAs. However, unlike Integration Services and Project REAL, there weren't any great standards for working with this tool and building portable solutions was hard. Jonathan Stokes brings us a great article on how you can create a standard structure for your packages and make them more portable.
This is the forth article in the transaction and lock series. Up to now, the locks and hints discussed have applied to both SQL 2000 and SQL 20005. However, this article will introduce Snapshots, new in Microsoft SQL 2005.
To null or not to null: that is the question. The specific focus here is performance implications of NULL versus NOT NULL columns.
I'm sure most DBAs don't give a second thought to starting and stopping their SQL Server 2000 servers. But do you know the different ways to do this and some of the impacts and expectations you should have? Especially with hardware growing, it's not always as simple and straightforward as it should be. Andy Warren recently had to deal with some issues and starts a new series looking at the various ways of starting and stopping SQL Server.
Part I of this article illustrated how to monitor CPU usage of running processes on a local machine or from a remote machine. This article illustrates how to monitor the CPU usage of different running processes on different machines and collect the information in a database.
SQL Server 2000 databases seem to move more often than their DBAs would like. However, moving the logins and users can prove to be a bit more of a challenge than just moving the databases. New author Corey Bunch brings us his technique for making this easier.
It's been five years since Microsoft released a new DBMS, but both experts and users agree that this one was worth the wait. SQL Server 2005's enhancements and new features have made the system a much more attractive attractive option to both large and small shops. Nonetheless, upgrading to SQL Server 2005 is a serious undertaking, requiring extensive training, planning and testing. In this Learning Guide, you will find news, technical tips and expert advice to help address your questions and concerns regarding SQL Server 2005 and put you on the road to a successful upgrade.
Most time we probably think that lots of our code is confusing, but when working with data values that need or contain quotes, it can get especially confusing. Sean McCown looks at a method for making this code easier to read.
The dynamic management views (DMVs) in SQL Server 2005 are designed to give you a window into what's going on inside SQL Server. They can provide information on what's currently happening inside the server as well as the objects it's storing. They are designed to be used instead of system tables and the various functions provided in SQL Server 2000. This article provides an introduction to DMVs and covers a few of the basic views and functions.
Everyone seems to focus on the large scale, enterprise level installations of SQL Server with not a lot of information on the little guy. To that end, new author Tim Mitchell brings us a great overview on what you should consider when setting up a SQL Server environment for a small scale setting.
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers