Pulse » Popular Items from 11/2009
Welcome!
Pulse has a simple goal: to give you a quick view of what's happening in the SQL Server community.
-
Browse
Finding interesting content on Pulse is easy – you can drill down to a specific time period (by clicking on the bars of the chart), toggle different types of content on and off, and sort the results by popularity or recency.
-
Vote
Discovered an informative blog post or a hilarious tweet? Tell the rest of the community about it by voting it up or down. Behind the scenes, our popularity algorithm will make sure it rises to the top of the list.
-
Comment
When a simple up-or-down vote isn't enough, voice your opinions in a comment. Or check out what others are saying about something you posted or tweeted.
-
SQL Saturday #34/New England Data Camp v2.0
It’s official sports fans. Well, it’s been official since last week since Adam Machanic set up the web site. The New England SQL Server Users Group and the Southern New England SQL Server Users Group are again jointly hosting a full day of SQL Server goodness on January ...
-
How do -you- install SQL Server? (Part 3)
Welcome to this series on a thought process around SQL Server Installation. In Part 1, we started talking about some basic steps and a thought process for a repeatable success story with your SQL Server installations. Part 2 discussed security, playing around before doing a first install and smoke testing ...
-
SQL 2008 R2 Utility Control Point (UCP) Videos
While Playing around with the UCP inside of SQL 2008 R2 I found some videos to help you get started. The November CTP has six videos listed but only five of the links are currently working. Here is the splash screen you will see to help you get started: The ...
-
SQL Server XQuery For Idiots
I’m still struggling with learning XQuery. My latest little revelation was small, but vital. The difference between: @inXML.nodes('/rss/channel/item') and @inXML.nodes('/rss[1]/channel[1]/item') Is the difference between a 10 minute query and a 4 second query. Kind of shocking really. My understanding ...
-
TechNet WebCast: SQL Server Locking & Blocking
Next Monday, I’m presenting a TechNet WebCast for Microsoft Thrive Live! The subject: SQL Server Locking & Blocking Made Simple. Here are the details: Event Overview A good working knowledge of how Microsoft SQL Server makes use of locking and transaction isolation levels can help you greatly improve an application ...
-
OPENXML can be a beast sometimes.
Our application includes some search functionality which is pretty complex to deal with. In a nutshell the user can select multiple values from a couple of lists on the website and use those listed to filter down the rows which are being searched. These lists are passed into the SQL ...
-
Have You Seen This Man?
EDMPASS WANTS BUCK WOODY!!! When talking to Summit attendees the one name that comes up constantly or the one question that comes up is… “Did you get a chance to see Buck Woody present?” I did… and it was my first time. It was the end of the day I ...
-
Ownership chaining or how to extend permissions without giving away the server
The nightly process in our production system collects data from our real time systems (JD Edwards) and then processes that data. Many of these process manipulate the data and supply a modified data set for use by the dozens of client processes and applications. All of the client applications have ...
-
Windows 2008 R2 Active Directory Enhancements
What server upgrade would be complete without some Active Directory enhancements? This release is no exception. One of the best enhancements (in my opionion) is that Active Directory now has a recycle bin. It's something that needs to be enabled and has its own requirements before you can do ...
-
The Sequels for SQL Server: The Week of November 27, 2009
Just as an FYI, I’ve added one new slide deck and webcast to http://KevinEKline.com/Slides/, as well as quite a few upcoming user group events where I’m speaking in http://KevinEKline/Upcoming-Events/. I’m starting a new series called Sequels for SQL Server. In this series ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.