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 Server » SQL » sql 2005 » SQL 2008   (RSS)
  • Find a Hash Collision, Win $100

    Margarity Kerns recently published a very nice article at SQL Server Central on using hash functions to detect changes in rows during the data warehouse load ETL process.  On the discussion page for the article I noticed a lot of the same old arguments against using hash functions to detect change.  After having this same discussion ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on April 17, 2010
  • T-SQL Tuesday #005: Creating SSMS Custom Reports

    This is my contribution to the T-SQL Tuesday blog party, started by Adam Machanic and  hosted this month by Aaron Nelson.  Aaron announced this month's topic is ''reporting'' so I figured I'd throw a blog up on a reporting topic I've been interested in for a while -- namely creating custom reports in SSMS. Creating SSMS custom ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on April 12, 2010
  • Calculating Holidays in SQL

    Ask about nearly any kind of SQL-based date calculation in the newsgroups, and you'll likely get responses that include use of an auxiliary calendar table.  It's a really good idea, and something I highly recommend to anyone who has to do date-based calculations on the server.  For those who do dimensional modeling, you'll probably ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on February 25, 2010
  • Service Packs... Coming to a Download Near You!

    Based on feedback from the community (https://connect.microsoft.com/SQLServer/feedback/details/522123/sql-server-2008-service-pack-2 and https://connect.microsoft.com/SQLServer/feedback/details/522122/service-pack-4-for-sql-server-2005), Microsoft has announced plans to release Service Pack 2 for SQL Server 2008 and Service Pack 4 for SQL ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on February 14, 2010
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement