First off - the Pain of the Week webcast series has been renamed. It's now known as The Expert's Perspective. Please join us for future webcasts and, if you're interested in speaking, drop me a note to see if we can get you on the roster! The bigger your databases get, the longer backups take. That doesn't really seem like a huge problem — until disaster strikes and you need to restore your databases as fast as possible. Join my buddy Brent Ozar (blog | twitter), a Microsoft Certified Master of SQL Server and good friend, as he reveals ways to make these critically important … [Read more...]
New Releases in the Toad Family of Tools
June 8, 2011 by Leave a Comment
Toad Extension for Visual Studio 1.2 is now live. You can access it HERE. Key new features in Toad Extension for Visual Studio v1.2: Deployment Scripts: the pre- and post-deployment scripts of TFS are now supported. XML Columns: supports tables with XML data type columns. Nested Tables: supports tables with up to two levels of nested table type columns. Synonyms: synonyms can now be imported into your DB project Source Navigation: You can now use F12 navigation to find the definition of items in the code editor. Stored Procedures: generate Oracle stored procedures that … [Read more...]
Wednesday Quest: Toad and Policy-Based Management
June 1, 2011 by Leave a Comment
Did you know that Toad for SQL Server has some nice features for users of policy-based management (PBM)? Importing Policies For example, Toad can import policies into a PBM server, so that you don’t have to manually create them every time. You can import policies that you have exported from other servers, and you can also import the Microsoft Best Practice Policies. (Read about the concept HERE). The Microsoft policies are a great place to start learning what you can do with PBM, by simply importing them and inspecting their various configurations. They are installed by default and … [Read more...]
Pulling real-time data from Twitter using StreamInsight and Other Scandinavian Treasures
May 3, 2011 by Leave a Comment
On my recent trip to SQLBits with subsequent visits to Dublin, Cologne, and Malmo (southern Sweden), I enjoyed a chance to meet several SQL Server MVPs, including Peter Larsson and Thomas Ivarsson. Among them, I enjoyed Johan Ahlen's article on Pulling real-time data from Twitter using StreamInsight. You can Find Johan's blog here. I also enjoyed several other conversations, such as the one I had with Feodor Georgiev (blog). I particularly enjoyed Feodor's guest post on SQLAuthority.com about waits in the round-trip loop from client to server back to client available HERE. There's a … [Read more...]
Wednesday Quest: New Product Training and Documentation
March 2, 2011 by Leave a Comment
Product documentation and product training are two areas where our customers consistently press us to improve...and one we take if very seriously. Bold Claims One of my favorite tools in the Quest Software toolbox for SQL Server (and Oracle) DBAs is called Foglight Performance Analysis, or more commonly, PA. This product can do things that no other tool or amount of customized scripts can ever reproduce. I am dead serious about this claim. To find out more, navigate to www.quest.com/foglight-performance-analysis-for-sql-server and click on "Key Product Documents". You'll then be taken … [Read more...]
Wednesday Quest: On-Line Demos for Toad Data Analyst and Benchmark Factory
February 23, 2011 by Leave a Comment
If you've attended any of my public sessions about SQL Server technology, then you might remember that I extend a standing offer to provide a free, long-term license to any of several products from Quest Software, such as Toad for SQL Server (including the SQL Optimizer), Toad Data Analyst, Toad Data Modeler, and the awesome performance and scalability testing tool Benchmark Factory. If you've ever wondered about these tools and why I tout them, why don't you take a couple minutes to look at the on-line demos available at each of the preceding links? If you like what you see, drop me a … [Read more...]
