Pulse » Recent Items from 9/27/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.
September
-
SQLAuthority News – Tomorrow Online Session – Ancient Trade of Performance Tuning – Index, Beyond Index and No Index
Today in few hours I am going to present on my very favorite subject of performance tuning. You can read more about this sessions over here. This presentation is based on the famous book ‘The Art of War’ written in sixth century BC by Sun Tzu. Index is usually a ...
-
Fancy a decent Compatibility Matrix?
Have you ever taken a look at Microsoft’s published compatibility matrix for SQL Server lock compatibility? If you have, then I don’t need to tell you that it sucks in a very big way. Have no fear, I have painstakingly redrawn at better one (via PowerPoint no less ...
-
SSMS Tools Pack 2.0 is out!
I know I’m a little late on mentioning that this great resource has been updated. Hopefully I can do a series on “tools in your SQL Toolbox” someday, but for now I’m just letting you know that there’s an update and it’s pretty cool. Two of ...
-
PBM On Schedule Mode
Let’s take a look out how to schedule policy evalution using the PBM On Schedule mode. Start by double clicking on the policy of your choice. Next we need to change the evaluation mode to On Schedule. As soon as you make this change you will notice a red ...
-
#TSQL2sDay T-SQL Tuesday 23–Early edition
Time once again for another edition of T-SQL Tuesday! What’s that, you say? Early? Why yes, indeed. Due to the potential schedule of conflict of PASS’s Summit 2011 occurring on the second Tuesday of October (the normal date for T-SQL Tuesday), I’ve gotten special permission to bump ...
-
Start daily programs – More n00bz fun with #Powershell!
When I get in to work in the morning, I like a good cup of coffee waiting for me, a neck rub, and all my favorite programs open and waiting for me. Since the first two seem out of the question, I focus on the third. I’ve automated my ...
-
SSIS Child Errors in Parent Package
If you have a parent package that is looping through a set of files and calling child packages and want the parent package to continue even if the child package fails, there is a little work involved in making this happen.In this example I have a parent package that ...
-
24 Hours of PASS Questions
I finally found the time to work through the questions from the 24 Hours of PASS session that I did. Thanks to everyone that attended the event Q1: Can you filter execution plans for sort warnings? No. The sort and hash warnings don’t appear in the execution plan. You ...
-
workaround for orphaned users
The server principal is not able to access the database under the current security context, is the error message appears for those users who was able to access the database / application earlier especially after refreshing database from production to dev, test or uat enviornment when the correspondent login is ...
-
PASS Summit Memories Blog Series – Day 27 – The Mad Scientist
That’s essentially what I consider Itzik Ben-Gan to be, his appearance and accent could be right out of a James Bond movie, or perhaps Phineas and Ferb. Itzik really needs a nickname, too, we should figure something out. I have never had the chance to meet him formally, but ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.