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,608 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,800 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,256 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,292 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,509 reads
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Comments posted to this topic are about the item Dancing Robot Goes Rogue
Hi , i installed winscp on my pc, added it to GAC thru vs...
Comments posted to this topic are about the item Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers