Stairway to ScriptDOM Level 1 - An Introduction to ScriptDOM
Get an introduction to the Stairway Series and learn about the power of the ScriptDOM library.
2022-05-11 (first published: 2022-03-09)
2,374 reads
Mala Mahadevan
Stairway to ScriptDOM Level 2 - Parsing, Tokens, and the Abstract Syntax Tree
In this level of the Stairway to ScriptDOM, we examine the way the tool parses scripts and creates tokens from the text.
2022-05-11 (first published: 2022-04-13)
1,139 reads
T-SQL Tuesday 150: My first technical job
I am glad to be contributing to the 150th blog party started by Adam Machanic and has helped so many get our blogs going. This month’s T-SQL Tuesday is...
2022-05-11 (first published: 2022-05-10)
32 reads
T-SQL Tuesday 148: Finding and keeping a consistent audience, and what works
This months’ T-SQL Tuesday blog party is hosted by Rie Merrit (t|b) as part of Azure Community Group lead. Her call is to pick one or two things that...
2022-03-18 (first published: 2022-03-08)
166 reads
Thrilled to #BITS!
2021 was a strange year…mid way through a pandemic, enormously depressing on many fronts to me..and yet, it bought with it some unexpected joys. I never imagined, in the...
2022-02-09
11 reads
Introducing ScriptDOM
I’ve been meaning to get a series of blog posts started on this topic. A twitter conversation from yesterday finally pushed me to it. Last year, I was tasked...
2022-02-04 (first published: 2022-01-24)
321 reads
Parsing scripts with ScriptDOM
In the last post I wrote about what ScriptDOM is and why it is useful. From this post, I will explain how it can be put to use. What...
2022-01-28 (first published: 2022-01-27)
50 reads
T-SQL Tuesday 146: Where should business logic reside?
I am trying to get started on blogging again this year…T-SQL Tuesday came in handy with a great topic. This month’s host is Andy Yun(t |b). Andy’s challenge for...
2022-01-21 (first published: 2022-01-11)
491 reads
TSQL-Tuesday 143: Short Code Examples
I decided to resume tech blogging after a long break and this tsql-tuesday came in handy. This month’s blog part is hosted by John McCormack (B|T). He would like...
2021-11-05 (first published: 2021-10-13)
558 reads
Formatting T-SQL Scripts using ScriptDOM and PowerShell
Well-formatted scripts are always easier to maintain and enhance readability to high degree. Formatting standards are an important part of coding standards anywhere and if not, they need to be. If there are a large number of scripts this can add up to a significant amount of time needed to maintain them. It is also […]
2021-08-27
5,443 reads
Blogs
Daily Coping 20 May 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 19 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Running dynamic SQL in a different database
This is one of those things that on hindsight was a stupid problem, but...
Forums
Recover SQL Server 2012 from file backups
In a ransomware disaster recovery situation, we have a physical server that we are...
Running Trace - Error: Login timeout expired
Hi All, We have Project server 2019 (Sharepoint). The database server (Only Database services...
query perf issue
Hi Everyone, Good morning. I am new to Sql administration.Have one question. We work...
Ask SSC