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   (RSS)
Showing page 3 of 7 (62 total posts)
  • SSMS Tips and Tricks: Scripting Inserts

    Sometimes you need to be able to script the loading of a table. SSIS and the Import/Export Wizard can do this, but there are times when you really need a complete set of insert statements. Red Gate’s SQL Data Compare or SQL Packager can do this, but not everybody has the budget for a commercial tool. SQL Server Management Studio 2008 can script ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on October 13, 2009
  • Exploring Composable DML

    SQL Server 2008 includes a new feature called “Composable DML” which I hadn’t heard about until I read Adam’s post Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE. Composable DML is a new feature in T-SQL that allows you to use the data provided by the OUTPUT clause of a DML (i.e. INSERT, UPDATE, DELETE) statement as a derived ...
    Posted to Jamie Thomson (Weblog) by jamiet on August 30, 2009
  • PowerShell's "Mini-Shell" Is Not A "Mini" Shell

    I just learned about a Connect item entered on Friday: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=475337. Here's the description in the item. Please invoke the full powershell not a ''mini-shell''. Powershell is very powerful but the mini-shell you get when invoking Powershell from the Management Studio ...
    Posted to Allen White (Weblog) by AllenMWhite on July 20, 2009
  • PowerShell Whitepaper Published

    My first whitepaper for Microsoft, Understanding and Using PowerShell Support in SQL Server 2008 has been published. It was a great honor to have been selected to write the paper, and I thank Kalen Delaney for giving me the opportunity. I hope you find it useful. Allen
    Posted to Allen White (Weblog) by AllenMWhite on June 13, 2009
  • Tracking Deprecated Features

    This week I'm in Brno, Czech Republic leading an App Compat seminar for Microsoft clients here, and one of the things we need to look for in their applications is the use of deprecated features. I was poking around the sys.os_performance_counters DMV and discovered the [sqlinstance]:Deprecated Features object and found that if your application ...
    Posted to Allen White (Weblog) by AllenMWhite on May 26, 2009
  • sp_altermessage is back in business!

    This blog has moved! You can find this content at the following new location: http://sqlblog.karaszi.com/sp_altermessage-is-back-in-business-10/
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on May 14, 2009
  • [Nashville] Presentation: Administering SQL Server 2008

    As many of you know I run marathons. My next one is on Saturday in Nashville, the Country Music Marathon. Timing sometimes is our best asset, and so it is here in that the Nashville SQL Server Users Group is meeting on Friday at noon. They were kind enough to ask me to do my presentation on new features and administering SQL Server 2008. In ...
    Posted to Allen White (Weblog) by AllenMWhite on April 23, 2009
  • Geek City: Two Compression Questions and Parameter Metadata

    I am teaching the SQL 2008 version of my course for the first time this week. My life is still is disarray and spare time is practically non-existent.  During the evenings after I class I am trying to get caught up on several projects that I fell way behind on over the last month when most of my time was spent in the hospital. Blogging ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on March 10, 2009
  • User Group Presentation: Administering SQL Server 2008

    We are pleased to invite you to the March 12th 2009 meeting of the Ohio North SQL Server Users Group (ONSSUG). The meetings are held on the 2nd Thursday of every month at 5:45 in the Cleveland Microsoft office. The address of the office is below: Microsoft Corporation 6050 Oak Tree Blvd. Suite 300 Cleveland, OH 44131 Agenda: Topic: ...
    Posted to Allen White (Weblog) by AllenMWhite on March 10, 2009
  • SQLBits 2009

    This the second time in a row I will not able to attend to SQLBits - but don't lose this event if you can go to Manchester on March 28th, 2009. The conference is free, but registration is required. A training day (with a reasonable fee) is also scheduled the day before. I hope to attend the next one... The reason I cannot go is mainly because a ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 23, 2009
< Previous 1 2 3 4 5 Next > ... Last »
Privacy Statement