Object Grouping Best Practices: Using Schemas for Logical Separation
You've probably all noticed a change since SQL Server 2000 with respect to objects: formerly DB.ObjectOwner.Object ,
Service Pack 2 Uninstall Not Possible for SQL Server 2005
You probably already know that SQL Server 2005 SP2 has been released. This is a good thing if you are in need of one of the changes that are included in this service pack. In a previous tip, SQL Server 2005 - Service Pack 2, we took a look at what was to be included in this second service pack for SQL Server 2005. The question that you often face is should I install this service pack. One thing to note before you install SP2 is that there is no way to uninstall it once it is installed.
Top five tips for SQL Server developers
Check out these handy database development best practices, with tips on dealing with batch updates, stored procedures and more.
Basically Available, Soft State, Eventually Consistent
The use of non-relational databases is a fascinating topic but they will remain special-purpose and are not competing with SQL-based relational databases.
No Google
Recently Google was unavailable for a good part of one day. Steve Jones felt the impact and thinks this could slow the adoption of cloud computing.
Database Mirroring in SQL Server 2008
Learn the basics of the Database mirroring in SQL Server 2008. Mak provides a step-by-step on how to create database mirroring. Subsequent installments will discuss how to add data on the principal server and how data is mirrored to the mirrored server.
No Google
Recently Google was unavailable for a good part of one day. Steve Jones felt the impact and thinks this could slow the adoption of cloud computing.
No Google
Recently Google was unavailable for a good part of one day. Steve Jones felt the impact and thinks this could slow the adoption of cloud computing.
No Google
Recently Google was unavailable for a good part of one day. Steve Jones felt the impact and thinks this could slow the adoption of cloud computing.
Shrinking the Log
It seems that I see more and more posts about people trying to shrink their transaction logs. It's getting to be close to the time when I need a cut-and-paste snippet stored in a file I can pull out for my standard "it is recommended that you...
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers