Going From Many Schemas To One Schema
A Technique to deal with moving data from multiple schemas into one table
2010-08-09
6,400 reads
Articles
TSQL Challenge 36 - Create a graph/Chart with TSQL
This challenge invites you to create a graph/chart using T-SQL
2010-08-09
3,793 reads
SQL Server restart validation checklist
Many times there is the need to restart the SQL Server services, this could be a reboot of the server after patching, service pack installation or due to some other reason. Sometimes we may face issues after the restart for example the SPN is not registered, a database is offline etc... For the solution you can use the below standard SQL Server validation checklist after you restart your SQL services.
2010-08-09
3,617 reads
Million Dollar Challenge, The Sequel
Red Gate Software is having another million dollar challenge. If you work for a small software company, or have a software product of your own, read about the challenge.
2010-08-06
4,013 reads
SQL Q&A: Shrinking, Growing and Redesigning Databases
SQL databases come in all shapes and sizes and schemas. This month, our SQL expert helps with condensing, growing and redesigning databases.
2010-08-06
4,321 reads
Vote For The PASS SQLRally Logo
Take a moment and vote on the new SQL Rally logo that will be used for the event next spring.
2010-08-06
1,762 reads
'Just Google It'
A short editorial explaining the pitfalls of using search engines as reference for DBA's.
2010-08-05
327 reads
Using T-SQL to Verify Tables Row Counts in Transactional Replication
This article will help you to use T-SQL to verify that the Subscribers have the same number of rows of replicated data as the Publisher in transactional replication
2010-08-05
11,240 reads
Migrating VLDB with Log Shipping
You just had a great weekend. You go grab your coffee and before you take a sip a manager grabs you and says, "we need your help." We need to migrate a very large database to our new data center. We need to keep the data in sync and have a short period of downtime when we cutover.
2010-08-05
3,477 reads
Creating Holidays and Special Dates
A way to save holiday records that can be created as needed into a search-able calendar table.
2010-08-04
14,377 reads
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