Convert int to Excel column name
This script converts a numeric column index to an Excel column name (ex: AC)
2013-11-07 (first published: 2013-10-23)
1,808 reads
Peter Diplaros
Generate consecutive numbers
TSQL code that generates numbers (tally table) from 1 to N without using any tables
2012-03-01 (first published: 2012-02-21)
1,767 reads
Blogs
Daily Coping 27 Jan 2023
By Steve Jones
Today’s coping tip is to try something new to get out of your comfort...
Things to look out for while TDE is encrypting existing data
Monitoring for Problems The encryption of your existing data occurs as a background process...
Daily Coping 26 Jan 2023
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Forums
Context_Info across databases
I have a stored procedure that works across databases. So the "integration" database will...
Interview Question
Hi Team , Today i had an interview call. there was a question asked...
AG failover databases go into Initializing / in recovery
We did a failover of an AG and two databases went into Initializing /...
Ask SSC