Why Redgate is Running a Database Development Disasters Contest?
Kendra Little explains why Redgate would like to hear your stories of how the database has been left behind.
2019-02-14
249 reads
Articles
SQL Server Perfmon counters that are still interesting in 2019
Years ago, my first go-to tool for performance tuning was Performance Monitor: it was available everywhere, worked in all versions, and gave me a lot of useful information without paying for a monitoring tool. Since then, I’ve moved on – wait stats are a much better starting point – but there are still 3 good Perfmon counters that I rely on.
2019-02-13
2,442 reads
Using Computed Columns
Although computed columns are from the beginning of SQL Server, not everyone knows how to use them. This article will help you better understand how it works.
2019-02-12
12,418 reads
Infrastructure Planning for a SQL Server Data Warehouse
In this tip we look at some things you should think about when planning for a SQL Server data warehouse.
2019-02-12
2,879 reads
Empty Thoughts: Working with NULL
Whether or not to have NULLable columns in a table can be a religious debate, and how missing data is represented should be carefully considered during database design. In this article, Joe Celko considers the ways that SQL Server handles NULLs in several situations.
2019-02-11
3,289 reads
Using SQL Server and R Services for analyzing Sales data (Part 3)
Using R integration for analyzing sales data in WideWorldImporters database
2019-02-08 (first published: 2017-01-17)
4,873 reads
Which Version of SQL Server Should You Use?
Wait! Before you install that next SQL Server, hold up. Are you sure you’re using the right version?
2019-02-08
4,012 reads
Protecting SQL Server Data Using Static Data Masking
In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by developers and testers must not contain private and sensitive data from production databases. To help DBAs protect data, Microsoft have released a new feature as part of SSMS called Static Data Masking. In this article, Greg Larsen demonstrates how to use this new feature.
2019-02-07
2,794 reads
Import data dynamically using R and Python in Power BI Desktop
Learn how to import data into Power BI using either R or Python scripts.
2019-02-06
2,238 reads
Better Code Reviews with GIT
As more dev teams move their code to Git, it’s important to understand the differences between it and other tools they have used in the past. In this article, Michael Sorens provides some good advice about doing code reviews with Git.
2019-02-05
3,221 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
The Large Encoded Value
Comments posted to this topic are about the item The Large Encoded Value
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers