Compressing Outcomes
You find yourself cruising along, just doing your thing as a database administrator. Then the CIO plops down into a...
2015-08-24
715 reads
SQL RNNR
Compressing Outcomes
Find yourself struggling to determine the outcome of attempted compression settings in your database? This should help!
Related Posts:
Failed to Create the Audit File December 31, 2017
Disk Space and...
2015-08-24
3 reads
Tables, Columns and Defaults Oh My!
Picture this if you could. You inherit a new database either through the change of a job, or finding a...
2015-08-31 (first published: 2015-08-19)
2,013 reads
Tables, Columns and Defaults Oh My!
The joys of inheriting a new database and being thrown into the fire to quickly assimilate as much information about the database as possible can be troublesome. This script...
2015-08-19
2 reads
Compressing Encrypted Backups
A common requirement, whether it be based out of pure want or truly out of necessity, is to make a...
2015-08-11
3,336 reads
Compressing Encrypted Backups
A common requirement, whether it be based out of pure want or truly out of necessity, is to make a large database backup file, that is encrypted, be much...
2015-08-11
4 reads
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
What is DBCC?
What is really mean by DBCC and what do people mean when they say DBCC?
Related Posts:
Database Corruption and IO Errors January 18, 2018
Common Tempdb Trace Flags - Back...
2015-08-11
33 reads
HealthySQL – A Review
How well do you know the health of your SQL Servers and databases? Ever wonder about the current health or...
2015-08-14 (first published: 2015-08-07)
2,240 reads
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
9 reads
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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