Additional Articles

All authors

External Article

Implementing Continuous Integration for Databases

Continuous integration (CI) is becoming more and more common in application development. It ensures code and related resources are integrated regularly and tested by an automated build system, and highlights problems early in the development process. But what about database development? Can the same advantages of CI be applied to production databases? Where do you start? How do you tackle it? Sjors Takes relates his experience.

2015-11-09

2,651 reads

External Article

How to Create Ten 200GB Test Databases in 60 Seconds

In a recent survey run SQL Server Central, 58% of respondents admitted that their test database is an exact copy of their production database. Many of these respondents concede that they should be removing sensitive data, but aren’t. It seems that the desire to have realistic data will, for many, trump the requirement to keep sensitive data out of development and test environments. In this blog post, Redgate's Jason Crease introduces the new 'SQL Instant Clone' and explains how it could help.

2015-11-06

4,497 reads

External Article

So You Need to Expose JSON Endpoints

Even the most experienced programmers can be caught out unawares by software they've used for years without trouble. Dino Esposito explains why and how the JSON method in an ASP.NET MVC controller class suddenly started to cause an exception on a production server, and how he fixed the problem.

2015-11-03

2,813 reads

External Article

A Skills Roadmap for DBAs in the Cloud Era

Cloud computing is on the move. Slowly but surely, businesses are transitioning more and more key pieces of infrastructure to the cloud in order to take advantage of cost, flexibility and agility benefits. And databases, the heart and soul of all applications, are the most critical component of this transition. Gerardo Dada explores the topic.

2015-11-02

3,769 reads

External Article

Top 10 Most Common Database Scripts

What are the scripts that a working DBA uses so often that they become part of the 'muscle memory'? Grant Fritchey asked the question on the forums of SQL Server Central. From the large response, Grant was able to pick out the ten most popular T-SQL commands, scripts, or fragments. It seems as if, despite the range of tasks we do, there are some common tools we use.

2015-10-29

9,303 reads

External Article

Using Power BI in a Hybrid Environment

This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources. Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores.

2015-10-28

2,633 reads

All authors

Blogs

SQL Server Journey (Part 1)- Enterprise Database 2016

By

Continued thinking about my Journey blog where we have to look back at the...

PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)

By

PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...

The 2026 Redgate Summit in New York City

By

We’re coming back to New York, which is exciting for me. I love NYC....

Read the latest Blogs

Forums

Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Seeding a Fabric Warehouse with...

Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Seeding a Fabric Warehouse with...

Doing the Little Things

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Doing the Little Things

Visit the forum

Question of the Day

Historical Data Tracking

If I want to track historical data values, which mechanism should I use?

See possible answers