How to Eliminate Gaps in Identity Values in SQL Server by Disabling the Identity Cache
Learn how to remove gaps in Identity values in SQL Server caused by Identity Cache.
2019-06-04
Additional Articles
SQL Server Common Table Expression vs Temp Table
In this tip we look at how to use Common Table Expressions CTE in SQL Server including the syntax, use cases, using more than 1 CTE at the same time and recursive CTEs with a parameter.
2019-06-04
Date and Time Conversions Using SQL Server
There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it.
2019-06-03
Introduction to SQL Server Security — Part 6
SQL Server has many tools used to make it secure. In this article, Robert Sheldon demonstrates several of these features including SQL Server Configuration Manager and the Vulnerability Assessment tool.
2019-06-03
9 Tips for Faster SQL Server Applications
Wanna make your SQL Server applications go faster? Here are 9 simple tips that will give you a better chance for success. They’re not carved in stone, but they’re a good place to start.
2019-05-31
Set your team up for valued software delivery with Unit Testing
There is a constant pressure in software delivery to release at speed and often. However, there is no sense in delivering fast if what you deliver contains errors or is of no value to the customer. Our latest blog explains how database unit testing can set your team up for valued software delivery.
2019-05-31
SQL Server String Manipulation using Substring Function in T-SQL, R and Python
In this tip we look at how to use substring functions or similar using T-SQL, R and Python when working with SQL Server.
2019-05-31
Bloor 2019 Market Update on Test Data Management
Discover the latest market trends and assess your approach to test data management. For example, the Bloor analyst recognizes “…an increased emphasis on test data provisioning, as opposed to merely test data management.” The report also covers key capabilities offered by vendors in the market, including Redgate.
2019-05-30 (first published: 2019-05-16)
Enhance your database development by using coding standards
Establishing coding standards can help remove blockers to understanding code, improving quality and reducing maintenance. Faris Hilmi explains how having consistently formatted code plays a larger role in database development and how Redgate tools can best equip you for the task.
2019-05-30
What is Automation?
Kendra Little looks for a meaningful definition of automation as it applies to the software development process.
2019-05-30
Blogs
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Forums
SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Cannot get KB959420
Hi, we lost our sever sql2000 To restore database to a new one we...
Do You Really Need HA?
Comments posted to this topic are about the item Do You Really Need HA?
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers