PASS Speaking Results
I got the PASS speaking results today on the new speaker portal. They posted the top sessions as well, overall...
2011-12-09
1,116 reads
A PASS Board Of Directors Endorsement
One of the requirements for the PASS Board of Directors application was a collection of recommendations - 3 from volunteers, 3...
2011-12-09
905 reads
PASS Board Of Directors Voting Open Through Dec. 20
Voting for the 2011 PASS Board of Directors elections started earlier this week and if you were a PASS member...
2011-12-09
688 reads
SQL Server MVP Deep Dives Volume 2 – My Review
Volume 1 was packed full of knowledge and a very welcome edition to my bookshelf! With the bar already set...
2011-12-09
851 reads
SQL Database Status with sys.databases
I was creating a Powershell script for a SQL Server checkout procedure after a reboot , and used the state_desc column...
2011-12-09
862 reads
Reduce heap table fragmentation
A table that does not have a clustered index is referred to as a Heap. While a lot has been...
2011-12-09
7,215 reads
Re-blog – December 2 – December 8
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2011-12-09
565 reads
My Recipe for Chocolate Pie
One of our small holiday traditions is that we bake at least one home made dessert. Hard to beat the...
2011-12-09
667 reads
#sqlfamily
Microsoft is supporting an effort by PragmaticWorks targeted at supporting technical training for returning veterans. I can’t think of a...
2011-12-09
1,707 reads
SQL Server is Smarter Than You
I had a brief email discussion recently, which could be effectively be boiled down to:
Them: “Are foreign key constraints more...
2011-12-08
856 reads
Blogs
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
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,...
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