Disabling Indexes
Indexes are probably the number one tool we have to improve performance. That said, there are times when we want...
2019-02-18 (first published: 2019-01-28)
2,466 reads
Blog Posts
Don’t Leave the Database Behind…Or Win If You Do
If you’ve had struggles with database development and had a real world disaster, you could win in a new Redgate...
2019-02-18
166 reads
Error in SSMS: Attempted to read or write protected memory.
There are a lot of reasons to write a blog post. One of my favorites is when I’ve been asked...
2019-02-18
190 reads
Four ways good database management can boost your business
Whatever industry you work in, you will almost certainly have come across a story about how data is transforming your sector. That might be helping to cure a disease...
2019-02-18
37 reads
Four ways good database management can boost your business
Whatever industry you work in, you will almost certainly have come across a story about how data is transforming your...
2019-02-18
259 reads
Installing Extensions to Azure Data Studio
If you’re even thinking about experimenting with, let alone actively using, Azure Data Studio, you need to plan on installing a few extensions. Buck Woody has a great list...
2019-02-18
10 reads
Installing Extensions to Azure Data Studio
If you’re even thinking about experimenting with, let alone actively using, Azure Data Studio, you need to plan on installing...
2019-02-18
316 reads
Partitioning 5: The extra partition
So, we’ve set up a table with table partitioning on the RIGHT for CreationDate. We defined 11 partitions, and in...
2019-02-18
184 reads
Speaking at SQLBits in March 2019
I’m super excited about the fact I’ll be speaking at SQLBits this year. It’s my first time as a speaker...
2019-02-18
121 reads
SQL Server, What Waits Happened In The Last X Seconds
There are plenty of scripts out there that can show you the waits that are occurring on your server, however,...
2019-02-18
181 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