SQL Server vNext: sys.dm_db_stats_histogram
Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics histogram...
2017-02-21
378 reads
Blog Posts
We Hired!
The response to our most recent job position was incredible, and I’d like to thank all of the folks who...
2017-02-21
398 reads
AlwaysOn Availability Groups: Step by Step Setup
An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of...
2017-02-20
22 reads
AlwaysOn Availability Groups: Step by Step Setup
An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail...
2017-02-20
78,222 reads
DevOps Webinar Tomorrow
A quick reminder that tomorrow, Feb 21 at 12pm EST, I’ll be hosting another DevOps, Database Lifecycle Management (DLM) webinar....
2017-02-20
713 reads
Monday Coffee 2017-02-20
No rugby on last weekend so I didn’t have anything to distract me from working. On another note, my flat...
2017-02-20
254 reads
Out of memory error because of the very low virtual address space – Error 701 – Trace Flag 8075
If you are dealing with a SQL Server which got a lot of memory, you may encounter the out of...
2017-02-20
1,292 reads
Penny wise, pound stupid
Growing up my mother used this phrase quite a bit. Penny wise, pound stupid. (In case you didn’t know the...
2017-02-20
426 reads
Setting up SQL Server to SQL Database (Azure) Replication
I had a need to setup transactional replication from my SQL Server to SQL Database (Azure) where I only needed...
2017-02-20
392 reads
SQL Clone and Encryption
I’ve been testing and working with SQL Clone for the last few months, trying to help the devs at Redgate...
2017-02-20 (first published: 2017-02-15)
1,624 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers