Pulse » Popular Items from 2/2010

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.

2010

  1. J219
  2. F4k
  3. M18k
  4. A21k
  5. M20k
  6. J19k
  7. J16k
  8. A17k
  9. S18k
  10. O22k
  11. N15k
  12. D16k

February

  1. 111
  2. 211
  3. 33
  4. 420
  5. 5115
  6. 64
  7. 73
  8. 810
  9. 912
  10. 103
  11. 1113
  12. 1210
  13. 132
  14. 143
  15. 1511
  16. 1615
  17. 1723
  18. 1853
  19. 19133
  20. 2011
  21. 2121
  22. 22219
  23. 23703
  24. 24637
  25. 25569
  26. 26555
  27. 27312
  28. 28299
Home

  1. @MidnightDBA all our oracle and MS SQL server DBs are virtualized and it's honestly fantastic. Can't recommend it enough

  2. MCM Prep Week: Interview with Joe Sack

    As one of the bloggers behind The Master Blog, Joe Sack is a public face for the SQL MCM program. Joe also blogs at MSDN, and he manages the SQL MCM prerequisite reading list. The MCM program isn’t even his “day job” – he’s also a Senior Premier Field Engineer, ...

  3. Do your Clustered Indexes on IDENTITYs Have the Correct FILLFACTOR?

    The great thing about blogging is that it forces you to be as sure as you can that you know what you're talking about. That alone makes it worthwhile...I started this FILLFACTOR post a few days ago with a completely different goal in mind. After I did my due diligence, ...

  4. Querying Oracle from Powershell Part 1

    In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can run queries against Oracle we need to install the Oracle client on our Windows machine. Unlike SQL Server, the drivers for connecting to Oracle are not included with the operating ...

  5. Recursively Delete SSIS Folder

    A while ago I posted a query to create a list of all the Integration Services packages deployed to the MSDB.  I am now using that query to take it a step further. If you’ve been using SSIS for a while you’ve probably noticed that the Management Studio ...

  6. Recursively Delete SSIS Folder

    A while ago I posted a query to create a list of all the Integration Services packages deployed to the MSDB.  I am now using that query to take it a step further. If you’ve been using SSIS for a while you’ve probably noticed that the Management Studio ...

  7. SQL Agent – Giving non-SA users permissions on jobs

    There are some new database roles in the MSDB database in SQL Server 2005 that allow you to grant more granular permission to  non-sa users in the SQL Server agent. If you work in an environment similar to the one i support, application and database code will pass through several ...

  8. SSRS NOT LIKE expression

    I had the recent request to provide the ability to filter data in a report that was not like specific pattern. This requirement is not uncommon or difficult when placed on the dataset using a parameter:SELECT FirstNameFROM Person.PersonWHERE FirstName NOT LIKE @filterThe difficulty was that the report was being presented ...

  9. SQL SERVER – INSERT TOP (N) INTO Table – Using Top with INSERT

    During my recent training at one of the clients, I was asked regarding the enhancement in TOP clause. When I demonstrated my script regarding how TOP works along with INSERT, one of the attendees suggested that I should also write about this script on my blog. Let me share this ...

Home

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