The unwanted Side Effects of enabling Read Committed Snapshot Isolation
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-08-30
2,453 reads
Helpful Undocumented Stored Procedure “sp_MsForEachDB”
This week’s post will be a short one to talk about a very helpful stored procedure in SQL Server called...
2018-08-30
283 reads
How Azure Storage Kick Starts Your Big Data Projects
So, your boss says, ‘Let’s do big data!’ And you think: ‘I don’t even know what that means or what...
2018-08-29
987 reads
Employee Agreements & Contracts: Best Practices (23 minute video)
So you’ve got an employee agreement in front of you: now what? In this episode, I talk about practical steps you should take to make sure that you understand...
2018-08-29
33 reads
Next week is SQL in the City Streamed
This picture is out of date. I’ll make sure we get a new one next week at SQL in the...
2018-08-29
370 reads
Azure SQL Database disaster recovery
My last blog post was on Azure SQL Database high availability and I would like to continue along that discussion with a blog post about disaster recovery in Azure SQL...
2018-08-29
43 reads
Azure SQL Database disaster recovery
My last blog post was on Azure SQL Database high availability and I would like to continue along that discussion with...
2018-08-29
1,123 reads
A software architect replaces a relational database with a relational database
Content warning: This is the second (and final) rebuttal essay about why someone is wrong on the Internet. It is...
2018-08-29
326 reads
SQL Puzzle: Advent of Code
A few years back someone started the Advent of code. If you aren’t familiar with it, it’s an advent calendar...
2018-08-29
531 reads
Undercover TV- Episode 2
The latest webcast from SQLUndercover.com. In this episode David and Adrian take a look at a few blog posts that have caught...
2018-08-29
395 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