Async Network IO SQL Wait
Over the last few days we have been tracking down the cause of some really high async network IO waits. ...
2018-08-30 (first published: 2018-08-15)
3,088 reads
AlwaysOn Data Synchronization in Synchronous and Asynchronous Mode
When you are working on the AlwaysOn feature, it is crucial to understand how the AlwaysOn commit process works. This...
2018-08-15
5,757 reads
A Day in the Life (2/?) - August 14, 2018
This is my second installment in a series responding to Steve Jones’s (blog|twitter) #SQLCareer challenge. I decided to jot down most of what I did through the day, filling...
2018-08-15
16 reads
Learn PowerShell in Oklahoma, August 24!
SQL Saturday Oklahoma City is coming up RIGHT SOON, on August 25. The day before SQL Saturday OKC - August 24...
2018-08-14
715 reads
Power BI Monthly Digest – August 2018
In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through...
2018-08-14
911 reads
Power BI Custom Visuals Class (Module 115 – Circle KPI Gauge)
In this module you will learn how to use the Circle KPI Gauge. The Circle KPI Gauge displays a single...
2018-09-04 (first published: 2018-08-14)
3,217 reads
Hitting the Wall – #TSQL2sDay
Photo by Farrel Nobel on Unsplash
Welcome to another edition of T-SQL Tuesday!
This T-SQL Tuesday is hosted by Wayne Sheffield ( blog | twitter ) and he has asked...
2018-08-14
234 reads
Complicated linked servers and a bunch of head-desks: T-SQL Tuesday #104
Wayne Sheffield (b/t) is our host this month for the long running blog party (104 months now and running!) started...
2018-08-14
390 reads
Azure SQL DW – Query Labels
Using a query label in Azure SQL DW (Data Warehouse) can be a really handy technique to track queries via...
2018-08-14
371 reads
SQLpassion Online Trainings for Fall 2018
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-08-31 (first published: 2018-08-14)
1,910 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...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
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....
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