Using the ScriptDom without losing comments
The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate...
2015-11-24
55 reads
Ed Elliott's Sql Developer Blog
Using the ScriptDom without losing comments
The ScriptDom is cool, it lets you parse T-SQL, play around with the AST (tree of statements) and then generate T-SQL again (probably in a different format etc). This...
2015-11-24
27 reads
SSDT DevPack - Highlight expensive queries
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-27 (first published: 2015-11-22)
1,728 reads
SSDT DevPack - Highlight expensive queries
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-22
78 reads
SSDT DevPack - Highlight expensive queries
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-22
28 reads
SSDT DevPack - Highlight expensive queries
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially...
2015-11-22
18 reads
SSDT DevPack - Highlight expensive queries
When developing stored procedures in SSDT it is important to know when you have written a query that is potentially slow or has a high IO or CPU cost...
2015-11-22
8 reads
Create stub tSQLt tests in SSDT from stored procedures
I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and...
2015-11-23 (first published: 2015-11-17)
2,223 reads
Create stub tSQLt tests in SSDT from stored procedures
I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and...
2015-11-17
34 reads
Create stub tSQLt tests in SSDT from stored procedures
I have released another tool as part of the ssdt dev pack, what this does is create tSQLt classes and...
2015-11-17
31 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Database Mail Configuration
Comments posted to this topic are about the item Database Mail Configuration
Learn From History
Comments posted to this topic are about the item Learn From History
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers