Pulse » Recent Items from 5/25/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
-
Project Lucy
Quest Software, the kind people behind SQLServerPedia are running an experiment in cloud based performance analysis called Project Lucy. The idea is that you can upload a SQL .trc (Profiler trace) file, and Project Lucy will do some analysis for you - analysing CPU time, durations, IO etc. There's histograms ...
-
SQLRally Scalable Shared Database Demo Redux
Several weeks ago now I had the honour of presenting at the very first ever SQLRally event in Orlando Florida and I gave a presentation around the very large (no pun intended) subject of scaling out your SQL Server data. At the end of one of my demos it unfortunately ...
-
Pyramid Analytics, XLCubed & Panorama Necto
I’m always curious to see what’s new in the world of SSAS client tools, and quite frequently get demos of the latest client tools. Here’s a brief summary of three client tools I’ve looked at recently… First of all, bioXL from Pyramid Analytics. It’s a ...
-
Using Built-in System Functions – NEWID() and NEWSEQUENTIALID()
You can use NEWID() and NEWSEQUENTIALID() to create a unique value of type UNIQUEIDENTIFIER. You can use the NEWID() as any other TSQL function as below: – © 2011 – Vishal (http://SqlAndMe.com) SELECT NEWID() AS 'Unique ID' Result Set: Unique ID ———————————— 86E49A76-B4CE-4798-9091-B7E494C05705 (1 row(s) affected) NEWSEQUENTIALID() ...
-
Another Advantage of Consultants
Takeaway: Veering away from technical content for a bit, I talk about the advantages of hiring an outside consultant to help with technical problems. (I’m a full time employee and I have been since University. So when I push the advantages of hiring consultants, I’m not trying to ...
-
Bad T-SQL Song Lyrics or How My Music Playlists Torment Me By Reminding Me of So Many T-SQL Code Sins
The other day I was sitting in my home office, contemplating what it would be like if I had a zebra and enjoying some music while consuming my lunch. I was also reviewing some T-SQL for a client and was going down a mental checklist of the bad T-SQL habits ...
-
ABL: Always Be Learning
If you have been in the IT field for any length of time, I’m sure you have heard the phrase “Always Be Learning”. If you want to be successful and make the big bucks, you are going to have to devote a certain amount of hours each week to ...
-
Where’s StrateSQL?
Earlier this year, I had started off with a bang. I think I had 51 posts in January with a huge dip now as we approach the end of May. You may be wondering if I burned out or dropped off the face of the earth. Or maybe not. Long ...
Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.