What is Database Continuous Integration?
This is an introductory article to explain what Continuous Integration (CI) is and how it can be used in database development.
2015-04-07
6,543 reads
Articles
Deleting Historical Data from a Large Highly Concurrent SQL Server Database Table
In this tip, Daniel Farina explains an unconventional way of deleting millions of old records from a table which is accessed by a system 24x7, and without impacting that system.
2015-04-07
10,661 reads
A Hazard of Using the SQL Update Statement
If you've never encountered this quirk of the SQL UPDATE statement, you should take a look and find a simple way around it.
2015-04-06 (first published: 2013-09-09)
27,742 reads
Introduction to SQL Server Spatial Data
More and more applications require the handling of geospatial data. It is easy to store spatial data, but it takes rather more thought to retrieve and manipulate it. Tasks like searching neighborhoods, and calculating distances between points is often required from databases. But how do you start? Roy and Surenda take you through the basics.
2015-04-06
9,426 reads
Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)
It's an old problem with a solution that's nearly as old. SQL Server MVP Jeff Moden shows us the old trick mixed with a slick trick to format the duration as extended hours, minutes, seconds, and milliseconds.
2015-04-03 (first published: 2014-01-16)
63,771 reads
Azure Active Directory - Schema Extensions
The Azure Active Directory Graph API enables some interesting scenarios that you can implement in your applications by enabling you to query and manipulate directory objects in Azure AD. In this article, Rick Rainey provides a clear walkthrough of its implementation.
2015-04-03
6,836 reads
A More Versatile SQL Server Random Number Function
Image a situation when you use the SQL Server RAND() T-SQL function as a column in a SELECT statement, and the same value is returned for every row as shown below. In this tip, Dallas Snider explains how you can get differing random values on each row.
2015-04-02
10,277 reads
Get Your Service Broker Messages in Order. Always.
Learn how you can guarantee the ordering of all messages in a Service Broker queue, regardless of conversations.
2015-04-01
3,139 reads
Deploying the same database to many different RDBMSs
With the idea of a generic Dacpac defined by international standard, comes the potential for a Visual Studio developer to use SSDT to create a generic database model to a SQL-92 compliant standard that can then be deployed to any one of the major RDBMSs. The same database model would be deployable to Oracle, MySQL, or SQL Server, for example. Professor Hugh Bin-Haad explains the reasoning and technology behind this.
2015-04-01
11,218 reads
Finally, a Universal Data Integration Utility
Earlier today, a revolutionary product was released: a universal data integration utility.
2015-04-01
6,687 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers