The SQL Privacy Summit
This May 18th, Redgate is putting on a SQL Privacy Summit for people that are looking for solutions to help...
2018-03-14
1,247 reads
Blog Posts
Understanding DBCC FLUSHAUTHCACHE
This command only applies to Azure SQL Database, at a high level it empties the database authentication cache for logins...
2018-03-14
734 reads
What's New In SQL Server 2017? at the March '18 Baton Rouge SQL Server User Group
Thanks to everyone to attended the BRSSUG meeting tonight at our sponsor's location at the Baton Rouge Alliance Safety Council...
2018-03-14
545 reads
A look back from the future. – TSQL Tuesday #100
The date is July 14th, 2026 and it’s TSQL Tuesday #200. We are still using SQL Server, and in fact...
2018-03-13
293 reads
Crazy Data Science
I am pretty hyped to be able to finally announce a new project of mine that I have been working on for...
2018-03-13
350 reads
Crystal Balls
In the centenary edition of the monthly blogging party that is T-SQL Tuesday, Adam Machanic asks us to look forward...
2018-03-13
318 reads
2018-03-13
244 reads
Error 33206 - SQL Server Audit Failed to Create the Audit File
One of the joys of working with SQL Server is the descriptive and meaningful error messages, right?
https://vignette.wikia.nocookie.net/batmantheanimatedseries/images/a/a7/DiD_39_-_Joker_Vision.jpg/revision/latest?cb=20160610021326
Exhibit A - the 33206:
Error:...
2018-03-13 (first published: 2018-03-05)
16,684 reads
Full Automatic Tuning: SQL Server 2026’s Most Killer Feature
This post is a response to this month’s T-SQL Tuesday #100 prompt by the creator of T-SQL Tuesday himself, Adam Machanic. ...
2018-03-13
277 reads
Full Automatic Tuning: SQL Server 2026's Most Killer Feature
This post is a response to this month's T-SQL Tuesday #100 prompt by the creator of T-SQL Tuesday himself, Adam Machanic. T-SQL Tuesday is a way for SQL Server bloggers...
2018-03-13
3 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
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...
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