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,391 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,720 reads
Blogs
Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2
By Rayis Imayev
(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...
Extended Events Misperceptions: Profiler is Easier, Part 2
I wrote a short blog post about the misperception that Profiler was easier than...
CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))
If you read the title to this post and your first thought was That’s...
Forums
Fastest way to load a CSV file in SQL Server Table
What is the fastest way to load a file in SQL Server Table ?...
Replication question
Im an Oracle DBA by trade and been tasked with setting up transaction replication...
Software to send Report
Hi Experts, Currently we are using SQL Server and Database Mail to send reports...
Ask SSC