SQL Rally Deck's and Demo's Up
Hello Dear Reader! I'm coming to you live from the wonderful SQL Rally in Dallas Texas. I have two sessions...
2012-05-10
508 reads
Blog Posts
SQL Server – Purging Database Mail History
SQL Server stores all mails and attachments in msdb database. To avoid unnecessary growth of msdb database you should remove...
2012-05-10
1,261 reads
SQLRally 2012–Wednesday
Had a nice lunch at On The Border at Orlando International before my flight, used that time to finish some...
2012-05-10
633 reads
SQLSaturday #129 - City of Rochester, NY
Long before it was announced that coming August 4, 2012, SQLSaturday #158 returns to the NYC (<< see recent announcement, New York...
2012-05-10
1,267 reads
The Difference Between Change Tracking and Change Data Capture
Change Tracking (CT) and Change Data Capture (CDC) were both added to SQL Server in 2008. At first it seems...
2012-05-10
49,352 reads
Working with bitwise data in SQL Server
I was working with a group of students on a design brief. The brief was to partially implement a database...
2012-05-10
1,062 reads
Backup database in CMS
Sometime you know the database name which you want to backup, but you don't know which server it is on....
2012-05-09
1,135 reads
Denali — Day 9: Additional Scalability Features
Denali – Day 9: Additional Scalability Features
15,000 Partitions earlier it was 1000For the enterprise system having huge amount of data to...
2012-05-09
507 reads
DQS Domain Validation Rules
A compelling feature of the new Data Quality Services in SQL Server 2012 is the ability to apply rules to...
2012-05-09 (first published: 2012-05-04)
3,644 reads
Thank You to the People That Get Us There
http://www.flickr.com/photos/saygoodie/4548042971/
Hello Dear Reader starting today out in Dallas Texas at the Dallas Convention Center is the Second Annual SQL Rally. ...
2012-05-09
682 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