Pulse » Popular Items from 7/7/2009

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

  1. 15
  2. 22
  3. 33
  4. 42
  5. 51
  6. 65
  7. 710
  8. 86
  9. 95
  10. 104
  11. 112
  12. 120
  13. 136
  14. 144
  15. 157
  16. 165
  17. 174
  18. 180
  19. 192
  20. 209
  21. 216
  22. 228
  23. 235
  24. 245
  25. 250
  26. 261
  27. 272
  28. 2810
  29. 294
  30. 303
  31. 316

7

  1. 12 A0
  2. 10
  3. 20
  4. 30
  5. 40
  6. 51
  7. 60
  8. 70
  9. 80
  10. 90
  11. 100
  12. 111
  13. 12 P0
  14. 10
  15. 20
  16. 31
  17. 41
  18. 51
  19. 61
Home

  1. Script Data for a Table

    Today a tweet came across my screen that mentioned that you can’t script out data from SQL Server tables. But… actual you can if you have SQL Server Management Studio 2008 installed.  It’s one of the new options under the task Generate Scripts.  And it works very well ...

  2. What Happened to My Fabulous Beverage!

    Everyone likes taking some time to relax.  You’re sitting out in the sunshine or on a beach and the waitress is bringing you your favorite beverage.  The company and conversation is great and it seems like the perfect day.  And then… suddenly without warning… your drink is gone. You ...

  3. Oh Yeah? Collate This!

    So I decide to start a blog, and I figure my first blog entry will be a really cool and helpful stored procedure that people can use to produce T-SQL code that creates and populates sample tables, thus enabling them to paste this code into forum messages when asking for ...

  4. SQLAgentMan Contest #1

    I originally planned this post to just vent about a vendor doing something evil to their own database hosted on a shared instance of SQL Server I administer.  Then I thought that I may be able to make a contest out of this…  So, what caused me to come up ...

  5. Policy Based Management with SQL 2008

    A few weeks back I presented at the Tampa SSUG meeting on Policy Based Management with SQL 2008. Unfortunately due to sickness and apparently my own laziness, I never got around to doing a follow-up post or posting my slide deck. First the slide deck: Powerpoint 2007 version Powerpoint 97-2003 ...

  6. How to Create a Server-Side Trace with SQL Profiler

    This morning on Twitter my friend (and as per request, “handsome moron”, but trust me he’s no moron) Jeremiah Peschka (Twitter) asked about scheduled traces. I suggested he do a server-side trace. Unfortunately when you Google how to do this it just tells you how to do this via ...

  7. Stunt Car Drivers, Eggs Benedict, and You

    Wanna be the best at what you do? Start paying attention to more than just “what you do.” What Ken Block Does Ken Block is a rally car driver, which means he slides cars around dangerous obstacles at high speed with great precision.  Thing is, though, lots of people can ...

  8. Bloated MSDB database

    So how do you drop databases? Do you use a simple DROP DATABASE statement? Do you detach the database and remove the files manually? Do you use the GUI? Run these two quick and dirty queries for me: SELECT COUNT(*)FROM   msdb.dbo.backupset SELECT COUNT(*)FROM   msdb.dbo.backupset ...

  9. Renaming Your MS SQL 2008 Database

    I still remember many of the tasks I performed as a DBA for the first time. One of the first requests to come my way was to rename a database. Simple enough, or so I thought. I did a dump, then a restore, renaming both the database and the files ...

Home

Pulse is a section of SQLServerPedia that gives you a quick view of what's happening in the SQL Server community.