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 2008 » SQL Server   (RSS)
Showing page 1 of 2 (14 total posts)
  • SSIS Design Patterns, the Book

    For the past two years, I have had the honor and privilege or authoring SSIS Design Patterns alongside Jessica Moss, Michelle Ufford, Tim Mitchell, and Matt Masson. Publication of the book – like many projects of this scope – has been delayed. The current publication date is 27 Aug 2012 and I have high confidence in this date. I take ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 6, 2012
  • SQL Server Configuration timeouts - and a workaround [SSIS]

    Ever since I started writing SSIS packages back in 2004 I have opted to store configurations in .dtsConfig (.i.e. XML) files rather than in a SQL Server table (aka SQL Server Configurations) however recently I inherited some packages that used SQL Server Configurations and thus had to immerse myself in their murky little world. To all the people ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 30, 2011
  • SQLUniversity Professional Development Week: Learning To Fly

    Introduction Clem and Jim Bob were out hunting the other day in the woods south of Farmville. As they crossed a ridge, they came upon a big ol' Momma Bear and her cub. The larger bear immediately started towards them. Jim Bob took off running as fast as he could. He stopped when he realized Clem wasn't with him. And when he saw Clem reaching ...
    Posted to Andy Leonard (Weblog) by andyleonard on February 25, 2011
  • "Only SSRS 2005 reports can be opened in SSMS 2008 R2"

    In yesterday's blog post Introducing sp_CascadingDataViewer I mentioned that one of the artifacts up at http://cascadingdataviewer.codeplex.com is a SQL Server Reporting Services (SSRS) report that visualises the output from sp_CascadingDataViewer and its compatriot sp_CascadingDataViewerTableWrapper. My intended usage for the report ...
    Posted to Jamie Thomson (Weblog) by jamiet on August 12, 2010
  • SQL Server PowerShell Provider And PowerShell Version 2 Get-Command Issue

    The other day I blogged that the version of the SQL Server PowerShell provider (sqlps) follows the version of PowerShell. That’s all goodness, but it has appeared to cause an issue for PowerShell 2.0. the Get-Command PowerShell command-let returns an error (Object reference not set to an instance of an object) if you are using PowerShell 2.0 and ...
    Posted to Buck Woody (Weblog) by BuckWoody on May 10, 2010
  • Transparent Data Encryption and the Latest Data Breach

    Well, It’s happened again. Hundreds of thousands of private records were stolen from a database. This one, however, was different. No one stole any passwords, no one did any social engineering, nothing was captured in-line. No, this one was accomplished by stealing the actual hard drives themselves!  When a thief breaks in and steals hard ...
    Posted to Buck Woody (Weblog) by BuckWoody on February 1, 2010
  • FILESTREAM: Storing Binary Objects in a database – or not

    Many shops need to store binary large objects (sometimes called BLOBS) in a database. There are really only two ways to do this: store in them in a table structure in the database itself using a binary data type, or store them in the operating system in a file folder somewhere and point to the file using a text field in a table. Both of these ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 28, 2010
  • Know Your Product Specifications

    As the Data Professional in your organization, the rest of the org looks to you to ensure that the system can handle what the business requires. To do that, you need to know two things: what the business requires, and what SQL Server can do. But of course there’s a bit more to it than that. Knowing the business side of the requirements – well, I ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 13, 2010
  • Spit it out already!

    You’ve probably seen that commercial where the chewing-gum company van stalks the guy who has been chewing the same piece of gum too long, and they attack him and make him chew another piece. I feel like that with SQL Server 2000. Almost every shop I go into has at least one primary application running on SQL Server 2000. Now, don’t get me wrong ...
    Posted to Buck Woody (Weblog) by BuckWoody on January 6, 2010
  • PowerShell Demo Prompt

    When I teach I have to set my fonts really big so that folks in the back can see. I show PowerShell from time to time, and people keep asking me about my latest prompt.  Here’s what my prompt looks like:   { univac\Buck on UNIVAC using AMD64 } --    12/23/2009 7:54:10 ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 24, 2009
1 2 Next >
Privacy Statement