Troubleshooting Database mail
Last week we blogged about “How to configure Database mail” – this week we’ll have a closer look at what to...
2012-05-08
9,842 reads
When SQLCommunity disappoints....
Everyone who is involved in, and follows me in the SQL Server Community, and my blog, knows, that I am one...
2012-05-11 (first published: 2012-05-08)
3,179 reads
How To Use T-SQL TIMESTAMP (ROWVERSION) in SSIS
In some database designs, you may encounter SQL Server columns with a TIMESTAMP or ROWVERSION data type. What are these,...
2012-05-14 (first published: 2012-05-08)
8,018 reads
May 2012 – Monthly SQL Server Checklist
They say, “April showers bring May flowers.” But what if it doesn’t bring May flowers? What if instead you get...
2012-05-08
845 reads
Finding the Default Trace File
A post more for me than for anyone else, since I’ll look for something in the default trace and I...
2012-05-07
15,829 reads
SSAS: Duplicate Attribute Key Error
One type of error that arises occasionally during SSAS cube processing is the ‘duplicate attribute key’ error. The error message...
2012-05-07
1,357 reads
The Fantastic 12 of SQL Server 2012
The SQL Server Team Blog is in the midst of posting twelve, short weekly videos that let someone from the...
2012-05-07
1,051 reads
Updated SQL Rockstar Blogger Rankings
This morning, Thomas LaRock (blog|@SQLRockstar) released an updated version of his Blogger Rankings. I was very happy and humbled to...
2012-05-07
1,658 reads
Service Broker Sample: Multi-Threading
Introduction
Service Broker is a cool new feature since SQL Server 2005. Yes, SQL 2012 just came out so it’s hardly...
2012-05-07
520 reads
Which SELECT * Is Better?
The short answer is, of course, none of them, but testing is the only way to be sure.
I was asked,...
2012-05-11 (first published: 2012-05-07)
5,423 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