Why We’re Organizing SQL Saturday in Wheeling, WV on April 28th
Some of my friends know I am a huge fan of the song “Havana” by Camila Cabello. They also know...
2018-03-29
1,535 reads
PASS Virtualization Webinar – April 11
I am proud to present a free webinar for the PASS Virtualization virtual chapter entitled “Level Up Your Cloud Infrastructure...
2018-03-29
429 reads
Interview With Matt Gordon
I’ve been wanting to share a little bit about Matt’s story for a while now and this past week I...
2018-03-29
901 reads
Learning is Hard–March Goals Update
This is the third update for my goals for 2018. This is about 3 weeks after the last update, and...
2018-03-29
992 reads
‘Object Reference Not Set to an Instance of an Object’ When Failing Over an Availability Group Using SSMS <= 17.5
Here’s a quickie that I’ve just stumbled across.
I’ve just tried to initiate a manual failover of an availability group and...
2018-03-29
532 reads
Speaking at SQL Saturday Atlanta (#733)
I am so honored and humbled to have been selected to speak at SQL Saturday Atlanta (#733) on May 19,...
2018-03-29
405 reads
SSMS now has a vulnerability report
Security is an important and often overlooked function of technology. Don’t believe me? Go to a SQL conference and look...
2018-03-29
443 reads
SQL Script: - How to find the last access date of a database
Sometime we create databases on Test/ Development database servers for temporary uses for short duration and forgot to delete them after the work got completed. As a part of...
2018-03-29
37 reads
SQL Script: - How to find the last access date of a database
Sometime we create databases on Test/ Development database servers for temporary uses for short duration and forgot to delete them...
2018-03-29
1,961 reads
Toolbox - Just the Basics
There are many query sets out there to collect varying groups of configuration data - the ones I most frequently use...
2018-03-29
725 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