admin posted on March 10, 2010 15:26
I learn something every day. Perusing the MSDN blogs, I noticed a cool one by Joe Sack that I wanted to make note of here... it doesn’t appear that Joe blogs a whole lot, but when he does, it’s usually worth reading.  This time he writes about the TSQL command ALTER INDEX ... [More]

Posted in: The Best of MSDN Blogs , TSQL  Tags:
Interesting blog by the SQL Customer Advisory Team This week’s MSDN Blogs category found me on the SQLCat site reading about enabling partition-level locking in SQL Server 2008.  I’ve never heard of this “hidden” feature, so it sounded cool. Essentially what they did was demonstrate a method... [More]

Posted in: The Best of MSDN Blogs  Tags:
Great post on creating SQL counters. Found a nice post on the MSDN blogs by Jay on how to create a custom perfmon counter for SQL Server.  Good stuff!  I’ve always wondered about this back to, oh, SQL Server 7.0 at least, but I never knew how to create one and really didn’t have a reaso... [More]

Posted in: The Best of MSDN Blogs  Tags:
admin posted on February 13, 2010 07:44
Check it out for some good stuff. The SQL Server Evangelism Team has released a free download for developers that might be helpful on the new stuff in SQL Server 2008 R2. Go to their page at http://blogs.msdn.com/usisvde/archive/2010/02/09/free-bi-developer-training-kit-for-sql-server-2008-r2-re... [More]

Posted in: The Best of MSDN Blogs  Tags:
Lee posted on February 3, 2010 07:20
New blog out on MSDN.   There is a new blog out on the MSDN SQL Server blogs called “REPL TALK” that I stumbled across the other day, and wanted to share the link:  http://blogs.msdn.com/repltalk/default.aspx. This might be a great venue to shoot a question over to a member o... [More]

Posted in: The Best of MSDN Blogs  Tags:
Lee posted on January 26, 2010 10:39
SQL Server 2008 R2 goodies are starting to rolling out. I was just looking around this weekend and noted all of the SQL Server 2008 Webcasts, virtual labs, etc. that have come out over the past few months; today I saw a post on the MSDN Blogs about some just coming out this week in fact, where... [More]

Lee posted on January 10, 2010 07:09
Stay up to date, or get left behind. I’m still amazed that this 3-year release cycle is still going according to plan with regards to SQL Server and Windows.  I wonder sometimes if Microsoft even knows how many huge, global companies are still on SQL Server 2000!  Here’s a l... [More]

Posted in: The Best of MSDN Blogs  Tags:
admin posted on December 28, 2009 07:35
A nice series to check out.   Here is a cool set of SSIS best-practice articles that I found on the MSDN blog site; you might check these out if you’re looking for some tips on making SSIS run well.  I found a few things that were pretty interesting and recommend the reading. http://blo... [More]

Posted in: The Best of MSDN Blogs , SSIS  Tags:
This is a jim-dandy. You gotta read this one.    So I’m once again perusing the MSDN blogs looking for great stuff when I come across one from the CSS SQL Server Engineers about DBMail suddenly stops working (1).  This is significant because everybody and their dog uses sp_sen... [More]

Posted in: The Best of MSDN Blogs  Tags:
Admin posted on December 4, 2009 20:15
There is a reason why UDFs kill performance   Saw a great blog post [1] on the MSDN blogs regarding query tuning with UDFs; specifically the problem that was addressed is one that many of us have had to deal with, which is having to overcome the effects of a UDF in the WHERE clause of a ... [More]

This is pretty slick. Found another handy blog on MSDN...Here's a way to create a DSN-less connection in Microsoft Access, very nice!  Where I am consulting they use Access dbs to store static lookup information for their data marts/warehouses.  And since it's a global organization with s... [More]

Posted in: The Best of MSDN Blogs  Tags:
Verifying our results.   I received an email the other day from Kevin Stephenson, a SQL Server guru from the Microsoft SQL Server Customer Advisory Team, SQLCAT, who prompted my interest in the “Deleting Data Quickly…” series of blogs found on this site. Kevin mentio... [More]

Admin posted on November 15, 2009 05:28
Nice cheat sheet for SSIS. Douglas Laudenschlager found a cool SSIS expression cheat sheet located on the PragmaticWorks website; found a few cool things there so you might go check it out. A couple of things, they’ll require you to sign up at the site before you get the paper.   Lee... [More]

Lee posted on November 5, 2009 06:14
New Sharepoint book - decent read.  Saw a blog on the MDSN blog site today that pointed to a new whitepaper/online book on Sharepoint administration for SQL Server DBAs. Thought that this might be worthwhile read since every Sharepoint site that you’ve ever been on is slower than molass... [More]

Lee posted on October 12, 2009 06:05
For your reading enjoyment.  I've created a new category here entitled "MSDN Blogs" for your consideration. This will be my review or report, of sorts, of current postings from the MSDN team of bloggers, probably a billion people in the world that are employed by Microsoft. I'm going to l... [More]

Posted in: The Best of MSDN Blogs  Tags:
Lots of folks need to check this out!    Just noticed a blog post from the CSS SQL Server Engineers/Bob Ward; if you use linked server queries on SQL Server 2005 or SQL Server 2008, you need to go read this.   http://blogs.msdn.com/psssql/archive/2009/09/22/if-you-use-linked-ser... [More]

Sharing some old tricks for deleting rows in a table I was looking around the SQL Blogs again this evening and stumbled on SQLCat and a blog entitled Fast ordered delete [1] from last May.  I won’t paste their code – get it at the link - but apparently the MySpace boyz were in Redm... [More]

Posted in: The Best of MSDN Blogs , SQLServerPedia , TSQL  Tags:

by Lee Everest, M.S.

Search


Ads

Calendar

«  March 2010  »
MoTuWeThFrSaSu
22232425262728
1234567
891011121314
15161718192021
22232425262728
2930311234
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 2010 Lee Everest's SQL Server, etc. weblog