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-10-13
17 reads
Mala Mahadevan
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
4,422 reads
Crocs and Naps….
I was planning a blog post for a TSQL2sday..instead would up writing an obituary blog post for a dear friend who passed on yesterday. Brian Moran was among the...
2021-07-23 (first published: 2021-07-10)
291 reads
Scripting using SMO
I will be delivering a lightning talk at DataMinutes on June 7th on this topic. I thought it would help to write a synopsis of what am going to...
2021-06-06
26 reads
Data dictionary script
I restarted speaking with New Stars of Data today – I gave a talk on Database documentation. Below is the script I created to pull metadata into an excel...
2021-03-16 (first published: 2021-03-12)
645 reads
Old but not gone…
I am part of a weekly talk show we run at the TriPASS user group, called ‘Shop Talk’. Shop Talk was the brainchild of Kevin Feasel, our key user...
2021-02-25 (first published: 2021-02-22)
354 reads
TSQL Tuesday #134 – Taking a break
This month’s TSQL Tuesday invite is from James McGillivray – he asks people to write about what they were/are doing to take a break during this crisis ridden time...
2021-01-12
7 reads
End of an Era – SQL PASS and Lessons learned
Most of my blog is filled with posts related to PASS in some way. Events, various volunteering opportunities, keynote blogging, this or that…With the demise of the organization, I...
2020-12-31 (first published: 2020-12-22)
479 reads
PASS Summit 2020 – My experience
This was the first year in 16 years for me that there has been a fall season without the PASS Summit to go to. Every year, during the fall,...
2020-11-25 (first published: 2020-11-15)
206 reads
T-SQL Tuesday 132: Coping with a pandemic
This month’s T-SQL Tuesday is hosted by my good friend and data platform MVP Taiob Ali. Taiob’s challenge is very relevant to current season – he asks to blog...
2020-11-10
3 reads
Blogs
What’s my MAC Address in a Command Prompt?–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
You don’t need a blockchain
After writing several posts about a neat feature in Azure SQL called system-versioned ledger...
Daily Coping 27 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Error connecting using AlwaysON Listener
Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I...
How to get feature key and feature value separated $ based on part id ?
I work on sql server 2012 i need to get featurekey and feature value...
Setting Up SQL Server 2019 for Optimal Performance
Hi I have a very large database (600GB) that I am looking at creating. ...
Ask SSC