Pulse » Popular Items from 12/8/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.
-
CXPACKET? What’s That? And What’s Next?
Takeaway: Is the wait type CXPACKET bothering you? It means parallelism. Here’s how to find the queries that are giving you this grief. The Wait Type CXPACKET Since 2005, SQL Server provides dynamic management views (DMVs). These views help monitor database health and they’re the first place I ...
-
SQL SERVER – Bad Practice of Using Keywords as an Object Name – Avoid Using Keywords as an Object
Madhivanan is SQL Server MVP and very talented SQL expert. Here is one of the nugget he shared on Just Learned. He shared a tip where there were two interesting point to learn. Do not use keywords as an object name [read DHall's excellent comment below] He has given ...
-
Must-Have Resources – SQL Server Backup & Recovery
One of the things that drives me crazy as I’m getting older is that my brain is losing the capacity to differentiate version numbers. As I speak travel around speaking with customers and at conferences, I find my self saying things like “I can’t recall if this problem ...
-
SQL Server is Smarter Than You
I had a brief email discussion recently, which could be effectively be boiled down to: Them: “Are foreign key constraints more performant than referential integrity triggers?” Me: “Yes.” *stomp*stomp*stomp*stomp* “Yes, they are.” Let’s start with a generic statement, and get more specific. Generally speaking: Don’t ...
-
SQLBits X - All signed up!
SQLBitsis the largest European community conference, dedicated to Microsoft SQL Server. This SQLBits is going to be extra-special, however: it is the UK Technical Launch for SQL Server 2012, and is held on 29th – 30thMarch. So if you’re interested in the new SQL Server – and who isn’t? – ...
-
Be careful using sysprep with Windows 2008 r2 in a cloud environment
First off, this is an excellent post on the new changes with sysprep with Windows 7/Windows 2008r2: http://briandesmond.com/blog/how-to-sysprep-in-windows-server-2008-r2-and-windows-7/ I could not write it better myself, so if you need help with sysprep and all the new changes, please review Brain Desmond’s blog on it ...
-
Don’t sit up straight at your desk
Going in a slightly different direction than a previous post on “The downside to being in IT”, I saw a post by Michael Hyatt (Blog|Twitter) recently that had an infographic about why sitting down so much is killing us. The biggest part about the graph for me was sitting ...
-
Have a need to port existing SQL Server Agent Jobs?
If you are like me, you have a few SQL Servers that you are managing and sometimes you write a cool job and say to yourself that would be awesome if I could take this job on Server A and allow Server B to run this job as well. Well ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.