What is DBCC?
If I ask you what is DBCC, what would your answer be?
I want you to think about that one for...
2015-08-11
10,636 reads
Jason Brimhall
HealthySQL – A Review
A quick look into the book by Robert Pearl: Healthy SQL.
Related Posts:
My Book Contributions November 30, 2018
Profiler for Extended Events: Quick Settings March 5, 2018
How to be...
2015-08-07
8 reads
Table Size Script Update for 2015
Newest update to the script to help discover and track object sizes within a database.
Related Posts:
Refresh SQL Modules November 9, 2018
Drop That Schema October 27, 2017
An Experiment...
2015-08-04
5 reads
Table Size Script Update for 2015
As was recently promised, I have an update to an old tried and true script for calculating the size of...
2015-08-04
1,057 reads
What’s the Size of that Index?
I have previously written about finding what the big space consumers are within the database. I even shared scripts in...
2015-08-04 (first published: 2015-07-27)
2,311 reads
Internal Tables and Space Used
Some of the beauty of SQL Server is the complexity that it holds. Some of that complexity is right before...
2015-07-30
2,692 reads
Internal Tables and Space Used
Some of the beauty of SQL Server is the complexity that it holds. Some of that complexity is right before our eyes. And some of that requires a little...
2015-07-30
8 reads
What’s the Size of that Index?
When you need to figure out how indexes are contributing to the overall size of a table within a database, this script will help you!
Related Posts:
Ghosts in your Database...
2015-07-27
5 reads
Extended Events Removed from 2016
Extended Events continue to grow and improve - even with the removal of a few events.
Related Posts:
Upgrading From SQL Server Profiler December 26, 2018
Correlate SQL Trace and Actions...
2015-07-22
8 reads
Extended Events Removed from 2016
SQL Server 2016 is on the horizon. We have a few CTP versions already released for download, allowing people to...
2015-07-22
668 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers