Redgate Lives DevOps
At Redgate, we release a lot of changes to our products. In fact, this is the “About Redgate” slide I’ve...
2018-08-28
1,116 reads
Blog Posts
Top 5 Reasons You Should Be Excited About Power BI Composite Models
In July there were many exciting new features that were released to Power BI, but perhaps the most eagerly awaited...
2018-08-28 (first published: 2018-08-13)
3,007 reads
TSQL Tuesday #105: WrapUp
When I hosted this past TSQL-Tuesday, I fully expected to have the wrap-up done a few days later. Lots of...
2018-08-28
234 reads
Undercover Catalogue 0.1 Released
Easily Keep Track of All Your SQL Servers
We know what it’s like when you’ve got 101 SQL Servers to manage,...
2018-08-28
282 reads
Upcoming Performance Tuning Webcast
On September 13, 2018, at 3 PM Eastern (USA), I’ll be giving a webcast for MSSQLTips.com on finding and correcting...
2018-08-28
214 reads
What is Automatic Tuning in Azure SQL Database
Microsoft has long given us DBA tools and suggestions to help tune databases, to fix queries with indexes, and many...
2018-08-28
517 reads
Advantages of Azure Resource Manager (ARM) Deployment Model
Are you just starting out with Azure and wonder: What is Azure Resource Manager (ARM) Deployment Model? Or what’s the...
2018-08-27
266 reads
Copying formatted text out of a grid column.
I was reading a post today by Bert Wagner (b/t).
Displaying Long Variable Values in SQL Server
By the way, if...
2018-08-27
904 reads
SQL Server Encryption, What’s The Key Hierarchy All About?
I’m sure that we all know that SQL Server includes all sorts of interesting functionality to allow us to encrypt...
2018-08-27 (first published: 2018-08-09)
1,846 reads
SQLCLR vs SQL Server 2017, Part 8: Is SQLCLR Deprecated in Favor of Python or R (sp_execute_external_script)?
(last updated: 2019-01-10 @ 18:00 EST / 2019-01-10 @ 23:00 UTC )
With the additional (and annoying) configuration step required to get SQLCLR Assemblies...
2018-08-27 (first published: 2018-08-09)
4,067 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers