SQL Add-On « SQL Server Journey with SQL Authority

Archive for the ‘SQL Add-On’ Category

SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer

Posted in Best Practices, Pinal Dave, SQL, SQL Add-On, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on June 25, 2010 | 6 Comments »

Microsoft has released wonderful tool SQL Server 2008 R2 Best Practices Analyzer. I have previously used this tool and found it quite helpful. Here is the latest version which you can download from MS site. Microsoft SQL Server 2008 R2 Best Practices Analyzer However, I received quite a few emails that users are not able [...]

Read Full Post »

SQL SERVER – Generate Database Script for SQL Azure

Posted in Pinal Dave, SQL, SQL Add-On, SQL Authority, SQL Azure, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on June 4, 2010 | 6 Comments »

When talking about SQL Azure the common complain I hear is that the script generated from stand-along SQL Server database is not compatible with SQL Azure. This was true for some time for sure but not any more. If you have SQL Server 2008 R2 installed you can follow the guideline below to generate script [...]

Read Full Post »

SQLAuthority News – Guest Post – Performance Counters Gathering using Powershell

Posted in SQL, SQL Add-On, SQL Authority, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology, tagged Powershell on May 30, 2010 | 1 Comment »

Laerte Junior Laerte Junior has previously helped me personally to resolve the issue with Powershell installation on my computer. He did awesome job to help. He has send this another wonderful article regarding performance counter for readers of this blog. I really liked it and I expect all of you who are Powershell geeks, you [...]

Read Full Post »

SQL SERVER – SELECT TOP Shortcut in SQL Server Management Studio (SSMS)

Posted in Pinal Dave, SQL, SQL Add-On, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on April 17, 2010 | 15 Comments »

This is tool is pretty old, yet always comes as a handy tip. I had a great trip at TechEd in India. And, during one of my presentations, I was asked if there are any shortcuts to SELECT only TOP 100 records from SSMS. I immediately told him that if he explores the table in [...]

Read Full Post »

SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database

Posted in Database, Pinal Dave, SQL, SQL Add-On, SQL Authority, SQL Backup and Restore, SQL Data Storage, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, SQLAuthority News, T SQL, Technology, tagged Idera on April 6, 2010 | 9 Comments »

I recently downloaded Idera’s SQL virtual database, and tested it. There are a few things about this tool which caught my attention. My Scenario It is quite common in real life that sometimes observing or retrieving older data is necessary; however, it had changed as time passed by. The full database backup was 40 GB [...]

Read Full Post »

Older Posts »