The New Reality of an Audit Trail
With a continuation of his last article on auditing, Leo Peysakhovich enhances his solution to capture more details using XML.
Administering Securely
A common request is how can you secure SQL Server data and prevent the system administrator from viewing data. Steve Jones talks a little about the issue and how you can handle it.
Administering Securely
A common request is how can you secure SQL Server data and prevent the system administrator from viewing data. Steve Jones talks a little about the issue and how you can handle it.
Administering Securely
A common request is how can you secure SQL Server data and prevent the system administrator from viewing data. Steve Jones talks a little about the issue and how you can handle it.
Automating Performance Monitor Statistics Collection for SQL Server and Windows
You have about 100 SQL Servers installed in your production environment. You have performance problems on few of the servers, but they happen during the time when you are not watching the servers. So, how can you automate performance statistics collection on all the servers around the clock so we have the statistics for 24/7/365.
I need a logo
I've been doing the Voice of the DBA podcasts for over a year now, and I really enjoy them. I've heard from many of you that you like them as well, so ...
Monitoring group of Linked Sql Servers from a Sql Server
The main purpose of article is to understand how to monitor group of Linked Sql Servers from a Sql Server.
Querying the Procedural Cache on Canada Day (July 1st)
The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources and that queries run better. Better means higher throughput, more concurrency and fewer resources – as described by MVP Joe Webb during SQLTeach in Vancouver just last month.
Instead of Trigger, Part 1 - SQL School Video
If you have never used an instead of trigger, it's a great mechanism for evading table triggers in certain situations. MVP Andy Warren brings you part one of this SQL School video.
Music for DBAs
Tony Davis explains his theory on why developers and DBAs listen to very different types of music, while working, and offers his list of "classic tracks" for all DBAs.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA Multifinance Cabang Kedoya Hub.0851•8812•0691
BCA Multifinance Cabang Kedoya Hub.0851•8812•0691 Citta Graha, Jl. Panjang, RT.5/RW.1, South Kedoya, Kebonjeruk, West...
BCA Finance Kelapa Gading Layanan Mobil Hub.0851•8812•0691
BCA Finance Kelapa Gading Layanan Mobil Hub.0851•8812•0691 Ruko Mall Of Indonesia Blok B 32-33,...
BCA Finance - Depok Hub.0851•8812•0691
BCA Finance - Depok Hub.0851•8812•0691 Komplek Perkantoran, Ruko Pesona View, Jl. Pesona Khayangan Jl....
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers