Announcing EightKB 2021
The first EightKB back in July was a real blast. Five expert speakers delivered mind-melting content to over 1,000 attendees!
We were honestly blown away by how successful the first...
2020-11-19
Blog Posts
Daily Coping 19 Nov 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-11-19
15 reads
Microsoft Power BI Quick Start Guide – Second Edition
Earlier this week I announced the release of a new Power Platform book. While I’m super excited about that book I’m also excited to announce
2020-11-19 (first published: 2020-11-06)
682 reads
[Video] Azure SQL Database – Failing Over (Failover Groups)
Quick video showing you how to failover your Azure SQL Database between your primary and secondary location.
2020-11-18
78 reads
Daily Coping 18 Nov 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-11-18
12 reads
Monitoring and Tracking SQL Server Blocking & Deadlocks process
Introduction SQL Server deadlock one of the issues that can be happened in any SQL Server, today in this article I will not explain what is Deadlock and How...
2020-11-18 (first published: 2020-11-08)
530 reads
PowerShell Arrays and Hash Tables–#SQLNewblogger
I was watching the GroupBy talk the other day and noticed that Cláudio Silva was using arrays, or what appeared to be arrays, in his talk. That was an...
2020-11-18 (first published: 2020-11-09)
371 reads
Setting yourself up for online streaming success, PASS Virtual Summit style
Last week I presented on three separate occasions during what is considered the biggest Microsoft Data Platform conference of the year, the PASS Summit: Full-day pre-conference session Speaker Idol...
2020-11-18
66 reads
Thoughts on the 2020 PASS Virtual Summit as an Attendee
Last week was the first PASS Virtual Summit. This was the first time that the event wasn’t held in a live setting, and this was the third conference for...
2020-11-18
96 reads
[Solved] SQL Backup Detected Corruption in the Database Log
Summary: In this article, we will discuss about the ‘SQL Backup Detected Corruption in the Database Log’ error. It will also describe the reason behind the error and manual...
2020-11-17 (first published: 2020-11-06)
2,304 reads
Blogs
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Forums
Getting the Object Code
Comments posted to this topic are about the item Getting the Object Code
T-SQL in SQL Server 2025: Concatenating Strings
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Being Mindful of Design Time
Comments posted to this topic are about the item Being Mindful of Design Time
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