SQL Saturday #80 - Wheeling. WV
Come get a free day of SQL Server training in Wheeling on Jul 23, 2011.
2011-07-18 (first published: 2011-06-22)
2,518 reads
Articles
Yet Another SQL Strategy for Versioned Data
There is a popular design for a database that requires a built-in audit-trail of amendments and additions, where data is never deleted, but superseded by a later version. Whilst this is conceptually simple, it has always made reporting the latest version of data complicated. Alex Kuznetsov joins the debate on the best way of doing this with an example using an indexed view and the filtered index.
2011-07-15
3,274 reads
2011-07-14 (first published: 2009-06-10)
7,100 reads
Second Normal Form
In this article Tom Thomson takes a look at what second normal form means, how it is violated, and how you can fix it. This is part of our normalization series.
2011-07-14
8,088 reads
Identifying PII Data to Lock Down in SQL Server - Part 1
We're pretty confident that we have locked down and encrypted our financial data, but a lot of our customer's PII (Personally Identifiable Information) data is still held in unencrypted form. This data is able to be selected directly by read only business users on many of our downstream reporting, datawarehouse and standby servers. The rise of identity theft makes protecting this data imperative. DBAs are the custodians of this information and must protect it like we protect our own personal information. Recent publicity over the theft of Sony PSN data underscores both the economic and ethical importance of protecting personal data.
2011-07-14
2,864 reads
Questions About SQL Server Distribution Statistics
Fabiano Amorim was asked a couple of questions about SQL Server Distribution Statistics. Having given an answer based on his current knowledge, he then decided to find out for himself whether what he'd said was right, and started an epic journey of exploration into Distribution Statistics and the way that the Query Optimiser uses them.
2011-07-13
2,132 reads
2011-07-12 (first published: 2009-06-03)
8,713 reads
Questions About SQL Server Distribution Statistics
Fabiano Amorim was asked a couple of questions about SQL Server Distribution Statistics. Having given an answer based on his current knowledge, he then decided to find out for himself whether what he'd said was right, and started an epic journey of exploration into Distribution Statistics and the way that the Query Optimiser uses them.
2011-07-12
2,173 reads
Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1
Learn how to create a Windows 2008\SQL Server 2008 virtual cluster in this three part series.
2011-07-11
14,187 reads
TSQL Challenge 60 - Generate a relational tree structure from a string
Your job is to read a string containing product hierarchy information and generate a relational table (result set) representing the hierarchy of categories.
2011-07-11
986 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers