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 » Development » programming   (RSS)
  • Cloud Computing - just get started already!

    OK - you've been hearing about ''cloud'' (I really dislike that term, but whatever) for over two years. You've equated it with just throwing some VM's in some vendor's datacenter - which is certainly part of it, but not the whole story. There's a whole world of - wait for it - *coding* out there that you should be working on. If you're a ...
    Posted to Buck Woody (Weblog) by BuckWoody on October 30, 2012
  • 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
  • "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
  • Calvinball Projects

    I used to be a huge Calvin and Hobbes fan, and when a friend today reminded me of the old game of ''Calvinball'' I couldn't help drawing similarities to database and programming projects.   Here are the rules to Calvinball as they apply to database development projects: 1.1. All players must wear a Calvinball mask (See Calvinball Equipment ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on June 2, 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