Azure SQL Database and Transaction Log
Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know...
2019-02-13
189 reads
Blog Posts
Careful with Session_Context()–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2019-02-13 (first published: 2019-01-24)
2,220 reads
Error: 9002, Severity: 17 log_reuse_wait_desc = ‘log_backup’ transaction log full
Shrink log file for log_reuse_wait_desc =...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-02-13
18 reads
Error: 9002, Severity: 17 log_reuse_wait_desc = ‘log_backup’ transaction log full
Shrink log file for log_reuse_wait_desc =...
[[ This is a content summary only. Visit my website for full links, other content, and more!...
2019-02-13
131 reads
Free SQL tuning tool: How’s My Database?
It’s taken longer than I thought it may and I’ve run into several problems along the way but had a...
2019-02-13
224 reads
Partitioning 2: Getting and measuring partition elimination
In Partitioning 1, my query searched through all 1-12 partitions. Let’s see if we can reduce that number.
Adding the partitioning...
2019-02-13
1,687 reads
Proposed SQL Server defaults: cost threshold for parallelism
A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set...
2019-02-13
197 reads
Speaking at SQL Saturday Victoria
I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March 16, 2019. I will be presenting my What is...
2019-02-13
23 reads
Speaking at SQL Saturday Victoria
I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March...
2019-02-13
117 reads
Speaking Internationally at SQLBits
I am very excited and lucky to be speaking at my very first international conference, SQLBits. SQLBits, the largest SQL...
2019-02-13
188 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
Bank CIMB Niaga Bandung - Asia Afrika (0813-7071-893)?
WhatsApp:08137071893 Wisma Cimb Niaga, Jl. Gatot Subroto No.2, Burangrang, Kec. Lengkong, Kota Bandung, Jawa...
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
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers