The TCO of the Cloud
When is the cloud right for your databases? Steve Jones talks about some metrics and ways you can measure your usage to determine when it makes sense.
SQL Server Central Webinar Series #18 - Don’t Lose Your Data: Top Tips for Backup, Verification and Restore
Join us on May 22, 4:00GMT to learn how to include verification as a part of your backup and recovery strategy with Grant Fritchey.
Windows Azure from a Data Perspective
Before creating a data application in Windows Azure, it is important to make choices based on the type of data you have, as well as the security and the business requirements. There are a wide range of options, because Windows Azure has intrinsic data storage, completely separate from SQL Azure, that is highly available and replicated. Your data requirements are likely to dictate the type of data storage options you choose.
Continuous Releases
The idea of continuous development, integration and release can be a way to get your software in use by clients quicker. Steve Jones talks about releases, and some benefits you might get.
Instant File Initialization and restores
Instant file initialization also has its advantages when you restore a SQLServer database. This article will show you why.
SQL Server 2012 Certifications Revamped
Forget what you thought you knew about SQL Server certification, as Microsoft has completely redesigned the SQL Server 2012 certification program, making is more difficult, costly, and time-consuming to attain.
Perform Routine Server Checks Using PowerShell
Database administrators tend to perform a lot of routine checks, referred to as sanity checks, on a daily, weekly, and monthly basis. Rob Gravelle shows you how to write some PowerShell scripts to automate a couple of fairly common sanity checks.
SQL Relay 2012
This May brings SQL Server experts to your locality; full day seminars in Edinburgh, Manchester, Birmingham, Bristol and London. Overview sessions from Microsoft in the morning, Deep Dive sessions in the afternoon from SQL Server MVP's and evening community events.
Password Handling
A system administrator can set a good example with the passwords they give to users or a bad example. Which one do you set?
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
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
Eight Minutes
Comments posted to this topic are about the item Eight Minutes
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?