SQL Server Indexed Views Explained
Indexed views are a really powerful and possibly underused feature of SQL Server. It’s basically a way of writing a...
2012-05-02
66 reads
Eight Words
I remember a lot of things about that day. It was July in Texas, which is to say, it was...
2012-05-03 (first published: 2012-05-02)
2,567 reads
Checking Your Main BIOS Version
As some of you may know, I spent four years in the U.S. Marine Corps back during the Reagan administration....
2012-05-01
1,802 reads
Notes from SQLSaturday #107 in Houston
I’ve deliberately waited a bit to write this after the event, just to see what stood out after a week...
2012-05-01
473 reads
Favorite DBA Books
In the April 2012 Question of the Month, I asked readers to tell me their favorite DBA books. I have...
2012-05-08 (first published: 2012-05-01)
5,394 reads
The 2012 Powershell Scripting Game(shows) in review
Over the past few weeks, those around me know that I’ve been talking a lot about Powershell, how much it...
2012-05-01
1,207 reads
May Question: How soon will you begin implementing SQL Server 2012?
Now that SQL Server 2012 has been released, this month’s question is “How soon will you begin implementing SQL Server...
2012-05-01
1,059 reads
When Will You Upgrade to SQL Server 2012?
This is a reprint from my editorial in Database Weekly. Also, check out the May Question of the Month, as...
2012-05-01
1,270 reads
Speaker Issues: The Quandry of Double Submitting
This is in response to yesterday’s Twitter conversation, and subsequent blog by Eddie Wuerch, about submitting to more than one...
2012-05-01
795 reads
Denali — Day 1: Tempdb Compatibility – Bug?
Denali — Day 1: Tempdb Compatibility – Bug?
I have installed sql server 2012 express and evolution edition on my personal laptop, and...
2012-05-01
475 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
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...
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