How to Count the Total Number of Rows Across Multiple Tables
I have been working on SQL Server Consulting assignment, a SQL Server 2014 migration for a new client over the...
2017-01-31 (first published: 2017-01-22)
45,207 reads
Blog Posts
Join webinar on SQL Server 2016 Always on
Click [HERE} to Join webinar.
SQL Server 2016 - AlwaysOn
An availability group supports a failover environment for a discrete set of user databases, known...
2017-01-31
547 reads
JSON Support Is The Best New Developer Feature in SQL 2016 — Part 2: Creating JSON
This is the second article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON.
Part...
2017-01-31
24 reads
My First SQL Saturday – As A Speaker!
I am so honored and excited to have been selected to speak at SQL Saturday Richmond on March 18, 2017.
I...
2017-01-31
609 reads
Pesky Percent File Growth
As DBAs we all know setting your file growth to grow by percent is not optimal. It can cause all...
2017-01-31
744 reads
Power BI Custom Visuals Class (Module 35 – Box and Whiskers (Jan Pieter))
In this module you will learn how to use the Box and Whiskers (Jan Pieter) Power BI Custom Visual. This...
2017-01-31 (first published: 2017-01-24)
1,754 reads
Speaking at Techorama 2017
I’m delighted to announce that I’m selected as a speaker for the Techorama event.
Techorama is a developer congress focusing (but...
2017-01-31
676 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...
2017-01-31
542 reads
SQL Server 2008 RTM - Maintenance Plans need Integration Services installed
The tail end of last week was a bit of a throwback week for me. For reasons that I’ll not...
2017-01-31
909 reads
#ReadyRoll at #SQLintheCity
When Redgate purchased ReadyRoll a few years ago, I wasn’t sure this was a great idea. After all, SQL Source...
2017-01-30
785 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