4 Ways To Define Lookup Values In A Query
Watch this week's video on YouTube
Occasionally you may need to create a lookup table of values for a single query. Building a permanent table of these values is a...
2018-06-05
15 reads
SQL Database Corruption: Causes, Prevention, Fixing Techniques
“I had a Database File and I want to attach this MDF file to SQL Server 2014. However, whenever I...
2018-06-05
272 reads
SQLSaturday Orlando 2018 – Planning Update #2
Continuing the notes I wrote in Update #1, got a few more things done last week:
Received confirmation that the event...
2018-06-05
274 reads
Did you know...you can change the default file encoding for new query on SSMS?
If you have been reading my last blog posts, you know that I’m currently working on a SQL code migration from Firebird to SQL Server.
The client provided the scripts...
2018-06-05
201 reads
SQL Saturday #731 Athens 2018
In less than two weeks (on 16th June) it’s time for SQL Saturday Athens and I’m proud to announce that...
2018-06-04
309 reads
A Broken Linux VM
I have no idea if this is the best thing, but I went to boot up a Linux VM today...
2018-06-04
323 reads
Power BI Custom Visuals Class (Module 106 – Ring Chart MAQ Software)
In this module you will learn how to use the Ring Chart by MAQ Software. The Ring Chart is similar...
2018-06-12 (first published: 2018-06-04)
2,275 reads
Extended Events, the system_health Session, and Waits
I advocate for, use, document, teach, and just downright love, Extended Events. They are so much better than the old...
2018-06-04
375 reads
Microsoft Azure – Introduction to Cosmos DB – Part 1
Hello Friends, Please find the link of new post of about Introduction to Cosmos DB and how to create the...
2018-06-04
334 reads
SQL Homework – June 2018 – Alter a database
Here we are again. The beginning of another month. At the beginning of each month I put out a SQL...
2018-06-04
245 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...
Alamat BCA KCP City Center Hub/Wa. 0817-819-444
WhatsApp:0817819444 Kawasan Terpadu The City Center, Gedung Perkantoran Tower One, Ground Floor, Jl. K.H....
Alamat BCA KCP Majalaya Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Raya Laswi No.212 A, Majalaya, Kec. Majalaya, Kabupaten Bandung, Jawa Barat 40382
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