GitHub

SqlServer: get stored procedure body

I set all the variables to get the stored procedure body and I can't get the body. I noticed the sqlserver jdbc driver returns the procedure name ending with ";1" and the query in ROUTINES.sql does ...
GitHub

SQL Server project that implements automatic database backup using a database trigger, stored procedure, and SQL Agent job scheduling.

There was an error while loading. Please reload this page. -- Auto Backup for SQL Server - Fixed Version -- Replace MyDB with your database name and ensure C:\DB ...
Microsoft

Check AOS event logs and SQL Server error logs for key messages using DynamicsPerf

In the second blog post above, you’ll see there is a SQL Server Agent job ‘DYNPERF_COLLECT_AOS_CONFIG’, which collects the last 14 days of Windows event logs from each of the AOS servers, in addition ...
Microsoft

Improve scalability with system page latch concurrency enhancements in SQL Server 2022

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...