Extended Events File Initialization Failure
One of the recommended methods to trap payload data in an XE session is via the use of the event_file target. Sending data to a file has numerous benefits...
2018-03-09
36 reads
Blog Posts
Four Easy Things You Can Do Now To Make Your Power BI Reports More Accessible
Accessibility is often overlooked or ignored when it comes to reporting and data visualization. I think there are two reasons...
2018-03-09
1,040 reads
Precons in Richmond, Philadelphia and New York
I love when I get the opportunity to present at SQLSaturday events. Even more than that, I love when I...
2018-03-09 (first published: 2018-02-28)
1,666 reads
SQL Server RLS feature and GDPR
Of late, there’s been a lot of noise around the term, GDPR. Chances are, some of us even had to...
2018-03-09
386 reads
Appearance: SQL Data Partners Podcast
A couple weeks ago Carlos L. Cachon (blog|twitter) put out a call on Twitter looking for SQL Saturday organizers to join him on the SQL Data Partners Podcast. When...
2018-03-08
3 reads
Availability Group round-robin read-only routing isn't magic
I've been hearing about round-robin read-only routing ever since SQL 2016 came out but whenever I tried to test if...
2018-03-08
296 reads
Catch up on SQL in the City 2018–GDPR Edition
The videos for our SQL in the City 2018 broadcast from last month are up on the Redgate channel in...
2018-03-08
393 reads
Finding Composite Primary Key Columns
You never know when the idea for a script will make an appearance.
I had to work with composite primary keys...
2018-03-08 (first published: 2018-02-23)
3,547 reads
Public preview of Azure SQL Database Managed Instance
Microsoft has announced the public preview of Azure SQL Database Managed Instance. I blogged about this before. This will lead...
2018-03-08
1,222 reads
Public preview of Azure SQL Database Managed Instance
Microsoft has announced the public preview of Azure SQL Database Managed Instance. I blogged about this before. This will lead...
2018-03-08
141 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