Scripting SQL jobs using PowerShell
Using powershell to create different sql scripts in different files.
2013-12-13 (first published: 2012-04-19)
2,944 reads
Scripts
How we can move the login which has Sysadmin role.
We are using sp_help_revlogin to make login script, but it doesn't enable the login which has sysadmin role. It is very common problem during server migration. We use the this technique to solve the issue.
2013-12-09 (first published: 2013-11-29)
1,044 reads
2013-12-06 (first published: 2011-01-31)
4,822 reads
Find all Job Relationships with SSIS Config files
Find all Job Parent/Child Relationships and related DTSConfig file locations for each step.
2013-12-05 (first published: 2011-03-02)
1,746 reads
2013-12-02 (first published: 2013-11-18)
1,750 reads
Create Mirror Alerts for All Mirrored Databases
Creates Mirror State-Change Alerts for ALL mirrored databases on a server - can save hours when setting up multiple mirrored instances
2013-11-29 (first published: 2010-11-23)
4,208 reads
2013-11-25 (first published: 2013-11-15)
2,218 reads
Split and concatenate function
Function for splitting the values in string, applying logic and concatenating back to string.
2013-11-21 (first published: 2013-11-11)
3,127 reads
Powershell script to interactively move cluster resources
Powershell code to interactively move cluster resources between nodes. Intended for Windows 2012 and SQL 2012.
2013-11-19 (first published: 2013-11-04)
2,421 reads
Search Table And Field In All Database And Return Field Value
In this script, we can search a Field and Table in all databases on the server, returning the Field value.
2013-11-15
171 reads
Blogs
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers