Event Tracing for Windows Target
There are many useful targets within SQL Server’s Extended Events. Of all of the targets, the most daunting is probably...
2019-01-03
1,337 reads
Jason Brimhall
File Maintenance – Cleaning Up Old Files
Using SSIS to Maintain the File System
We have all run into a need or a desire to clean up old...
2019-01-03 (first published: 2018-12-21)
2,881 reads
Checking your Memory with XE
It is well known and understood that SQL Server requires a substantial amount of memory. SQL Server will also try...
2019-01-02
327 reads
Checking your Memory with XE
It is well known and understood that SQL Server requires a substantial amount of memory. SQL Server will also try to consume as much memory as possible from the...
2019-01-02
12 reads
Finding Application Session Settings
One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous inside of SSMS, but run miserably inside the application.
Related...
2019-01-01
23 reads
Finding Application Session Settings
One of the underused troubleshooting and performance tuning techniques is to validate the application session settings. Things can work fabulous...
2019-01-01
416 reads
Finding Installed Event Sessions
As a DBA, it is not uncommon to feel like you are marooned off on some tiny little island trying...
2018-12-31
205 reads
Finding Installed Event Sessions
Get off that arctic island and warm up with a little XE fun. This script is quite simple but will show you what you may have out there on...
2018-12-31
6 reads
SQLs Black Box Recorder – sp_server_diagnostics
The diagnostics process will trap various server related health (diagnostics) information related to the SQL Server instance in an effort to try and detect potential failures and errors.
Related Posts:
SQL Servers...
2018-12-30
116 reads
SQLs Black Box Recorder – sp_server_diagnostics
Yesterday i shared the first article in a three part series about the SQL Black Box Recorder, that you can...
2018-12-30
331 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