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.
2008-03-18 (first published: 2007-04-23)
17,433 reads
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.
2008-03-17 (first published: 2007-07-04)
15,640 reads
Have you ever wanted to read your transaction log? Wonder what information is inside there? New author S. Srivathsani takes a look at one of the log tools out on the market, Lumigent's Log Explorer.
2008-02-05 (first published: 2007-03-06)
6,135 reads
In another look at log tools, author S. Srivathsani looks at SQL Log Rescue from Red Gate Software. Read on about how to setup this tool in your environment and use it for a peek inside your transaction log.
2007-03-07
4,094 reads
Reading the transaction log is challenging and one of the tools that enables you go get insight is ApexSQL Log. New author S. Srivathsani takes a look at this tool and how it worked in one environment.
2007-03-05
3,398 reads
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
I have two attributes hierarchies in my dimension [Dim Project]: Project Code Opening date...
Hi, I have a few AWS EC2 instances currently running SQL Server 2016. I'd...
Hello, I need help to improve an existing (hence I cannot change table's structure...
Ask SSC