Corporate Hackers
A report says that most of the data lost in corporations is from employees. What can be done about it? Steve Jones thinks we still have work to do in this area.
2009-07-14
719 reads
Articles
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 ,
2009-07-14
2,920 reads
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.
2009-07-14
2,824 reads
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.
2009-07-14
7,765 reads
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.
2009-07-13
878 reads
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.
2009-07-13
3,451 reads
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.
2009-07-13
660 reads
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.
2009-07-13
693 reads
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.
2009-07-13
669 reads
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...
2009-07-13
3,369 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers