桃子视频

Month: June 2010

Categories
Syndication TSQL Tuesday

桃子视频#007 鈥� Roundup

New hotness

First of all I apologize for this roundup taking more time than usual to appear. This last week was my last week of work at the hospital and trying to get everything turned over as well as prepping for my move to Jacksonville my time鈥檚 been short to say the least. Without further ado, here鈥檚 this month鈥檚 #TSQL2sDAY roundup:

reports in on her love for all things Reporting Services.

fills in the gaps for us with a brilliant (as always) Intellisense post.

gives us some great insight on core database engine improvements. If you don鈥檛 think R2 brought anything to the core product stop and read this post.

merges several answers together with IntelliSense, Resource Governor and the MERGE statement! Also Andy鈥檚 new on my radar and has a so time to add another person to follow on Twitter/add to Reader!

packs a ton of great information in his post about compression.

talks about the new T-SQL and query writing improvements. This is awesome as I wasn鈥檛 aware of some of these new additions! Developers, this is a MUST read! Once again, another great blog added to my reader!

, one of the newest folks to attain the prestigious SQL Server Master certification, brings to our attention something you wouldn鈥檛 really think about: sysprep support! SWEET! Great walkthrough example using a virtual machine on Windows Server 2008 R2. Definitely an administrator MUST read.

takes us for a trip to the clouds with the SQL Azure team and SQL Server 2008 R2鈥檚 SQL Azure integration. If you鈥檙e even thinking about putting your database in the cloud check out this post and subscribe to the .

has plays the dating game in this post where she narrows down three great features (PowerPivot, Data Compression and The Data Collector) and finally comes up with her winning date. Read this post to find out who wins!

hasn鈥檛 been able to play with R2 yet but gives a great and detailed walkthrough of how and why to use User Defined Table Types as Table-Valued Parameters. VERY cool! Added to reader.

, of fame, gives us some great insight on StreamInsight. Honestly this feature also excites me so this is a really nice intro to the feature.

is a man after my own heart by talking about . Also always great to discover another great blog from across the pond.

, who did a fantastic job last week with SQL University鈥檚 HA/DR week, waxes poetic about all of the new changes in SSIS Data Flow Engine. If you care at all about SSIS performance check this out!

, aka , could鈥檝e written a whole book on all the new BI features but instead focused on Reporting Services. Nice breakdown of new hotness in SSRS.

talks about PowerPivot and comparing it to a certain scene in Austin Powers (no, not the hot tub scene with Alotta). Also make sure to give him a as well.

, aka , despite claiming to cheat by referencing one of his old SQLServerCentral posts covers a real nice example of how Data Compression helps you save space.

does a fantastic job of covering MERGE operations as well as showing us precisely how it improves performance over traditional methods. Very cool! Developers, definitely check this out!

walks us through the Resource Governor feature and how it works. Pretty cool feature to help cull down those resource-hungry queries from ad-hoc queries.

throws us for a loop as his favorite part about SQL 2008 R2 doesn鈥檛 even have to do with the features! Check it out.

is excited by what鈥檚 NOT there with his overview of filtered indexes in 2008 and how they helped him solve a specific issue on a homegrown solution.

Categories
Documentation PowerShell Syndication

PowerShell I Heart You

PowerShell = Giggity Giggity Goo

Ok so in the last 48 hours I think I’ve fallen madly in love with PowerShell. My time is limited so I’ll make this short. Last night I wrote a script to copy files from one file share to another and log the process. Luckily PowerShell community guru Laerte Junior (| ) and Ron Dameron (| ) were online and willing to help me out (as always). I aksed him some general questions but was determined to write script on my own and just have him review it and point me in right direction. So after much Boogling I got some code example and spat this PowerShell turd out:听

[sourcecode language=”powershell”]
try {
$a = (Get-Date -uformat "%Y%m%d").ToString()
听Get-ChildItem \servernameextracts_foldertestdata*.001 | ForEach-Object -Process{Move-Item -PassThru -Force $_.FullName -Destination \targetservernametest | Format-Table -AutoSize >> ("\servernameextracts_foldertestlogstest_extracts_copy" + $a + ".log")听 }
}
听catch {
听听"Error occurred on $_" >> \servernameextracts_foldertestlogstest_copyerrors.txt
}
听
try {
听Get-ChildItem \servernameextracts_foldertestdata*.IDX | ForEach-Object -Process{Move-Item -PassThru -Force $_.FullName -Destination \targetservernametest | Format-Table -AutoSize >> ("\servernameextracts_foldertestlogstest_extracts_copy" + $a + ".log")听 }
}
听catch {
听听"Error occurred on $_" >> \servernameextracts_foldertestlogstest_copyerrors.txt
}

[/sourcecode]

Basically it moves the files from one server to another and writes basic information of each file moved to a log file. The log file it writes to is dynamically named based on the date the script is ran. If the script bombs then it writes the errors to another log file the administrator can refer to for troubleshooting.听

Next up this morning I saw an article on ‘s newsletter on how to . 30 minutes? Hell, with PowerShell I think I could knock that out even quicker! And so I have, try 5. First create a text file with a list of all your server names. I’m sure you could get that using PowerShell too but Boogle it. Next try this code out:听

[sourcecode language=”powershell”]

Get-Content ‘c:serverlist.txt’ | ForEach-Object {systeminfo.exe /s $_ } | Out-File c:testserver_reports.txt

[/sourcecode]

ONE line of code and you have a full report of everything on your server. Giggity giggity goo! ALRIGHT!

Categories
Events PASS Syndication Virtual Chapter

Professional Development Event:Taking Control of Your Career

This is just a reminder that this month’s Professional Development virtual chapter meeting we have MVP, PASS Board member, and all-around badass Jeremiah Peschka (| ) presenting on . Here is the abstract of the presentation:

Raises, promotions, and job offers don’t happen by accident; you need a plan. Through careful planning you can create and reach impressive goals. But what’s the point of reaching your goals if nobody notices? “If you build it, they will come” doesn’t apply when you’re building your career.

In this session Jeremiah Peschka will show you:

  • How to set achievable goals
  • The importance of planning your career
  • Methods for recording and communicating your accomplishments

When: June 16th, 2010

Where:

Time: 1:00 PM EST – 2:00 PM EST (UTC-4) 听 []

If you’re interested in presenting at a future meeting for the PASS Professional Development virtual chapter please feel free to email me and let me know!

Categories
Syndication TSQL Tuesday

桃子视频#007: Summertime in the SQL

Invitation for 桃子视频#007

New hotness

Welcome back to the blog party known as T-SQL Tuesday. I鈥檓 honored to be hosting this month and since its Summer I鈥檝e decided to talk about hotness鈥eature hotness. In the last few months we’ve had the release of SQL Server 2008 R2 which brought along with it a . So this 桃子视频I ask: What’s your favorite hot new feature in the R2 (I’ll be nice and include 2008 in general) release? Got some code that takes advantage of a new feature? Post it! Got an example of how PowerPivot let you slice and dice data you simply couldn’t before due to contraints? Show us! Make sure to apply your SPF 1433 and get to writing.

Cabana Rules

This whole party started when Adam Machanic (| ) decided to start this awesome blogger party where one topic is chosen by the monthly host, everyone submits their posts, and those posts are then rounded up. Catch is these posts must all go up within the same 24 hour period. Here’s a list of the parties held so far:

  • #001 Adam Machanic asked for your favorite
  • #002 Adam followed up by asking for your favorite
  • #003 Rob Farley made the commitment with his topic:
  • #004 Mike Walsh kicked asked for your input on
  • #005 Aaron Nelson asked us to report on ““
  • #006 Michael Coles wanted to know All About

    • So write up your post and make sure to link back to this post for your entry to count.

    To participate your post must go live between 00:00:00 GMT on Tuesday the 8th of June and 00:00:00 GMT on Wednesday the 9th.

    Don’t Run on the Pool Deck

    Here are the posted rules for this shindig:

    ATTENTION: RULES HAVE CHANGED, SEE BELOW

    1. Your post must go live between 00:00:00 GMT on Tuesday the 8h of June and 00:00:00 GMT on Wednesday the 9th. If your post doesn鈥檛 go live in the time limits, it won鈥檛 be included in the round-up post.
    2. Your post must link back to this post (by trackback or comment).
    3. “桃子视频#007” MUST be in the title of the post.
    4. The above rule has been CHANGED! The new rule is that the title of the participating post no longer has to reference 桃子视频(although it’s still recommended). The post still has to link back to the hosting blog, but the link needs to be anchored from the NEW LOGO (found above), which must appear at the top of the post.
    5. It is your responsibility to verify the trackback or comment appears here on this post. If you don鈥檛 see your trackback add your own comment with a link back to your 桃子视频post and it will be included in the roundup.
    6. Don’t feed Gremlins after midnight
    Lifeguard on Twitter Duty

    A lot of the 桃子视频bloggers and bloggees are on Twitter. Follow the hashtag and when your post goes live, tweet a link to it with that tag.

    Hosting

    You too can host this event! Just have participated in at least two previous #TSQL2sDay and let Adam Machanic know you wish to host. That’s it!