THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » SQL » SQL 2008   (RSS)
Showing page 2 of 2 (18 total posts)
  • It's Official - SQLSaturday is Coming to NYC!

    New Jersey SQL Server User Group (NJSQL) is bringing SQLSaturday #39 to NYC on April 24, 2010!  The free all-day training event will be hosted by Microsoft at their Midtown Manhattan offices.  The speaker line-up is growing fast—if you'd like to present, visit the event's open call for speakers.  This is a free full-day ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on February 6, 2010
  • Encrypt it in .NET/Decrypt it on SQL Server?

    A common question on the newsgroups is ''how do you encrypt data in a .NET [or other] client application and then decrypt it on SQL Server [or vice versa]?'' I actually ran down my list of answers to someone who asked this in the newsgroups a few weeks ago. I won’t get into the details, but the answers all pretty much say the same thing -- ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on January 29, 2010
  • Parent-Child Build Scripts with SQLCMD

    On the SQL Server public programming newsgroup someone recently posted a question about an SSMS error (''Cannot parse script. 'System.OutOfMemoryException' thrown.'') I hadn’t encountered this error myself, but the workaround is to break up very large scripts (50+ MB) into smaller scripts. Adam Machanic posted a T-SQL Tuesday challenge to post a ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on January 10, 2010
  • Merry Christmas

    The script below generates the geekiest Christmas card in the world.  To see it, follow these instructions: (1) Copy and paste the script below into SQL Server Management Studio 2008(2) Execute the script(3) Look at the ''Spatial Results'' tab in SSMS Merry Christmas! -- Begin copy here SELECT ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on December 22, 2009
  • Please Vote: Windowing Enhancements in SQL Server

    Back in January 2007, SQL guru Itzik Ben-Gan posted a series of MS Connect enhancement requests concerning windowing function enhancements.  Those who have used the ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE() functions on SQL 2005 and 2008, you already know how useful they are.  They simplify code and can improve performance ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on November 19, 2009
  • Mission Accomplished: NJSQL Saturday Event

    Thanks to all those who made the NJSQL Saturday event held in Iselin, NJ today a success! Those lucky enough to attend were given a sneak preview of one of the best young presenters out there--MVP Jacob Sebastian--who will also be speaking at PASS.  I have to hand it to Jacob: he gave one of the best presentations on a SQL Server topic ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on October 24, 2009
  • NJSQL Saturday Event (10/24)

    The NJSQL user group is hosting a one-day Saturday SQL Server event at the Microsoft Iselin offices.  On October 24th Jacob Sebastian, Robert Pearl and I will be presenting on the following SQL Server topics: * T-SQL Defensive coding and exception handling best practices* Database forensics in SQL Server (''Who did it and ran?'')* SQL Server ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on October 6, 2009
  • "SQL Server MVP Deep Dives" Book Available for Early Access/Pre-Orders

    The MVP authored book, SQL Server MVP Deep Dives is now available for early access and pre-orders at http://manning.com/nielsen/.  The book is divided into 5 sections that cover everything from building a proper relational database to developing BI solutions: 1. Database Design and Architecture 2. Database Development 3. Database ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on September 16, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement