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
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
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...
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