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 » development   (RSS)
  • 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
  • "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
  • "Cloning" Symmetric Keys

    It's well-known by now that SQL Server 2005 and 2008 include new encryption-related statements that allow you to create and administer encryption keys. You can use CREATE CERTIFICATE to create or import a certificate or DROP ASYMMETRIC KEY to remove an asymmetric key from the database, for instance.  One of the interesting ommissions ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on June 17, 2009
  • Presenting in Louisville; Meeting in Cincinnati

    I'll be presenting ''New SQL Server 2008 Features'' in downtown Louisville, KY on June 22, in conjunction with the Louisville SQL Server Users Group thanks to group leader Malathi Mahadevan.  We'll be giving away some SQL 2008 books and other goodies.  I'll post further details (exact time and location) shortly. Update:  The ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on June 1, 2009
  • Practical SQL Server XML: Part 2

    In response to a challenge from Pinal Dave, a fellow MVP and a winner of an award for his blog at the MVP Summit 2009, I am writing a couple of articles to demonstrate practical uses for SQL Server’s XML capabilities.  (Dave’s great blog is at http://blog.sqlauthority.com/). Dave posted the first post in this series over at ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on March 3, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement