Adding a column to the primary key.
Every now and again you realize that the primary key for a table does not uniquely describe a row. Not...
2014-11-13
1,118 reads
Script to Monitor SQL Server Database Mirroring Status
SQL Server Database Mirroring is fantastic HA solution developed by Microsoft. Microsoft lunch database mirroring with SQL Server 2005. Database...
2014-11-13
1,531 reads
MDX #44–How to find all the calculated measures
Calculated measures are visually identifiable
If you have access to a cube, it’s quite easy to find all the calculated measures.
The...
2014-11-13
1,487 reads
Outlier Detection with SQL Server, part 2.2: Modified Z-Scores
By Steve Bolton
…………There are apparently many subtle variations on Z-Scores, a ubiquitous measure that is practically a cornerstone in the...
2014-11-13
2,595 reads
Updated blog Site
This post is mainly to test the syndication still works correctly from my heavily updated web/blog site so apologies for...
2014-11-12
159 reads
Updated blog Site
This post is mainly to test the syndication still works correctly from my heavily updated web/blog site so apologies for...
2014-11-12
429 reads
Creating cards in Trello via the REST API and parsing the returned JSON all in a SQL CLR
I recently blogged about how good I thought Trello was and shortly afterwards I found out that they did provide...
2014-11-12
325 reads
Busy times
It has been a pretty long time since my last blog post but with good reason!
The last month and a...
2014-11-12
454 reads
Power Testing ETL with Power BI – Shaping The Data with Power Query and Power Pivot
This blog post digs into the details of shaping the data with Power Query and Power Pivot in order to...
2014-11-19 (first published: 2014-11-12)
8,126 reads
T-SQL Tricks – Templates in SSMS
There are lots of little tricks that you can use to become more proficient, and efficient, at writing T-SQL. Here’s...
2014-11-12
1,059 reads
Blogs
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
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