My backup and SLEEP_BPOOL_FLUSH
I noticed that my backup was taking longer than usual. I went to Perfmon to look at some counters, more...
2017-02-01
829 reads
Blog Posts
Running SSMS 2016 in Read Uncommitted Mode
Back in July when we received the first official release of SSMS not tied to an engine release we got...
2017-02-01 (first published: 2017-01-25)
2,049 reads
SCOPE_IDENTITY() or @@IDENTITY
I've seen a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from...
2017-02-01 (first published: 2017-01-27)
3,239 reads
Speaking at SQL Konferenz 2017
I’m heading back across the Atlantic this February for SQL Konferenz. This is an intimate SQL Server event in Darmstadt...
2017-02-01
567 reads
SQL and the other technologies
I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is taken from StackOverflow. Charted data looks like in...
2017-02-01
21 reads
SQL and the other technologies
I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is taken from StackOverflow. Charted data looks like in...
2017-02-01
18 reads
Write-Host || Cannot invoke this function because the current host does not implement it
Issue: While running powershell in SQL job step, I am getting below error: –
A job step received an error at...
2017-02-01
1,512 reads
A Letter To A Younger Yates
Hello much younger Yates. Hope you’ve been doing well. Why don’t you pull up a chair and stay for a...
2017-01-31
694 reads
Another 5 Power BI Tips
If you’ve been at least paying attention to my blog a little bit, you’ve probably noticed I occasionally blog about...
2017-01-31
1,159 reads
Disabling #sqlprompt Formatting
I love SQL Prompt, especially the new formatting engine. However, it’s not perfect, and there are times I don’t want...
2017-01-31
947 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers