SQL Server Agent Jobs are one of the core features of SQL Server. Agent Jobs perform many actions, from maintenance tasks (server and database), data movement flows, replication, log...
2020-09-09 (first published: 2020-09-01)
635 reads
This week we’re looking at how the database engine stores the XML data type in SQL Server and Azure SQL Database. If you would like to read about storage of...
2020-09-09
152 reads
Hi internet!
Thanks to the surprising number of you who joined our first ever virtual meeting of the Baton Rouge .NET and SQL Server User Groups tonight!
I presented on the...
2020-09-09
12 reads
I’m thrilled to have been part of the second EightKB Mixed Extents podcast recording where Joey D’Antoni, Melody Zacharias, Andrew Pruski, Mark Wilkinson, Anthony Nocentino, and I talked about...
2020-09-09 (first published: 2020-08-28)
198 reads
Occasionally, we must resize or realign our Tempdb log file (.ldf) or data files (.mdf or .ndf) due to a growth event that forces the file size out of...
2020-09-09
90 reads
I’m delighted to announce I’m speaking at the virtual SQLSaturday Denmark at the 26th of September 2020. I’ll be speaking about the cloud datawarehouse Snowflake and its integration with...
2020-09-09
15 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-09-09
73 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-09-09
2 reads
In the first PART we talked about the built-in tools in SQL Server management studio and some other custom packages scripts can help us in troubleshooting performance issues, but...
2020-09-09
33 reads
In the first PART we talked about the built-in tools in SQL Server management studio and some other custom packages scripts can help us in troubleshooting performance issues, but...
2020-09-09
6 reads
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Quite a long title for a short blog post ??While deploying a DACPAC (from...
By Kevin3NF
Some of the best career enhancers you can buy. Why I Go to...
Comments posted to this topic are about the item A Place where AI Technology...
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