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,433 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,640 reads


Migrating from EverNote to Joplin


Recently I got a message that my Evernote subscription was going up. It’s been...

Using Data Masker on Chinese Surnames


A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft


looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Read the latest Blogs


How can I show the last opening period for each project in my project dimension

By casagrandi

I have two attributes hierarchies in my dimension [Dim Project]: Project Code Opening date...

Upgrading from 2016 to 2019 with Encryption

By Richard Warr

Hi, I have a few AWS EC2 instances currently running SQL Server 2016. I'd...

NOT LIKE Alternatives in WHERE clause


Hello, I need help to improve an existing (hence I cannot change table's structure...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers