Investigating Azure Databricks
At SQL Saturday #884 – Pensacola, I dropped into Rodney Ladrum’s session on Azure Databricks (ADB) and the Traditional DBA. I had heard a bit about Databricks, and read...
2019-07-17
60 reads
Blog Posts
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
14 reads
New Security Update for SQL Server in July 2019 Patches
It doesn’t look like this would affect SQL Server 2008 or SQL Server 2008 R2 since the earliest reported platform is SQL Server 2014, but in Microsoft’s release of...
2019-07-17 (first published: 2019-07-09)
1,751 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
132 reads
sp_drivespace – See How Much Space You Have On Your Disks, Including Mount Points
We love xp_fixeddrives here, it’s a quick and simple way to see how much space you’ve got available on your drives. But there are just a couple of things...
2019-07-17 (first published: 2019-07-03)
836 reads
SQL Server 2019 Query Store And SSMS
While not specific to SQL Server 2019 (I was using this version to do some testing) I was struggling to find how to change the time period of analysis...
2019-07-17
45 reads
T-SQL Tuesday #116 Roundup – SQL on Linux
This month’s topic is wide open to anything you could think of that had to do with SQL on Linux from something technical on how to implement it or...
2019-07-17
6 reads
T-SQL Tuesday #116 Roundup – SQL on Linux
This month’s topic is wide open to anything you could think of that had to do with SQL on Linux from something technical on how to implement it or...
2019-07-17
15 reads
T-SQL Tuesday #116 Roundup – SQL on Linux
This month’s topic is wide open to anything you could think of that had to do with SQL on Linux from something technical on how to implement it or...
2019-07-17
40 reads
Azure Service Logging in the Modern Data Warehouse
[read this post on Mr. Fox SQL blog] The “modern data platform” architecture is becoming more and more popular as organisations shift towards identifying, collecting and centralising their data...
2019-07-16
36 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers