Pulse » Recent Items from 9/29/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.

September

  1. 17
  2. 29
  3. 37
  4. 45
  5. 52
  6. 63
  7. 73
  8. 815
  9. 914
  10. 1039
  11. 1112
  12. 123
  13. 134
  14. 1412
  15. 1517
  16. 1610
  17. 1715
  18. 1814
  19. 191
  20. 202
  21. 2112
  22. 2212
  23. 2318
  24. 2412
  25. 2512
  26. 265
  27. 278
  28. 2816
  29. 2924
  30. 3032

29

  1. 12 A1
  2. 11
  3. 20
  4. 31
  5. 40
  6. 50
  7. 60
  8. 70
  9. 80
  10. 90
  11. 101
  12. 111
  13. 12 P2
  14. 13
  15. 20
  16. 30
  17. 40
  18. 52
  19. 60
Home

  1. PowerShell: Quick SQL Server Version Check

    I have to keep track of our SQL Server version inventory.  The goal is to reduce the SQL Server 2000 population as fast as possible. The following PowerShell script will produce a csv file containing the database server name and the version of SQL Server it's running. .csharpcode, .csharpcode ...

  2. PowerShell: Quick SQL Server Version Check

    I have to keep track of our SQL Server version inventory. The goal is to reduce the SQL Server 2000 population as fast as possible. The following PowerShell script will produce a csv file containing the database server name and the version of SQL Server it's running.1: ## Get ...

  3. Linked server problem? No, connectivity issue.

    In my new role as a Database Hardener, I also function as Level 2 Production Support. If the Production Support Team can't resolve an issue, they pass it to me. Recently, I was given the task to troubleshoot a linked server issue that had stumped other DBAs.Both instances ...

  4. Technical Presentations: Give it a Shot!

    If you have never done a technical presentation I HIGHLY recommend you do try it at least once. Volunteer to speak at your local user group or SQL event. Andy Warren (Blog | LinkedIn) recently added the idea of mini-presentations to both his user group meetings as well as the upcoming ...

  5. Review: Inside MS SQL Server 2008: T-SQL Querying

    It’s day two of Banned Book Week / the MidnightDBA book review party, and we're digging into one HEAVY SQL tome: Inside Microsoft SQL Server 2008: T-SQL Querying, by Itzik Ben-Gan, with Lubor Kollar, Dejan Sarka, Steve Kass, and Kalen Delaney. I’m a big fan of Itzik Ben-Gan ...

  6. More on the MVP SQL Server book

    If you buy from Manning directly today or tomorrow, there’s a 50% discount . Use the code pop0928 at the checkout. Hurry, hurry, hurry…. For those who want a copy and are going to the PASS Summit in November, why not pick up your copy of the book there? The ...

  7. Know Your Data!

    Back in July, I wrote a blog entry that highlighted the CROSS APPLY operator. A problem was presented that required us to pull word pairs out of a column called Message in a temporary table @T and find out how many times the word pairs occurred in the table. Two ...

  8. Update on Combine

    I mentioned change management in a past post. I’ve also mentioned SQL Farms Combine as a tool we used at a previous company for change management. It allowed us to grab code from source control and deploy it to multiple servers. The features made it a pretty useful tool for ...

  9. Where Does the Business Logic Go?

    A few years ago, when I was at the utility company, we were implementing the new customer management system. This was the first time I had ever seen a system that implemented all of the business logic in the database. Most of my experience was with the logic being on ...

  10. User Group Networking Bingo

    I’ve been to a number of conferences and have always found it difficult to walk up to people that I don’t know and introduce myself.  It’s just not something that comes natural to me.  And I’ve found that this typically isn’t a strength of other ...

Home

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