Waiting, is it a Bad Thing?
Despite the desire to get away from the GUI talk in these articles about Extended Events, I have so far...
2016-01-06
754 reads
Jason Brimhall
Waiting, is it a Bad Thing?
One of the more useful troubleshooting tools (granted when used properly and not with a knee jerk approach) is waits. There are waits in SQL Server that are very...
2016-01-06
10 reads
A day in the Stream
Explore the little function called sys.fn_MSxe_read_event_stream and discover just a little bit more of what Extended Events may be doing behind the scenes with the live data viewer.
Related Posts:
Quick...
2016-01-05
20 reads
A day in the Stream
Enough talk of the GUI with Extended Events (see previous articles in the series if you want to revisit the...
2016-01-05
3,728 reads
Log Files from Different Sources
Well, it has been quite a pause between articles in the series. It is well past time to continue the...
2016-01-05 (first published: 2015-12-30)
1,819 reads
Hidden GUI Gems
The GUI for Extended Events offers some power to help you get started with trying to work with Extended Events....
2016-01-02
1,476 reads
Hidden GUI Gems
I have a few gems that are available to you in the GUI. These gems should help solidify your understanding of the tools available through the GUI to help...
2016-01-02
3 reads
Filtering Logged Data
Explore how to customize the view of the GUI for working with XEvent Log files or XEL files. This further customization does include working with filters.
Related Posts:
Get a List...
2016-01-01
18 reads
Customize the XEvent Log Display
Explore how to configure the XEvents GUI with specific views to suit your needs and tastes for data display by adding, removing or changing the column orders.
Related Posts:
Easy Open...
2015-12-31
8 reads
Customize the XEvent Log Display
In the previous article I showed a couple of methods to merge Extended Event Log files. In that article I...
2015-12-31
1,026 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
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