Here are some oldies, but goodies that I recommend you read:Two Partitioning Peculiarities and Aggregates and PartitioningMost of us know that partitions are one of the best ways to scale very large databases or very large IO workloads. However, there are risks, two of which are explored in detail by internals master Paul White ...

I always enjoy presenting at the DevLink conference, presented each summer in middle Tennessee. This year, I'm trying to be a better social media person and actually post my slides (in their most recent forms) on my SlideShare account for everyone to see and share. If you attended my session(s) and enjoyed them, feel free to ...

It's an old story you've probably heard before. Provide a free version of your software product with strict limitations on performance or other specific capabilities so that folks can give it a try without risk, while you minimize the chance of cannibalizing sales of your commercial products. Microsoft has take this strategy ...

I'm doing two new webcasts next week on Wednesday, December 19th, one in the morning and the other after lunch.
SSDs are a Game Changer for SQL Server Storage
No, session is not exclusively about SSDs. But this is my first session on IO and storage tuning that emphasizes SSDs over hard disks. As Bob Dylan said ''Times, they ...

I’d like your opinion here.
Follow my logic here for a moment as I walk through a couple
rhetorical questions. Have you ever had a friend developed an
application entirely on SQL Server Developer Edition? (Not that YOU
would ever do such a thing, but maybe you know someone who has. Right?)
And has your friend’s IT department ...

Join Us for 24 Hours of SQL Server Training
(with a special focus on SQL Server 2008 R2)Did I mention that your Cohorts in Crime
(that be me
and Brent
Ozar) are presenting?!?
The FREE 24 Hours of PASS event is bringing an exceptional
lineup of SQL Server and BI experts to your computer starting at
12:00 GMT (UTC) on May ...