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
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Breaking Rules in Rome
By Steve Jones
Last week I was honored with a trip to Rome for the Redgate President’s...
Forums
BCA KCU GAJAH MADA No.Telpon 087781685647
Whatsapp 087781685647 Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman Sari, Kota Jakarta...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers