Code Share

SQL Server Code Examples

General Operations - Informational

Search for Text in Database ObjectsDrop All Databases in an InstanceDrop All Tables in a DatabaseGet all the Database Names in an InstanceShrink all Logfiles in a database (Updated)Shrink all Datafiles in a database (New)

General Operations - Performance

CPU UsageCheck for Blocking SessionsDB Reads/ Writes with PercentagesGet All Current Queries RunningMemory Pressure - Ring BufferWho is Consuming My TempDB?

General Operations - Security

Change all database Owners to "SA"Part I Create Stored Procedure to Drop Orphaned Users (New)Part I Execute Stored Procedure to Drop Orphaned Users with a Cursor to Filter Databases (New)

Azure Database Code Examples

Azure SQL Database - General

External Data Source Example 1Elastic Job Agent CreationElastic Job Agent AdministrationLogins and Users

Azure SQL Database - Security

Azure SQL Database - Maintenance

Page updated

Google Sites

Report abuse