Versions of Stored Procedures
I never knew this, but stored procedures have versions.
I was browsing the CREATE PROCEDURE doc page, and stumbled upon this...
2019-02-06
1,056 reads
Blog Posts
What is Azure Key Vault?
Keys and secrets (AKA passwords) are an essential part of data protection management not only on-premises, but within the cloud...
2019-02-06
258 reads
When the buffer pool isn’t just in memory
Last time we looked at the four major components of a computer system, and then looked at the SQL Server...
2019-02-06
198 reads
Forensic Analysis on Updated Values of Database Tables to Check Any Digital Crime
SQL Server is a relational database management product developed by Microsoft. It is prominently deployed by enterprises all over the...
2019-02-05
542 reads
Automating Database Maintenance with Jess Pomfret and dbatools
Watch this week's video on YouTube
dbatools is one of the coolest community projects I've seen - it is amazing how many commands are available to help make managing your...
2019-02-05
8 reads
Automating Database Maintenance with Jess Pomfret and dbatools
dbatools is one of the coolest community projects I’ve seen – it is amazing how many commands are available to help...
2019-02-05
204 reads
Automating Database Maintenance with Jess Pomfret and dbatools
Watch this week's video on YouTube
dbatools is one of the coolest community projects I've seen - it is amazing how many commands are available to help make managing your...
2019-02-05
5 reads
Easy Permissions Audit
Something I have written about more than a handful of times is the need to audit. When people think about...
2019-02-05 (first published: 2019-01-21)
2,591 reads
Forensic Analysis on Updated Values of Database Tables to Check Any Digital Crime
SQL Server is a relational database management product developed by Microsoft. It is prominently deployed by enterprises all over the world to securely maintain crucial database in a well-organized...
2019-02-05
45 reads
I am speaking at SQLSaturday Guatemala 2019
I’m very thrilled to announce that I will be participating as speaker in this year’s SQL Saturday #828 event in Guatemala...
2019-02-05
161 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers