A well-established technique for improving application code quality, during software development, is to run unit tests, in conjunction with a code coverage tool. The aim is not only to test that your software components behave as you would expect, but also that your suite of tests gives your code a thorough workout.  Read more...

A basic introduction for developers about creating a connection from .Net to SQL Server, and some of the options available.  Read more...

The pre-conference sessions for the 2018 PASS Summit were released.  Read more...

Grant talks about the challenges of helping people in online forums and getting them to learn rather than grab the first solution.  Read more...

Rick Dobson explains the Relative Strength Index (RSI), and shows how to create a TSQL script that computes the RSI for a stock closing price series.  Read more...

Are you responsible for data privacy and protection of SQL Server databases in your organization? Then you might be interested in Redgate’s brand new conference, the SQL Privacy Summit, taking place in London on Friday 18 May.  Read more...

Learn how to load fixed width flat files to staging tables in this article from Samuel Vanga.  Read more...

How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or anything like a string starting with 'XYZ'?  Read more...

Data is becoming the source of truth, but we need to learn to accept that.  Read more...

When we build software, are we empathetic to how others (literally) view our software?  Read more...

Exploring briefly the difference between using Amazon Machine Images running SQL Server and using SQL Server instances on Amazon's Relational Database Service.  Read more...

The Query Store captures a history of queries, execution plans, and runtime statistics, which persist within SQL Server and can be reviewed later.  Read more...

This webinar will focus on branching and merging with Visual Studio Team Services (VSTS) as part of a DevOps approach to database development. It will also show how Redgate tools plug into VSTS to enable the build, test and deployment of your database changes. There will also be plenty of time to ask Grant and Arneh questions.   Read more...

The use of IoT is growing in businesses.  Read more...

In this level, we dive deeper into predicates and the various ways to structure them in an RLS environment.  Read more...

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...

Artificial intelligence (AI) is touching many parts of our lives and careers. Rama Anem discusses the impact of AI on software testing and how testers’ skills must adapt.  Read more...

Steve wants to know which version of SQL Server you like the best.  Read more...

The T-SQL language expanded in SQL Server 2017 with the TRIM() function.  Read more...

Brent Ozar explains that if you're going to do continuous integration or deployment, you've got a rocky road ahead of you.  Read more...