Using Backup Encryption with an External Certificate
Learn how to load an external certificate into SQL Server to encrypt your backups.
2019-04-25
4,523 reads
Articles
Reporting Services Basics: Overview and Installation
SQL Server Reporting Services has changed quite a bit since it was introduced in 2004. Despite new analytic services like Power BI, SSRS is still a popular tool for paginated reports. In this article, Kathi Kellenberger explains the architecture of SSRS and walks you through installing an SSRS development environment on your workstation or laptop.
2019-04-25
SQL in the City Summits – UK, US & Down Under
Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in April, May and June. If you’re interested in learning how your business can benefit from implementing Compliant Database DevOps this event is for you. Find out who’s presenting and register for a Summit near you today. Register now
2019-04-25 (first published: 2019-03-22)
1,376 reads
Tracking the number of active sessions on a database using SQL Monitor
Phil Factor creates a simple custom metric to track the number of sessions that have recently done a read or write on a database. Having established a baseline for the metric, you'll be able to spot, and investigate the cause of, any wild deviations from normal behavior.
2019-04-25
5 reasons why backup and restore doesn’t cut it in dev and test
The provisioning process is a critical part of database development. Redgate's Rebecca Edwards looks at a tool that can remove the pain points of backup and restore and replace them with a more efficient solution can hugely benefit your organization and the quality of life of you and your team.
2019-04-24
SQL Server Database Users to Roles Mapping Report
In this tip we look at a SQL Server function that generates a report of all users and their assigned database roles.
2019-04-24
Uploading On-Premises Data as JSON to Azure Blob Storage using SSIS
Using Azure Feature Pack for Integration Services to access Blob storage from Azure into SSIS packages
2019-04-23 (first published: 2019-03-26)
2,477 reads
Compressed Microsoft SQL Server Backups by Default
Learn how to create default database compression for your SQL Server databases.
2019-04-23
Its time to accelerate the State of DevOps
Redgate is joining forces with DevOps Research and Assessment (DORA), now part of Google Cloud, as a sponsor of the 2019 Accelerate State of DevOps Report, and we're excited to see what the research uncovers.
This year, the survey's focus areas include deployment toolchains, cloud, disaster recovery, the technical environment, how we work, and more. Take the survey to help us understand how to make the (software) world better.
2019-04-23
Service Broker Part 2: Why Service Broker
The second part of this series focuses on the advantages of Service Broker over other messaged-based technologies to introduce asynchronous message processing into your database applications.
2019-04-22
16,880 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers