One Way to Find Broken Code on Your Server
Before we approached our last major SQL Server upgrade, I was curious about what might break. Yes, I had used the DEA to check our code against deprecated or...
2019-07-19
64 reads
Azure SQL Database SLA Updates
I am sure many missed the updates to Azure SQL Database SLA (Service Level Agreement). It used to be 99.99% across all tiers but split between two different high-availability...
2019-07-19
220 reads
ASF 024 video invitation
I’m happy to announce that the next episode of “Ask SQL Family” podcast is coming. This time our guest is an amazing woman, not only in AI and Power...
2019-07-19
15 reads
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 2
This post is part two in a three-part series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. It builds on...
2019-07-19
124 reads
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 2
This post is part two in a three-part series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. It builds on...
2019-07-19
21 reads
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 2
This post is part two in a three-part series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. It builds on...
2019-07-19
172 reads
Life Support 2008 – Audit Logons
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Related...
2019-07-17
20 reads
Life Support 2008 – Audit Logons
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
Related...
2019-08-09 (first published: 2019-07-17)
315 reads
All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT
This is the first in a series of posts about gatekeeping in Information Technology and other fields. I am not the first — nor will I be the last...
2019-07-17
64 reads
None of the IP addresses configured for the availability group listener can be hosted by the server Either configure a public cluster network 19456
Requirement: Remove a node from one of...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-07-17
144 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