Crosstab queries using PIVOT in SQL Server
In this tip we look at how to construct a SQL Server PIVOT query with an example and explanation.
2019-04-04
Articles
How to Monitor IDENTITY columns to prevent unplanned downtime
If a table runs out of IDENTITY values then it, and any dependent services and applications, will be "read-only" until the problem is fixed. Steve Jones explains how to set up a custom monitor to detect and prevent such problems.
2019-04-04
Help us define the state of SQL Server monitoring in 2019
Last year we ran the industry’s first ever state of SQL Server monitoring survey, the results not only gave great insight for the community but helped us shape our product development to ensure we were meeting the needs that you were asking for. So what has changed in a year? Tell us for your chance to win a $250 Amazon voucher.
2019-04-03 (first published: 2019-03-21)
2,280 reads
Reaping the benefits of the Window functions in T-SQL
Exploring the potential benefits of the T-SQL Window functions (OVER, LAG, and LEAD) in this piece. You can learn how to achieve up to 50% performance boost by replacing a single function call.
2019-04-02 (first published: 2014-03-24)
25,948 reads
Enforce SSL for connecting to AWS RDS Instance of SQL Server
Learn how to force all SQL Server connections to an AWS RDS instance to use SSL encrypted connections.
2019-04-02
Have your say on the state of SQL Server monitoring
In this blog, we review the key insights from last year’s State of SQL Server Monitoring report. One year on, how has this changed? Read the blog to find out how you can help us define the state of 2019 plus a chance to win a $250 Amazon voucher.
2019-04-02 (first published: 2019-03-18)
1,864 reads
SQL Server 2019 Adds CosmosDB Support
SQL Server 2019 will bring more than graph query languages. We will be able to use a document query engine and a specific JSON engine.
2019-04-01
3,232 reads
Converting a History Table into a System-Versioned Temporal Table
Temporal tables were introduced with SQL Server 2016. To take advantage of this feature, you might start fresh with a brand new table. It is possible, however, to convert an existing table with accumulated history to the new functionality. In this article, Mala Mahadevan explains how to create temporal tables for both scenarios.
2019-04-01
2019-03-29 (first published: 2017-12-04)
5,775 reads
SQLServerCentral v3 coming tomorrow
The next version of SQLServerCentral will go love on Saturday, March 30, 2019
2019-03-29
310 reads
Blogs
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...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
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