S. Srivathsani


SQLServerCentral Article

Dynamic Management Views and Functions in SQL Server 2005

DBAs have always been warned against using system tables in their code, but often there has been no other way to get information about the server. In SQL Server 2004, Dynamic Management Views have been provided that give you insight into almost every aspect of SQL Server. S. Srivathsani brings us a look at some of the DMVs and functions you can use.

4.54 (13)

You rated this post out of 5. Change rating

2008-03-18 (first published: )

17,557 reads

SQLServerCentral Article

Understanding DDL Triggers in SQL Server 2005

SQL Server 2005 includes a number of new security enhancements to aid the DBA in managing their SQL Server. DDL triggers allow you to trap all kinds of DDL events that occur on your server. S. Srivathsani brings us a look at these new events.

4.45 (11)

You rated this post out of 5. Change rating

2008-03-17 (first published: )

15,758 reads

Blogs

Migrating from Azure PG Single Server to Flex with Azure VM and pg_dump/restore

By

This is more complicated than using the Azure Migration method, but because it’s maxed...

PowerShell (and T-SQL) and Elastic Jobs

By

I’ve covered how to create Elastic Jobs in the portal (this one is important...

A New Word: Redesis

By

redesis – n. a feeling of queasiness while offering someone advice, knowing they might...

Read the latest Blogs

Forums

Extended Event Comfort

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Extended Event Comfort

SQL Database Project in Azure Data Studio

By Daniel Calbimonte

Comments posted to this topic are about the item SQL Database Project in Azure...

AG Rules for Databases

By Steve Jones - SSC Editor

Comments posted to this topic are about the item AG Rules for Databases

Visit the forum

Question of the Day

AG Rules for Databases

Which of these is not a requirement for a database to be added to an Availability Group (AG)?

See possible answers