Log Files from Different Sources
While working with Extended Events, or with any sort of logging or tracing utility, it becomes critical to consume the data from disparate sources or even to consume the...
2015-12-30
11 reads
Jason Brimhall
Histograms and Events
The last few articles covered the pair_matching target and some uses and details that go along with it. For a...
2015-11-03 (first published: 2015-10-22)
1,881 reads
Tricks and Treats with XE
With the proximity to Halloween, it's not hard (knowing me) to figure out why I originally decided to terminate this series on the Eve of Halloween day. Join me...
2015-10-30
4 reads
Tricks and Treats with XE
Halloween is a great time of year. It is unfortunate that it is just one day of the year. That...
2015-10-30
1,022 reads
Default Sessions
So I have blasted through a lot of technical articles about Extended Events. There is a lot of groundwork that...
2015-10-29
1,097 reads
Default Sessions
The focus of this article will be to introduce the default sessions deployed with SQL Server. Some of these are internal and "private" while others are more "public" and...
2015-10-29
35 reads
Azure SQL Database
What hasn't received any TLC is Extended Events from the Azure SQL Database perspective. You may be wondering why it matters since I just said that Extended Events is...
2015-10-28
7 reads
Azure SQL Database
So far I have strictly focused on Extended Events for SQL Server installations. This means I have been looking at Extended...
2015-10-28
759 reads
Exposure to Internals
The premise of the article today is to get a little exposure to some of the internals that may cause a bit of curiosity for you. I will share...
2015-10-27
4 reads
Exposure to Internals
For me, some of the most fun stuff with SQL Server is diving deep into the internals. Diving into the...
2015-10-27
596 reads
Blogs
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...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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