Azure Databricks and Azure Key Vault
The key vault should always be a core component of your Azure design because we can store keys, secrets, certicates thus abstract / hide the true connection string within...
2020-10-28
45 reads
Blog Posts
Daily Coping 28 Oct 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-10-28
19 reads
Top Azure Synapse Analytics and Power BI questions
I have listed below the top questions I see from customers about Azure Synapse Analytics and Power BI, and the blogs that I have written that try to answer...
2020-10-28 (first published: 2020-10-22)
731 reads
Azure SQL Database Elasticity – Presentation Notes
This blog covers the content and points to the code used to create the demos in my Azure SQL Database Elasticity presentations. As of today, I have presented this...
2020-10-27 (first published: 2020-10-20)
342 reads
Blog Refresh – Growing Readers
Happy Tuesday everyone… In early 2017 I started blogging on this site in hopes of sharing new technology I was learning. The first post was as you could guess,...
2020-10-27
30 reads
Daily Coping 27 Oct 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-10-27
10 reads
How To Set Up Perfmon for 24×7 Collection
I just released a new training video (one of many to be released in the upcoming months) showing you how to set up Windows Perfmon for ongoing 24×7 collection....
2020-10-27 (first published: 2020-10-21)
421 reads
Azure DevOps–Reconfiguring an Agent
This post looks at how to re-configure a local Azure DevOps agent when you need to change to a new pool or organization. PAT Expired I got a note...
2020-10-26 (first published: 2020-10-19)
535 reads
Daily Coping 26 Oct 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-10-26
14 reads
How To: Create Schema Only Database Copies
Have you ever been asked to make a schema only copy of a database? What is your preferred method to complete this request? Below we will discuss how to...
2020-10-26 (first published: 2020-10-20)
1,428 reads
Blogs
Advice I Like: Failure
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Data Conferences – Worth Every Dollar
By Kevin3NF
Some of the best career enhancers you can buy. Why I Go to...
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
Forums
SQL 2022 stuck on xp_delete_file
SQL 2022 hangs on xp_delete_file, it works for a while when sever is rebooted...
Getting the Object Code
Comments posted to this topic are about the item Getting the Object Code
Question of the Day
Getting the Object Code
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers