This 3-part sponsored article surveys several different methodologies for database development, examines their strengths and weaknesses, and illustrates how Red Gate's comparison tool, SQL Compare, can be incorporated into each model.
Longtime SQL Server guru David Poole brings us a look at one of the thorny problems a DBA faces: tracking down illicit users.
Application locks aren't a well known area of locking in SQL Server, but they can be very useful for special scenarios. They work in an analogous way to the lock() construct in .Net and are basicaly user defined mutexes in SQL Server.
The amount of data in the world grows every day and there's no end in sight. How big a problem is storage management? Steve Jones shares a few thoughts on how you might manage your storage.
The amount of data in the world grows every day and there's no end in sight. How big a problem is storage management? Steve Jones shares a few thoughts on how you might manage your storage.
The amount of data in the world grows every day and there's no end in sight. How big a problem is storage management? Steve Jones shares a few thoughts on how you might manage your storage.
An offer from Red Gate for free downloadable posters. You can print them out and decorate your cube, showing some great disaster recovery tips from MVP Brad McGehee.
It would be wonderful to be able to simple purchase a tool or technology and have your data challenges disappear. It is time to step back and take a much needed different look at data.
SQL Server 2000 replication is usually simple and easy to setup and work with. However there are many restrictions to ensure this, one of which is the alteration of a column which is engaged in replication. Author Paul Ibison brings us two options for altering columns.
Digital technologies have made the transfer of information easier than ever, but what about it's long term storage? That doesn't seem to be as easy as we might think.
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
As a data & AI strategist who’s seen countless projects succeed and fail, I...
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
We are planning on a fairly big code deployment to set the stage for...
Experts, I am hoping to get some help and feedback. I have a server...
Comments posted to this topic are about the item Single User SQL Server on...
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers