TechEd 2010 - A Half a Conference Recap
I left TechEd this morning, actually too early, catching a 7:12am flight from New Orleans to Denver. Which meant a...
2010-06-09
365 reads
Daily SQL Server 2008 New Feature – Day 19
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-09
439 reads
Option missing in NTILE function?
Just saw something interesting....we have a requirement to divide a result set into a certain number of groups that have...
2010-06-09
780 reads
SSMS 2008 and changing a SQL 2005 SA password.
You can probably tell from some of my more recent posts that I have been doing some work lately on...
2010-06-09
1,695 reads
TechEd Impressions: Day Two
It’s only day two of the four day conference, and I am already exhausted from attending sessions from 8:00 AM...
2010-06-09
503 reads
Filter Jobs using SQL Server Job Activity Monitor
Using SQL Server Management Studio (SSMS), we have the capability of quickly looking at job related information to verify things...
2010-06-09
1,786 reads
SQL Saturday #22 Pensacola Recap
Saturday I drove up to Pensacola for SQL Saturday #22. Me and several others from Baton Rouge, including my two...
2010-06-08
713 reads
More Details About Engine Improvements in SQL Server 2008 R2 (SQLTuesday)
This post is for SQLTuesday #007, hosted by Jorge Segarra (blog | twitter). The topic is to talk about your favorite...
2010-06-08
1,754 reads
TechEd 2010 – Interview With Herain Oberoi
Herain Oberoi is a Group Product Manager for SQL Server and spent 30 minutes with me talking about StreamInsight and...
2010-06-08
559 reads
PASS Summit 2010 Abstract Submissions
I submitted three abstracts for the 2010 PASS Summit this year - two "normal" (75 minute) and one spotlight (90 minute)...
2010-06-08
481 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