Archiving
It seems that archival isn't on the mind of most designers when they first build a database, which is OK, but DBAs ought to be building skills to implement this if the data size grows large.
Patch Week
This week Steve Jones notes there were quite a few patches from Microsoft for a variety of products. No SQL Server specific security patches, but that doesn't mean that DBAs shouldn't be patching systems.
Slowly changing dimensions using T-SQL MERGE
Of all the technical solutions to the problem of slowly changing dimensions, the T-SQL MERGE statement is one of the most elegant.
A Tale of Identifiers
Identifiers aren't locators, and they aren't pointers or links either. They are a logical concept in a relational database, and, unlike the more traditional methods of accessing data, don't derive from the way that data gets stored. Identifiers uniquely identify members of the set, and it should be possible to validate and verify them. Celko somehow involves watches and taxi cabs to illustrate the point.
SQL Saturday #82 - Indianapolis
Come to Indianapolis on June 25, 2011 for a free one day training event on SQL Server.
Multiple Failures
This Friday Steve Jones has a disaster recovery poll. When you have a true disaster, often there are multiple things that go wrong and cause a cascading failure. Is this common, let us know what your experience is this Friday.
SQL Server 2008 and 2008 R2 Integration Services - Consuming Web Services Using Script Task
Web services can be easily leveraged in SQL Server 2008 R2 Integration Services by employing Web Services Task.
Lessons Learned from a Large Virtualization Implementation
Microsoft recently asked me to provide a summary of my experience with being part of a large-scale virtualization project. This was my response.
Phrases that Resonate
Today we have a guest editorial from Andy Warren. Are there particular phrases that you use in technology that resonate with you and have particular meanings? Andy shares a few of his favorites.
Raw Materials - Cloud Computing, the Next Generation
The pros and cons of having computing power close at hand.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers