Pulse » Popular Items from 5/6/2011
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.
May
-
SQL Rally Space Cowboys
With SQL Rally right around the corner I thought now would be a good time to get my preview posted. Since the event is in Orlando and just a few miles away from my most recent #NASATweetup experience, I thought it was best to tie the preview to a movie ...
-
Orlando 101 For SQLRally Attendees: Weather
The inaugural SQLRally in Orlando is less than a week away (May 11-13)! Maybe you're coming to Orlando for the first time, or maybe you've been here before but just aren't familiar with the area. I live a few miles away from the Marriott so I thought ...
-
RCSI/SI doesn't work with rows larger than 8046 bytes
During this week I have prepared a workshop about Locking & Blocking for one of my customers. One big part of this workshop was also the new Optimistic Concurrency model that SQL Server offers us since the inception of SQL Server 2005. Since SQL Server 2005 we have the READ ...
-
SQLRally OverDrive Events!
So you’re going to SQLRally in Orlando next week? Want to take advantage of ALL of the awesome opportunities presented? In addition to all of the amazing training content you’ll see at the event itself, we’re holding some great stuff after-hours on Thursday. We’re calling this ...
-
Recently Executed Queries – Using DMVs/DMFs
To find the queries that were executed recently using the sys.dm_exec_query_stats DMV. SELECT sql_handle, creation_time, last_execution_timeFROM sys.dm_exec_query_statsWHERE last_execution_time > '2011-05-06 06:45:00.000' The above statement will return the performance statistics for cached query plans. sys.dm_exec_query_stats contains the sql handle of the statement which was ...
-
May PASSMN Meeting
Date: May 17th Time: 4:00 – 6:00 Location: 8300 Norman Center Drive, 9th Floor, Bloomington, MN 55437 Live Meeting: URL: https://www.livemeeting.com/cc/usergroups/join?id=QBKC4F&role=attend&pw=g34SZ%7B5%5C9 Meeting ID: QBKC4F Entry Code: g34SZ{5\9 Agenda: 4:00-4:15 : Registration / hospitality ...
-
The best IT job boards
There are three job boards that I use: Dice, Monster, and LinkedIn. I prefer Dice by far, since it has a ton of IT jobs on it, and it is focused solely on IT. Monster is OK, but it does not have nearly as many IT jobs as Dice and ...
-
SQL University: Precedence Constraints
Welcome back, class! In our last class, we setup a parent-child package configuration and showed how you can pass variables between the two in order to complete a unit of work. In today’s class we’re going to continue exploring that data load package and take a look at ...
-
Re-blog – April 29-May 5
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts of interest that you may want to check out are: Analyze This – Analyze Your Indexes – Part 6 (4/29/2009) – Improved performance of index analysis query. Searching for Plans ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.