Find weak login passwords in your server
Use this script to search for SQL Server logins who use weak password
2010-01-05 (first published: 2009-12-16)
4,214 reads
Th Tr
2009-12-23 (first published: 2009-11-26)
575 reads
Synchronize several stored procedure between two servers
Synchronize source code between two servers for multiple stored procedures
2009-12-21 (first published: 2009-11-26)
2,098 reads
2009-12-18 (first published: 2009-11-26)
574 reads
Synchronize all stored procedures between two servers
This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.
2009-12-15 (first published: 2009-11-26)
2,168 reads
Synchronize a stored procedure between two servers
Use this stored procedure to synchronize source code of a stored procedure between two servers.
2009-12-11 (first published: 2009-11-26)
1,880 reads
Blogs
Executing One Line in VSCode–#SQLNewBlogger
By Steve Jones
I wrote about arrays in PowerShell last week, but I realized one of the...
Friday Flyway Tips–Comparison Options
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
A New Word: Guiltwrights
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
Forums
Lake Database Performance Optimization
I recently created a synapse link for Dataverse. The resultant Lake Database in Synapse...
Selecting from a view, base table has a DENY on a column
This is something I've never seen before and I can't think of the right...
JSON data with Pivoted
Hi All, I need some assistance and not sure how to achieve the expected...
Ask SSC