THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2008 » Tips and Tricks   (RSS)
  • Server level permissions for developers–why you should read books

    It is quite difficult recently for me to find some time to write a new post, so I don’t seem to be leading the rankings of the most frequent bloggers. I rarely recently have opportunity to lay my hands on the code too, so natural sources of ‘inspiration’ are less often. Hopefully this will change in 2012 and I will have more opportunities to write ...
    Posted to Piotr Rodak (Weblog) by on January 1, 2012
  • Uninstalling Reporting Server 2008 on Windows Server 2008

    Ha. I had quite disputable pleasure of installing and reinstalling and reinstalling and reinstalling – I think about 5 times before it worked – Reporting Server 2008 on Windows Server with the same year number in name. During my struggle I came across an error which seems to be not quite unfamiliar to some more unfortunate developers and admins ...
    Posted to Piotr Rodak (Weblog) by on December 22, 2010
  • SSMS Tips and Tricks: Scripting Inserts

    Sometimes you need to be able to script the loading of a table. SSIS and the Import/Export Wizard can do this, but there are times when you really need a complete set of insert statements. Red Gate’s SQL Data Compare or SQL Packager can do this, but not everybody has the budget for a commercial tool. SQL Server Management Studio 2008 can script ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on October 13, 2009
  • SQL Server 2008 Management Studio tip: Status Bar Custom Colors

    Joni Moilanen has a very nice tip about how you can use custom colors in the status bar so that you don't truncate that production table yet again :-) Check it out here:
    Posted to Denis Gobo (Weblog) by Denis Gobo on August 13, 2008
  • Increase Your Productivity With Query Analyzer/SQL Server Management Studio

    Drag And Drop Column Names In Query Analyzer you can save a lot of time by using this trick instead of typing all the column names of a table Hit F8, this will open Object Browser Navigate to DatabaseName/TableName/Columns Click on the column folder and drag the column folder into the Code Window Upon release you will see that all the column names ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on September 24, 2007
Privacy Statement