Message in a Bottle of XE
One of the age old features that most probably take for granted in SQL Server happens to be the error...
2017-12-27
177 reads
SQL RNNR
Message in a Bottle of XE
Considering this "feature" for everything that is SQL Server related, does this mean that all Extended Events related messages are accessible in sys.messages?
Related Posts:
Implicit Conversion Fail May 31, 2019...
2017-12-27
5 reads
12 Days Of Christmas and SQL
One of my all-time favorite times of the year happens to be the Christmas Season. I enjoy the season because...
2017-12-26
447 reads
12 Days Of Christmas and SQL
One of my all-time favorite times of the year happens to be the Christmas Season. I enjoy the season because...
2017-12-26
179 reads
12 Days Of Christmas and SQL
In the spirit of the 12 Days of Christmas and Giving, I have a 12 Day series that I generally try to do each Holiday Season. The series will...
2017-12-26
4 reads
Best New(ish) SSMS Feature
We all probably use SQL Server Management Studio (SSMS) on a very frequent basis. Just for giggles, lets just say...
2017-12-26
1,264 reads
Best New(ish) SSMS Feature
We all probably use SQL Server Management Studio (SSMS) on a very frequent basis. Just for giggles, lets just say...
2017-12-26
142 reads
Best New(ish) SSMS Feature
Enabling the scrollbar map has saved me oodles of time - even without the preview option enabled. I can much more quickly hop to different segments of code with...
2017-12-26
4 reads
Extended Events Permissions
A common question that I am asked about Extended Events relates to what kind of permissions are required in order...
2017-12-26
17,075 reads
Extended Events Permissions
A common question that I am asked about Extended Events relates to what kind of permissions are required in order...
2017-12-26
154 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