Geeking with a Hyper-V cluster at home. Part 2 is up! The Microsoft SQL Server Tips & Tricks folks created a great blog series on installing a cluster using Hyper-V.  Part 2 was just posted.  Wanna learn about Windows and SQL Server clusters? Go check it out!!! Lee   ---------... [More]

Posted in: The Best of MSDN Blogs  Tags:
Interesting MSDN blog for the week.  Well, besides at least 30 blog postings that tell us SQL Server 2008 R2 is out (sort of a misnomer by the way as of this second because it's not on MSDN subscriber downloads and won't be per Microsoft for another week or two) and the usual multiple posts by... [More]

A few thoughts from Day 2  (dump) Fast Track Data Warehouse is cool, and after a session on Fast Track Data Warehouse (FTDW) training Day 2 at the Microsoft MTC in Irving, TX, I have a much better idea of what is trying to be accomplished. Here’s my takeaway from today, again in dump format: ... [More]

Posted in: SQL Server 2008  Tags:
Lee posted on April 27, 2010 11:50
Some thoughts from Day 1  (dump) Fast Track Data Warehouse is cool, and after a session on Fast Track Data Warehouse (FTDW) training Day 1 at the Microsoft MTC in Irving, TX, I have a much better idea of what is trying to be accomplished. Here’s my takeaway from yesterday in dump format: H... [More]

Posted in: SQL Server 2008  Tags:
About a year or so ago, SQL Server Magazine (SQLMag.com) came out with a list of free downloads for SQL Server [1]; it included both totally free as well as trial downloads, all of which were lots of neat third party add-ins for SQL Server.  I thought it would be cool to review a bunch of them ... [More]

Posted in: Etc. (Off-topic)  Tags:
Lee posted on April 22, 2010 12:26
Discussion on IDENTITY. The guys from the North Texas SQL Server Users Group (NTSSUG) were dorking with IDENTITY yesterday, and it was a pretty good discussion.  Someone asked what happens when an integer column attempts to move past the value of 2147483647, which started the chat.  It br... [More]

Posted in: TSQL  Tags:
Lee posted on April 18, 2010 08:55
Check out this book for info on the latest release.  It's a bit slow again on the MSDN list of blogs this past week, other than news of the release of Visual Studio 2010; I did happen to find a new ebook out on the MVP Factor blog site that I thought might be of value. It's written by Ross Mis... [More]

Posted in: SQL Server 2008  Tags:
Get signed-up! There are still openings (as of yesterday) for SQL Saturday #35 in Dallas.  Get to this link and join us, won’t you?  I hear that Joe Celko, Brian Knight, Jason Massie, Tim Mitchell, Sean McCown, and other top SQL Server MVPs and pros will be there, so it is surely going to... [More]

Posted in: TSQL  Tags:
admin posted on April 12, 2010 22:14
Interesting finding, I reckon. I see some posts on the internet about the cost of updating a column to itself; you might find a statement (or maybe you have used one) that looks like so: UPDATE TABLE SET id = ISNULL(@var,id) Essentially, if the variable is NULL, you update the column to itself... [More]

Lee posted on April 11, 2010 09:37
Geeking with a Hyper-V cluster at home. Sweet! The Microsoft SQL Server Tips & Tricks  folks created a great blog series on installing a cluster using Hyper-V images for the host and guests.  If you want to run a cluster at home for geeking with Windows and SQL Server clusters, check ... [More]

Posted in: SQL Server 2008 , SQL Administration  Tags:
Error when redirecting a row in SSIS. This is a super-easy fix when you come across the following while trying to move error rows from an OLE destination in SSIS to a different destination: The error row disposition on “input “ OLE DB Destination Input” ()” cannot be set to redirect t... [More]

Posted in: SSIS  Tags:
admin posted on April 8, 2010 21:00
I found two interesting ones for this week. It's been kind of slow on MSDN site for SQL Server, not sure why.   By the way, ever wonder why, as I have, their blog site is running on Community Server and not Sharepoint? Not that I'm knocking Community or anything; on the contrary, it's o... [More]

Posted in:   Tags:
Lee posted on April 5, 2010 12:51
I’ll be Presenting at SQL Saturday #35 in Dallas. Ok got word today that I’m presenting at SQL Saturday #35 2010 in Dallas on May 22, 2010. Very cool! What is a SQL Saturday event?  SQL Saturday lists on their facebook… SQL Saturday is a one day free training event for SQL Server professio... [More]

Posted in: TSQL , Etc. (Off-topic)  Tags:
Lee posted on April 4, 2010 14:58
Geeking with MongoDB and .Net. Time for another off-topic post?  Well, maybe not completely I suppose.  I had a .Net expert contact me this week and ask me if I had done any performance comparisons with a file or document-based database - often termed "NOSQL" databases - to SQL ... [More]

Posted in: Etc. (Off-topic) , TSQL , SQLServerPedia  Tags:
Ran across this one the other day. I was searching for something the other day on Google!, can’t remember what right now, and happened upon an old post [1] (old for the internet – 1998) entitled The EXISTS Flaw.  This referenced a C.J. Date from September, 1989 and his postulate on a flaw with... [More]

Posted in: TSQL , SQLServerPedia  Tags:
Good download from a SQL guru.  Found a blog by Cindy Gross where she posted her slide decks and other information from a recent presentation off her site entitled Cindy Gross - Troubleshooting, tips, and general advice about SQL Server that I thought might be of interest. Cindy is a Microsoft... [More]

Posted in: The Best of MSDN Blogs  Tags:

by Lee Everest, M.S.

Info

Poll

Do you use Azure or cloud in your organization?
Show Results

Ads

Search


Month List

Calendar

«  May 2012  »
MoTuWeThFrSaSu
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2012 Lee Everest's SQL Server, etc. weblog