2008-02-14 (first published: 2007-12-20)
1,045 reads
Scripts
2008-02-13 (first published: 2007-12-18)
1,760 reads
Change column type on constrained columns
Use this proc if you need to alter a column that is part of a primery key
2008-02-04 (first published: 2007-12-10)
1,128 reads
String Tokenizer with Complex Search
Sample solution to replace string in expressions with multiple delimiters.
2008-01-31 (first published: 2007-12-05)
2,008 reads
2008-01-29 (first published: 2007-11-23)
1,984 reads
2008-01-28 (first published: 2007-12-03)
1,712 reads
Server Login/Role And DB User/Role Script
This script will produce the server login/role and db user/role in all databases in the server.It is best advised that you first delete/recreate orphaned users for best results
2008-01-25 (first published: 2007-11-27)
3,810 reads
2008-01-24
1,244 reads
Locate specific columns used in procs
SP to find object and line number that references column(s) of interest.
2008-01-24 (first published: 2007-11-21)
1,034 reads
Check Availability Window - SQL2k
This script allows you to check the several availability windows for the current day.
2008-01-18 (first published: 2007-10-29)
1,109 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers