Pulse » Recent Items from 7/4/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.
July
-
Beware the SQL Community!
Today, I was going about my business attempting to answer an innocent question that had been asked on the #sqlhelp hash tag when moments later I receive the following Tweet… As soon as I saw this Tweet I knew I’d dropped a clanger (fatherjack is never one to miss ...
-
Beware the SQL Community!
Today, I was going about my business attempting to answer an innocent question that had been asked on the #sqlhelp hash tag when moments later I receive the following Tweet… Oh dear...what have I done... As soon as I saw this Tweet I knew I’d dropped a clanger ...
-
SQL Functions – CHARINDEX()
CHARINDEX() returns the starting position of an expression in another expression. It takes below arguments: CHARINDEX ( exp1, exp2, position ) Where, exp1 = expression to be searched, exp2 = the main expression which contains exp1, position = this is optional, it specifies a position in exp2 from which the ...
-
How to re-create database quickly
I was running some database unit tests and needed to drop completely everyhing in my database. There are really many ways how to do that but I like following way because it kills all existing connections automatically and can be executed with one keystroke. It is not any rocket science ...
-
How to re-create database quickly
I was running some database unit tests and needed to drop completely everyhing in my database. There are really many ways how to do that but I like following way because it kills all existing connections automatically and can be executed with one keystroke. It is not any rocket science ...
-
Do What I Tell You!
Back in April, I ran across what I consider to be a horrendous piece of code in a stored procedure. This code cost me several hours of after hours work on a Saturday night plus wasted the time of at least four other people who were involved in this particular ...
-
2011 SQL Server MVP Award
Thanks Microsoft for awarding me the MVP for SQL Server for the third year in a row. It’s a great honor to receive the MVP award and I appreciate the recognition from Microsoft. I’d also like to thank those that have read my blogs, attended my sessions, and ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.