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 » DBA   (RSS)
  • Start a SQL Server Agent Job using the SQL Server PowerShell Provider

    Whew!  That’s a mouthfull. Anyway, I thought I would share part of a script I wrote today to help automate (more) from PowerShell. This assumes a few things: that you’re doing this from the SQL Server 2008 PowerShell provider (not just good old regular PowerShell) and that you change the HAL9000 and SQL2K8 parts with your server name and your ...
    Posted to Buck Woody (Weblog) by BuckWoody on February 10, 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
  • After the Upgrade, it runs differently…

    I got a question yesterday in the mail that I thought I would just answer here in a broad context. While I can’t troubleshoot or do performance tuning from a distance, there are some interesting concepts and suggestions this e-mail brings up: “I have recently seen a change from SQL Server from 2005 to 2008 in where it handles CASE statements ...
    Posted to Buck Woody (Weblog) by BuckWoody on December 1, 2009
  • New Features Announced In SQL Server 2008

    Buck Woody, Microsoft SQL Server Program Manager, recently posted a list of enhancements in the works for SQL Server 2008 RTM in the SQL Server MVP newsgroup. The usual suspects were included in the list: Policy-Based Management (formerly DMF), Resource Governor, Multi-Server Query, PowerShell, and IntelliSense - but there are also some ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 13, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement