Featured Article(s) Troubleshooting SQL Server 2008 performance counters problems In this article, Alexander Chigrik explains some problems that you can have with SQL Server 2008 performance counters. He also tells how you can resolve these problems.SQL Server 2012 Release – Beginning to Understand the Changes SQL Server 2012 brings a while series of changes to the platform, from more crystalized […]

SSWUGtv: Special Edition Leon Guzenda from Objectivity DB joins us to talk about Big Data, some real applications for it and the history behind this kind of massive data procession. Really interesting applications of this technology. [Watch the Show] Featured Article(s) SQL Compliance Review Do you work in the Healthcare industry? Do you work in the Banking industry? Do you […]

Starts tomorrow – register ASAP: Denny Cherry is Back – Storage and Virtualization Online Course Denny explains why storage can be one of the largest bottlenecks when it comes to database performance. It’s also one of the hardest to troubleshoot because storage engineers and database administrators often do not get along. He’ll dig into LUNs, HBAs, the fabric, as well […]

Potpourri I have a lot of comments from readers on different topics that have been accumulating. So, today I’m going to catch up on some of the backlog. Marty reminds us that there is a need for people who can get software to work together…something that becomes more critical as underlying tools for valuable assets are deprecated. Not only am […]

Immutable Objects I came across a Java question a couple days ago asking how to substitute the values from a to b, and b to a, without using a third temporary variable. In short, how to transfer the contents without doing something like C=A A=B B=C How could you do this without using a third variable? The question had a […]

Top 10 Tips for Optimizing SQL Server Performance SQL Server performance management requires serious time and energy. In this new white paper by Kevin Kline, discover detailed guidance on the issues you can relate to—from cache trashing to bad T-SQL that can return to haunt your applications. See how to maximize database scalability and efficiency with ease. Read More Backups […]

Resources for Learning SQL Server In this edition of the SSWUG newsletter I respond to a question from Tim regarding learning resources. Tim writes: I’m enjoying your newsletter. I’ve been an oracle DBA for over 10 years and am just now being introduced to the SQL Server world. Your newsletter is a huge help in my transition. You sign off […]

Accidental DBA Tip – Manage Transaction Logs Transaction logs are a key utility for managing the recovery and performance of your database. In most engines, a transaction log maintains a copy of the data being written to your database to assure the integrity of the data. If you want to do more research about what I mean about the Integrity […]