Setting up Transparent Data Encryption (TDE)
You can set up Transparent Data Encryption (TDE) when you first create a database, or you can apply it to...
2018-01-26
2,672 reads
Matthew McGiffen
- Twitter: @MattMcGiffen
- Website: https://matthewmcgiffen.com/
How does Query Store capture cross database queries?
When I was writing my post Capture the most expensive queries across your SQL Server using Query Store a question crossed...
2017-11-16
644 reads
Avoiding confusion with SQLCMD variables
SQLCMD variables can be a useful way of having changeable parameters for your SQL scripts, allowing you to specify the...
2017-11-01
10,323 reads
Bug with STATISTICS TIME?
I love the STATISTICS IO and STATISTICS TIME commands. They are such a powerful and easy way to be able...
2017-10-17
509 reads
Setting up Change Data Capture (CDC)
As mentioned in my post Auditing Data Access in SQL Server for GDPR Compliance CDC can be a useful tool for...
2017-10-03
17,356 reads
When Deadlocks Become Art
We’ve all had to solve deadlock issues. Identify the two conflicting pieces of code, work out an appropriate change to...
2017-09-19
700 reads
Setting the Sample Rate for Auto Stats updates
SQL Server functionality can move on pretty quickly sometimes, and it’s not always all about the big features but the...
2017-09-12
2,235 reads
Viewing the Statistics Objects Used to Create an Execution Plan
A while ago now I was running some Performance Tuning workshops and was asked how you can find out which Statistics...
2017-09-01
412 reads
How to be a bad interviewer
In the monthly SQL blogging party that is T-SQL Tuesday (brainchild of Adam Machanic), Kendra Little has invited us this...
2017-08-08
1,426 reads
Manually updating Statistics
Even though SQL Server automatically updates statistics in the background for you, you may find there are times when you...
2017-08-01
2,435 reads
Blogs
AI and Data Engineering on the Edge: The Good, the Bad, and the Overhyped
Running AI and data pipelines on the edge instead of the cloud has gone...
UNION vs UNIONALL: #SQLNewBlogger
By Steve Jones
While writing another post I realized my UNION query didn’t work as one might...
T-SQL Tuesday #199 Invitation: Back to on-prem?
It’s time for T-SQL Tuesday again! And we’re almost to number 200! T-SQL Tuesday...
Forums
Secure Cached Plans
Comments posted to this topic are about the item Secure Cached Plans
Complex Data Processing with dbt Python Models: The Fabric Modern Data Platform
Comments posted to this topic are about the item Complex Data Processing with dbt...
Over or Under Provisioned
Comments posted to this topic are about the item Over or Under Provisioned
Question of the Day
Secure Cached Plans
The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?
See possible answers