The Hidden Impact of Microsoft Defender for Azure SQL
A problem with the configuration of Microsoft Defender caused all activity on the server to get delayed.
Best Practices for Google Cloud Security
Security is a concern whether it be on-premises or cloud-native. Google Cloud offers many products and services including SQL Server. What are some of the security controls that should be considered when using Google Cloud services?
How to Make Database Changes Without Breaking Everything
You’ve got an existing application with a database back end. You’re thinking about changing the database, and you don’t wanna break stuff.
The Minimum Upgrade Point
Today Steve wonders to which version you would upgrade your SQL Server instances. There should be a minimum version you would try to reach.
What is OneLake in Microsoft Fabric?
Get ready to be blown away! The highly anticipated Microsoft Build in May 2023 has finally unveiled its latest and greatest creation: the incredible Microsoft Fabric - an unparalleled Data Intelligence platform that is guaranteed to revolutionize the tech world! fig 1: OneLake for all Data One of the most exciting things in Fabric I […]
GENERATE_SERIES: My new go-to to build sets
I have come across a lot of use cases for manufacturing rows on the fly, aside from the common goal of populating a large data set such as a numbers or calendar table. A few favorites include building sample data, pivoting an unknown number of columns, data extrapolation, and filling gaps in date or time ranges.
PASS Data Community Summit 2023
Keynote speakers for Summit 2023 have been announced! Who will you go see on the main stage? If you’re not already on the mailing list, sign up now and be the first to know all Summit 2023 updates.
A Overview of Amazon Redshift
This article gives an overview of Amazon Redshift, the cloud data warehouse in AWS.
Achieving More Autonomy At Work
Most of us want more autonomy at work, but it isn't given out without effort. Today Andy Warren has a few thoughts on how to get more freedom from your boss.
DAX RANKX Function Behaviors Lead to Incorrect Results and Corrections
In this tip, we explore two behaviors for the DAX RANKX function that can lead to incorrect results and discuss workarounds and fixes.
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