Script Generator
It is a modified version of original script I found on net. This script creates conditional Update statements too.
2007-07-05 (first published: 2006-10-03)
554 reads
Split Function
This is another type of split function which disects 8000 byte varchar with given delimeter and returns table with disected values.It does that with single select statement (internally looped), without using explicit while loop.Works pretty fast
2007-02-06 (first published: 2006-08-18)
388 reads
Blogs
TryHackMe Advent of Cyber
By Steve Jones
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...
You should be running on SQL Server 2022
It’s me again with my apparently semi-annual blog post. This time we’re going to...
Removing a PowerShell Array Element–#SQLNewBlogger
By Steve Jones
I saw an article on this and realized I had no idea how to...
Forums
Replication Monitoring with Always On Availability Group
Hey Folks, So I have SQL Transactional Replication set up on a database that's...
Powershell, how to convert file to txt pipe
Hello, how can I change this code to txt pipe format? $DataSet.Tables[0] | Export-csv...
Summing different fields on a group by
HI I have a data set with student info; Name, Type there would be...
Ask SSC