Dynamics AX Event Session
Many moons ago, I wrote about how to enable the context info for Dynamics AX. Having the context info enabled...
2018-01-10 (first published: 2018-01-03)
1,137 reads
SQL RNNR
Dynamics AX Event Session
There are many many uses for Extended Events. In this article I show a quick session setup that can be useful in the troubleshooting of various different problems (most...
2018-01-03
12 reads
Correlate SQL Trace and Actions
I have recently written about the pains of correlating SQL Trace events to Extended Events (XE) events. That article can...
2018-01-01
488 reads
Correlate SQL Trace and Actions
I have recently written about the pains of correlating SQL Trace events to Extended Events (XE) events. That article can...
2018-01-01
290 reads
Correlate SQL Trace and Actions
I have recently written about the pains of correlating SQL Trace events to Extended Events (XE) events. That article can...
2018-01-01
296 reads
Correlate SQL Trace and Actions
I have recently written about the pains of correlating SQL Trace events to Extended Events (XE) events. That article can...
2018-01-01
316 reads
Correlate SQL Trace and Actions
In the world of profiler and SQL Trace, these actions were an actual part of the payload for the Trace event. In XE, these actions are more like add-ons....
2018-01-01
10 reads
Failed to Create the Audit File
One day while checking things for clients, I happened across a fun little error message – “SQL Server Audit failed to...
2017-12-31
1,941 reads
Failed to Create the Audit File
One day while checking things for clients, I happened across a fun little error message – “SQL Server Audit failed to...
2017-12-31
1,228 reads
Failed to Create the Audit File
One day while checking things for clients, I happened across a fun little error message - "SQL Server Audit failed to create the audit file". It just so happens...
2017-12-31
57 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers