Redgate has committed to organizing a free virtual Summit for the PASS Community this fall. To help guide the format and provide you and the data platform community with the best virtual event experience possible, we'd appreciate your input. As a thank you for your feedback you could win a Peloton Bike or $3,000 (the equivalent in your local currency) to donate to your chosen charity.
2021-04-13
When we don't have all the information needed to model data, we often use NULL. However, that causes other issues.
2021-04-12
2,740 reads
Join Microsoft's Rohan Kumar, and a full team of Azure SQL experts, for Innovate Today with Azure SQL. This free digital event from Microsoft lets you choose the sessions and technical demos that are most interesting to you and focus on the capabilities and possibilities that you want to learn more about.
2021-04-12
Out-of-control tempdb growth must be managed to keep the server running. Monica Rathbun gives her strategy to handle unexpected tempdb growth.
2021-04-12
A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL.
2021-04-09 (first published: 2018-11-27)
15,391 reads
One of the problems with data analysis is the potential for anomalies that can skew results. In this article we look at a Power BI feature to detect anomalies and outliers in the data.
2021-04-09
Redgate recently invited customers to share their tops tips for improving productivity using Redgate tools. This blog outlines their hints and includes relevant training resources to further your learning.
2021-04-09
Howto restore master database on a Clustered SQL Server 2019 Instance
2021-04-08
4,378 reads
In this article we cover interesting facts about the SQL Server model database and how new databases inherit properties from the model database.
2021-04-08
This article explains the challenges of DevOps automation for databases, starting with how to manage the database, as a set of SQL scripts, in the version control system, and then how to start building an integrated and automated script pipeline for continuously testing and deploying database schema changes, alongside the application code.
2021-04-08
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
I am not understanding why this command completes "successfully" and it seems correct to...
get-ChildItem C:\ -recurse -erroraction silentlycontinue | sort length -descending | select -first 10 FullName,length...
Which of these indexes is superseded by another?
See possible answers