Don’t Be a Shock Jock
One of the dangers of being an “Internet Journalist” or even just a blogger, is that you might compromise who...
2010-03-12
1,015 reads
Orlando Code Camp – March 27, 2010
I’ll be attending and speaking at the Orlando Code Camp on March 27, 2010 at Seminole State College along with...
2010-03-12
557 reads
SharePoint 2010 and Various Versions of SQL Server
Microsoft has recently announced that SharePoint 2010 and Office 2010 will RTM in April 2010, and will be officially launched...
2010-03-11
5,849 reads
PASS Update #25 (Summit Location and More)
By now you’ve probably seen the official announcement from PASS about the Summit being located in Seattle for both 2011...
2010-03-11
683 reads
PASS European Conference in April
While it is probably out of reach for most DBAs in the United States to attend, the PASS European Conference...
2010-03-11
412 reads
Location of the PASS Summit Follow-up
I got a little distracted after lunch and was reading through some of the various bloggers reactions to the decision...
2010-03-11
625 reads
Setup Database Snapshot against a Mirrored Database (Part 2)
This post is the second post in my series about Database mirroring. For part one is titled Configuring Database Mirroring...
2010-03-11
760 reads
The Root of all Evil
Or “Shot gun query tuning”
There have been a fair few forums questions in recent months asking for help in removing...
2010-03-11
474 reads
SCSUG (Space Coast SQL Users Group) Meeting Tonight Featuring PFE David Pless
In case you missed David Pless in Orlando on Tuesday, you have another chance to see his presentation tonight (Thursday...
2010-03-11
531 reads
Displaying a Check Mark for a Row When a Related Record Exists
Let's say that you have a column
named some_id in an outer-joined table that will return a value if a record...
2010-03-11
435 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