I had the pleasure of meeting Mr. Cephas Lin, of Microsoft, last year at the SQL Saturday in Indianapolis and then later at the PASS Summit in the fall. Cephas has been writing content for SQL Server 2012 Always On. Cephas has recently published his first whitepaper, a migration guide to SQL Server AlwaysOn. Read it and then pass along any feedback: HERE Enjoy, -Kev -Follow me on Twitter! … [Read more...]
New Toad for SQL Server Beta
A new beta build of Toad for SQL Server (v5.7.0.527) is available at: http://toadforsqlserver.com/beta.jspa It's free and, afaik, doesn't have a short expiration date. It contains popular features such as compare & sync (for database schemas, servers, and data), a full transaction log reader and DML undo feature, debugger, intellisense, auto-complete, code formatter, and a lot more. Check it out! (There's also a version of Toad for Cloud Databases, which gives you SQL-like capabilities against a bunch of NoSQL databases). This drop contains a couple of fixes in the areas: Database … [Read more...]
New White Paper: SQL Server Extended Events and Notifications
Download the new white paper: How to Use SQL Server’s Extended Events and Notifications to Proactively Resolve Performance Issues SQL Server comes with a wide array of tools for monitoring your environment. There are logs and traces that provide information when errors occur, but these are often used passively to react to events that have already occurred. There's PerfMon, and Profiler, and loads of Dynamic Management Views to check. But where to look? As database administrators (DBA), we need to monitor our environments proactively and create solutions as issues arise. In this white … [Read more...]