SQL Server 2005 Diagnostic Information Queries (May 2012)
Even though SQL Server 2005 fell out of Mainstream Support back in April of 2011, I know many people are...
2012-05-08 (first published: 2012-05-04)
2,372 reads
SQL Saturday Houston Recap
Last month I made the trip with some other Dallas-area speakers down to Houston’s second annual SQL Saturday event. This...
2012-05-04
596 reads
Win a Free SQLRally Admission!
As those of you in our local North Texas SQL Server User Group are aware, we have given away one...
2012-05-03
828 reads
Patience
Update: This is confirmed by Snopes.
A NYC Taxi driver wrote:
I arrived at the address and honked the horn. After waiting...
2012-05-03
2,922 reads
Content is King: Great (paraphrased) advice from TheOatmeal.com
TheOatmeal.com has provided the absolute best counsel regarding creativity vs marketing. The comic I’m talking about is entitled “How to get...
2012-05-03
849 reads
Changing Priorities
If you’ve been following this blog for a while, you have probably noticed that the content here has been a...
2012-05-03
717 reads
On the road less traveled: a DBA Roadmap review
The story of why I came up with this blog is no secret to the few readers I have here. In...
2012-05-03
1,384 reads
Slowing Changing Dimension (SCD) demystified – Part 1
SCD is a basically a concept that explains how historical data/values are stored within a data in a database.
There are...
2012-05-03
712 reads
Denali – Day 3: Hardware & Software requirements and Installation, Upgrade / Migration
Denali – Day 3: Hardware & Software requirements and Installation, Upgrade / Migration
I know this should be first or second blog post when...
2012-05-03
893 reads
OFFSET and FETCH Query Options in SQL Server 2012
If you are tired of implementing query paging solution in old classic style than try query hints OFFSET & FETCH newly introduced in SQL Server 2012. You might have...
2012-05-03
126 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