SQL Server clustered index design for performance
Find why SQL Server clustered index design should be narrow and static and how clustered indexes affect many-to-many tables to improve database performance.
2008-01-16
3,939 reads
Articles
Adding Custom Code To Reporting Services
Reporting Services has been greatly enhanced in SQL Server 2005 and become an integral tool in many SQL Server installations. Longtime autor Raj Vasant brings us an example of how you can enhance your reports with custom coded DLLs called from within the reporting engine.
2008-01-15 (first published: 2007-03-15)
21,725 reads
SQL Server Database Development Methodologies using SQL Compare
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.
2008-01-15 (first published: 2007-12-19)
3,992 reads
Tracking Illicit Users
Longtime SQL Server guru David Poole brings us a look at one of the thorny problems a DBA faces: tracking down illicit users.
2008-01-15
7,897 reads
Application Locks (or Mutexes) in SQL Server 2005
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.
2008-01-15
4,038 reads
Billee-yons and Billee-yons of Gigabytes - iPod
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.
2008-01-15
48 reads
Billee-yons and Billee-yons of Gigabytes - MP3
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.
2008-01-15
62 reads
Billee-yons and Billee-yons of Gigabytes - WMV
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.
2008-01-15
53 reads
Expert DBA tips in 3 posters
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.
2008-01-15
4,688 reads
It's All About the Data
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.
2008-01-15
1,750 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers