Better Keyboard Extensions in Azure Data Studio
I used to use ALT+X to execute queries in SSMS. I spent years with this shortcut, but as I started...
2018-11-05 (first published: 2018-10-23)
2,246 reads
Slides and Scripts from IT/Dev Connections
If you attended either of my presentations for this past IT/Dev Connections, here are the promised slides and scripts.
As I...
2018-10-23
254 reads
PASS Summit 2019 or Microsoft Ignite 2019?
It turns out that the 2019 Summit and Ignite will be held the same week in 2019, see this post...
2018-11-02 (first published: 2018-10-23)
2,363 reads
SQL Saturday Lincoln Precon this Friday Oct 26
I’m presenting an exciting preconference training session on Friday, October 26, ahead of the SQL Saturday in Lincoln, Nebraska. This...
2018-10-23
202 reads
Unexpected Shorthand Date Implicit Conversions
I do my best work in the mornings. Evenings are pretty good too once I get a second wind.
Late afternoon...
2018-10-30 (first published: 2018-10-23)
2,834 reads
Unexpected Shorthand Date Implicit Conversions
I do my best work in the mornings. Evenings are pretty good too once I get a second wind.
Late afternoon are my nemesis for getting any serious technical or...
2018-10-23
17 reads
Unexpected Shorthand Date Implicit Conversions
I do my best work in the mornings. Evenings are pretty good too once I get a second wind.
Late afternoon are my nemesis for getting any serious technical or...
2018-10-23
21 reads
DAX – Cumulative Total and Blank Handling
When developing DAX measure, you should be aware that Blank value behavior might be similarly insidious as NULL value in...
2018-10-23
435 reads
ASF 015: Kalen Delaney interview
Introduction Kalen Delaney has been working with SQL Server since 1987 when she joined the Sybase Corporation in Berkeley, California....
2018-10-22
114 reads
This is a company that practises what they preach
How good is a company at engaging with their user base? Obviously when things are going great then it’s wins...
2018-10-22
971 reads
Blogs
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...
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
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