Total Database Information At Your Fingertips Part I
This article will help to get some basic information from your databases that may help you in different situations.
A Red Gate Meetup in San Francisco
Join Neil Davidson, Joint CEO of Red Gate Software, for a meetup in San Francisco on Aug 25th. Come talk software, databases, and development with other like-minded people.
Using PowerShell to Manage SQL Server
The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell’s flexibility by creating a set of commands customized to our needs.
Back to Basics
This week Steve Jones reminds us that the basic skills we may take for granted might need some refreshing or updating.
Configuring Database Mail with Powershell and SMO
Use Powershell and SMO to quickly and easily enable and configure database mail in nine steps.
Keeping Your Soul
How much do you need to sacrifice to succeed in business? It might be a lot, but Steve Jones says a lot of financial success is not worth losing your soul over.
SQL Server 2008 and 2008 R2 Integration Services - Analysis Services Processing Task
The primary purpose of SQL Server 2008 Integration Services is to deliver extraction, transformation, and loading (ETL) functionality that supports core features of the SQL Server database management system. However, there are numerous scenarios where its role involves interaction with components that provide business intelligence-related features incorporated into the product.
Creating a 2 Node SQL Server 2008 Virtual Cluster Part 3
This article continues the series on how to create a 2 node Windows\SQL Server 2008 cluster with a look at slipstreaming the service pack and cumulative updates needed.
Tricky Questions
This Friday Steve Jones is looking for help with interview questions. What questions have been hard in an interview or surprised you? Let us know and help others be prepared for their next interview.
Simple Script to Backup All SQL Server Databases
Sometimes things that seem complicated are much easier then you think and this is the power of using T-SQL to take care of repetitive tasks. One of these tasks may be the need to backup all databases on your server.
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?