Additional Articles


Technical Article

Use of regular expressions in TSQL

This script creates 2 new system functions :fn__testregexp(@String,@Pattern) returns int    execute the method test(@String) on the regular expressions @Pattern    returns :        0 : no match        1 : match        null : one of the parameters was null        anything else : error from sp_OA procedure        fn__replaceregexp(String,@Pattern,@Replace) returns varchar    execute the method Replace(@String,@Replace) […]

5 (2)

2007-06-14 (first published: )

1,901 reads

Technical Article

SP_WHO_3 Powerful Filtering/Sorting Very Efficient

Hello,I posted this a while ago to several web sites. Someone found an obscure bug in it and I fixed it (newest script attached below). When I posted it to you last time, it didn't show up in any of the categories that I had checked; hmmmm? However, when I searched google, you have it […]

5 (2)

2007-06-13 (first published: )

1,787 reads

Technical Article

ActiveX - Clean Up Unused Connections

This ActiveX Script runs in DTS Designer and will clean up all unused connection objects. This allows you to rename connections at will by selecting "New Connection" and typing a new name. It also allows you to copy and paste connections then rename them. Then you can cleanup leftover connections when development is complete.

2007-06-12 (first published: )

461 reads

Technical Article

Distribution of Enterprise Manager registrations

This was just an answer in a forum in September, but I keep getting requests for the script. So I am sharing it here for anyone that could be interested: Problem: large amount of registered servers, multiple DBA's needing updated registration info, DBA workstations added or rebuilt, many servers added at once. In cases like […]

5 (1)

2007-06-05 (first published: )

894 reads

Technical Article

Script to perform http(s) post

Post data as coming from an HTML FORM with METHOD=POST to an URL and retrieve the result. The script uses the WinHttp.WinHttpRequest.5.1 object.Call like :exec dbo.usp_httppost 'http://www.sqlservercentral.com/search/turbo.asp','searchstring=ftp&btnG= Go &cArticles=on&cForums=on&cScripts=on&sitesearch=http://www.sqlservercentral.com'

5 (1)

2007-05-30 (first published: )

1,717 reads

Technical Article

how to start a program like Notepad.exe in a job

sometime I need to kill an program which does not continue to process data, and i sheduled a job to do that. After lots of times' try, I made it at last.This script add a shedule to the sheduled task list, one minutes later then the current system time. You can change it by edit […]

4 (1)

2007-02-28 (first published: )

213 reads

Blogs

SQL Saturday Jacksonville Slide Decks

By

Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous...

Power BI connectors to Azure Synapse

By

When using Power BI and pulling data from Azure Synapse, you will use the...

Snowflake + Azure Privatelink

By

Azure Privatelink provides private connectivity from an Azure Virtual Network to Azure PaaS such...

Read the latest Blogs

Forums

Filetred index

By aureliu

\hello Guys,   Mayyou help wuth the corect index filetred creation using modulo?  ...

Monitor SQL Server Job Failures

By ktflash

Ahoi, i am usually working with SSIS and SSAS, but since there is no...

DateDiff - Data Type conversion Issues

By protocoder

Hi Experts Not able to do DATEDIFF between two dates, but it works when...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers