Clear all user objects
This procedure will drop (with care) all user-defined objects: constraints, procedures, functions, triggers, views and tables. Used for re-creating database schema without drop and create database.
2003-04-07
98 reads
Enhanced sp_password
This is a sp_password enhanced by Dmitri Bobkov (see http://www.sqlservercentral.com/scripts/contributions/718.asp) and re-enhanced with a small changes from SQL2kSP3.For SQL Server in Mixed Authentication mode this stored procedure helps to validate users password. Currently this procedure checks for the next requrements: password must have length at least 8 characters plus among them at least one digit […]
2003-03-27
440 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