Different ways to Convert a SQL INT Value into a String Value
In this article we cover different ways to convert a SQL Server numeric value into a string value.
Four ways to elevate team efficiency and code quality
IDC have reported that ‘the shortage of full-time developers will increase from 1.4 million in 2021 to 4.0 million in 2025’. So how do teams keep pace with business demands, without relying on recruiting extra staff? Discover 4 ways that teams can elevate efficiency and code quality to speed up delivery of accurate database changes.
Stairway to Advanced T-SQL Level 7: Ordering Your Data Using Ranking Functions
In SQL Server there are 4 different ranking functions: RANK, DENSE_RANK, NTILE, and ROW_NUMBER. These ranking functions were introduced in SQL Server 2005. In this stairway level I will be reviewing each of these different ranking functions, and will show you how to use them by providing a few examples.
Azure Synapse Link for SQL: From production to a data warehouse in a few clicks
Microsoft announced Azure Synapse Link for SQL. In this article, MVP Dennes Torres explains the new feature.
Why a leading bank with over 1,400 databases chose to think again about Redgate SQL Monitor
Headquartered in Louisville, Kentucky, Republic Bank is one of the most innovative and forward-looking banks in the US, with 42 full-service banking centers across five states and assets of $6.2 billion. Find out why they chose Redgate SQL Monitor.
Using Graph Theory To Group Records
Learn a little basic graph theory in this article that replaces a GROUP BY clause.
Accelerating Digital Transformation: The role of DevOps and Data
SQL Server Central Editor, Steve Jones is joined by a panel of industry experts from around the globe to discuss their experiences with digital transformation, and the impact it had on themselves, their teams and the wider organization.
How to Import and Export Connections from SQL Server Management Studio
In this article we look at how to import and export connection information for servers in SQL Server Management Studio for backup and to move to another installation of SSMS.
Blogs
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,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers