2008-08-27 (first published: 2008-07-03)
2,189 reads
Scripts
sp_import_errorlog
To import the SQL Server error log into a table, so that it can be queried
Written by: Anand Mahendra Tested on: SQL Server 2000
2008-08-21 (first published: 2008-06-30)
784 reads
2008-08-20 (first published: 2008-06-19)
1,132 reads
2008-08-18 (first published: 2008-06-25)
1,745 reads
Case Cleanup Function
Capitalize the first letter of each new word in the string (clean, efficient, and easy to modify).
2008-08-14
337 reads
ChangeDateTpFirstOfNextMonth
Nothing fancy; just allows you to change a date the the first of the following month. Friend needed this so I thought I would post it here for other newbies.
2008-08-14 (first published: 2008-06-20)
553 reads
2008-08-13 (first published: 2008-06-17)
1,094 reads
How to get list of Stored Procedure
You can use following stored procedure with four optional input parameters to get a list of all stored procedures in the current environment.
2008-08-11
1,076 reads
2008-08-11 (first published: 2008-06-17)
889 reads
Find the port no Get Port SQL Server 2000
This Query is used to Find the port number or Get Port mumber SQL Server 2000 using T-SQL
2008-08-09
1,064 reads
Blogs
Microsoft Purview data governance best practices
By James Serra
Microsoft Purview can be the best data governance tool in the world, but it...
AI and Data Engineering on the Edge: The Good, the Bad, and the Overhyped
Running AI and data pipelines on the edge instead of the cloud has gone...
UNION vs UNIONALL: #SQLNewBlogger
By Steve Jones
While writing another post I realized my UNION query didn’t work as one might...
Forums
Replacing Maintenance tasks now using SSMS 22 - what to do with File operations
Unfortunately I'm using SSMS 22. It didn't come with maintenance plans by default. I...
Secure Cached Plans
Comments posted to this topic are about the item Secure Cached Plans
Complex Data Processing with dbt Python Models: The Fabric Modern Data Platform
Comments posted to this topic are about the item Complex Data Processing with dbt...
Question of the Day
Secure Cached Plans
The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?
See possible answers