New Cumulative Updates For SQL Server 2008 R2
On Feb 22, 2012, Microsoft released SQL Server 2008 R2 SP1 Cumulative Update 5, which is Build 10.50.2806. This CU...
2012-02-24
948 reads
SQL Server 2012 (“Denali”): Spatial Features
SQL Server 2012 introduces several significant enhancements to spatial types, such as support for new subtypes of circular arcs, new...
2012-02-24
2,031 reads
Re-blog – February 17 – February 23
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-02-24
584 reads
Speaking at the SQL Lunch UK
Yep, that’s correct, the SQL Lunch has expanded to the UK with one slight change. Unlike the SQL Lunch that I...
2012-02-24
814 reads
Speaking at the SQL Lunch UK
Yep, that’s correct, the SQL Lunch has expanded to the UK with one slight change. Unlike the SQL Lunch that...
2012-02-24
459 reads
No MVP Summit for Me
On the corner of my rather messy desk is little recognition item in the image to the right. It’s a...
2012-02-24
860 reads
SQL Server - DBA Team FAQ
Developers constantly ask about placing the latest code\feature\process\third party applications onto Production Database Servers.
I’m building an FAQ to supply Developers...
2012-02-24
1,133 reads
A Plea: Have your guidance documentation reviewed
Today one of my auditors sent me her matrix for auditing Microsoft SQL Server. I had seen part of it...
2012-02-23
1,237 reads
A Script A Day - Day 18 - Viewing System Configuration
Today’s script is something I’ve learned today, it’s cool learning new stuff! When viewing server configurations in the past I’ve...
2012-02-23
575 reads
A Script A Day - Day 17 - Possible Poor Indexes
Today’s script is one I’ve taken from a job I use to collect possible poor indexes. I’ve tweeked it slightly...
2012-02-23
555 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers