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 2008 » SQL Server   (RSS)
Showing page 1 of 2 (17 total posts)
  • SQLSaturday #69 - Philly Love

    Thanks to the Philly SQL Server User Group (PSSUG) and to everyone who attended SQLSaturday #69 in the City of Brotherly Love yesterday. It was a great event with a lot of great people. My presentations are available for download at the links ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on March 6, 2011
  • Try-N-Save SSIS Packages

    The Try-N-Save SSIS Packages from my SSIS Dimensional Data Optimization presentation are available at http://cid-8f7e6c950afc6b3e.office.live.com/self.aspx/.Public/Presentation/TryNSave.zip. I'm still working on getting the sample database uploaded - even compressed a backup is larger than SkyDrive's upload filesize limit. I'll script it out when ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on November 29, 2010
  • High Performance Dimensional Data Loads With SSIS Presentation

    Just finished giving the SSIS High-Performance Dimensional Data Load presentation at SQLSaturday #59 NYC.  Here are the slides in PDF format.  I'll upload the Try-N-Save code and sample data later for attendees to play with. Thanks to everyone who attended my session and thanks to Melissa D. and NJSQL for putting this ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on November 20, 2010
  • T-SQL Tuesday #006: Tiger/Line Spatial Data

    This month’s T-SQL Tuesday post is about LOB data http://sqlblog.com/blogs/michael_coles/archive/2010/05/03/t-sql-tuesday-006-what-about-blob.aspx.   For this one I decided to post a sample Tiger/Line SQL database I use all the time in live demos. For those who aren't familiar with it, Tiger/Line data is a dataset published by the U.S. ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on May 11, 2010
  • 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
  • Bit-Twiddling in SQL

    Someone posted a question to the SQL Server forum the other day asking how to count runs of zero bits in an integer using SQL.  Basically the poster wanted to know how to efficiently determine the longest contiguous string of zero-bits (known as a run of bits) in any given 32-bit integer.  Here are a couple ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on April 3, 2010
  • T-SQL Tuesday #004: Why Doesn't TDE Encrypt My FILESTREAM Data?

    This post is my entry for Adam Machanic's T-SQL Tuesday #004, hosted this time by Mike Walsh. I was at the RSA Conference in San Francisco last week discussing database encryption options in SQL Server 2008 and one question seemed to keep coming up. The question concerns FILESTREAM and Transparent Data Encryption (TDE), but first a little ...
    Posted to Michael Coles: Sergeant SQL (Weblog) by Mike C on March 8, 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
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement