Nil to Speaker: Improving your PowerPoint skills
As I work on my speaking skills one of my tasks is improve my PowerPoint presentations. To that end I’ve...
2016-09-26
601 reads
Kenneth Fisher
Using an ORDER BY in a view
For many years it’s been a best practice to never put an ORDER BY in a view. The idea is...
2016-09-26 (first published: 2016-09-19)
3,626 reads
Emojis in SQL Server
I blame Aaron Bertrand (b/t) and Kevin Kline (b/t). Aaron who posted a great #BackToBasics blog about naming stored procedures...
2016-09-15
1,305 reads
Azure: Creating a BACPAC from an On-Premises SQL Server Database
So to start, what’s a BACPAC?
Per the Azure documentation
When you need to create an archive of an Azure SQL database,...
2016-09-13
1,095 reads
SA Spoof
This is nothing new but it’s still a fun idea.
The problem:
The vendor app we just purchased (and are told we...
2016-09-08
476 reads
Accidental DBAs, the Developer Edition
I recently spoke at the OKC SQL Saturday. I had an wonderful time and the organizers, volunteers and other speakers...
2016-09-06
392 reads
Copying an on-premise Database to an Azure SQL Database
Continuing my exploration of Azure the next logical step seemed to be copying an on-premise database up to the cloud....
2016-09-06 (first published: 2016-08-24)
1,833 reads
The new Data Migration Assistant has been released!
Monday Bob Ward (b/t) announced on twitter that the new Data Migration Assistant had been released.
First things first the DMA...
2016-08-31
980 reads
Natural vs Artificial Primary Keys
There has been a long standing debate over the use of a natural primary key vs an artificial one. I...
2016-08-29
1,227 reads
RBAR vs Batch
Many years ago Jeff Moden (of SQL Server Central fame) came up with the concept of RBAR. Row-By-Agonizing-Row. At it’s...
2016-08-25 (first published: 2016-08-17)
2,714 reads
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?