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

September

  1. 135
  2. 241
  3. 344
  4. 414
  5. 526
  6. 646
  7. 714
  8. 89
  9. 96
  10. 102
  11. 111
  12. 129
  13. 137
  14. 146
  15. 154
  16. 164
  17. 173
  18. 184
  19. 1913
  20. 208
  21. 216
  22. 228
  23. 2313
  24. 241
  25. 253
  26. 2612
  27. 2714
  28. 288
  29. 296
  30. 307

20

  1. 12 A0
  2. 11
  3. 20
  4. 30
  5. 40
  6. 50
  7. 60
  8. 70
  9. 80
  10. 90
  11. 100
  12. 110
  13. 12 P1
  14. 12
  15. 22
  16. 30
  17. 40
  18. 51
  19. 60
Home

  1. Stored Procedures – Common Security Practice

    In SQL Server a good practice is to access the data via calls through stored procedure. Have a look at the document available in that link. To further this practice, one may create a database role, then add users to that role. Permissions to execute the stored procedures would then ...

  2. I’m an Analysis Services Maestro!

    I’m very proud to say that I’ve been made an Analysis Services Maestro! You can read the official announcement here: http://sqlcat.com/sqlcat/b/technicalnotes/archive/2011/09/19/announcing-the-first-wave-of-ssas-maestros.aspx If you’re wondering what this actually means, you can find out more here; in a ...

  3. Migrating to SQL Server from another Database platform

    Migrating to SQL Server from another Database platform has a number of considerations 1) Create an inventory of existing applications. Separate into off-the-shelf and in-house 2) Ensure sufficient licenses on existing database platform can be retired to enable maintenance costs to decrease. 3) For off-the-shelf . Does the vendor support ...

  4. MSP Error: 29528 The setup has encountered an unexpected error while Setting reporting service exclusion path

    Yet another post related to SQL Server patching, eh? Yes. I feel I have a lot more lined up because in the next couple of months we will be applying Service Packs on close to 200 SQL Server instances. Last Sunday, Service Pack 4 was supposed to be applied on ...

  5. PASS Summit Memories Blog Series – Day 20 – Lay Your Hands On Me

    One aspect of the PASS Summit that often gets overlooked are the hands-on labs provided by Microsoft. Now, truth be told, I’ve only taken part in the labs once, back in 2005. I did so because SQL 2005 was coming out and I wanted to walk through a handful ...

  6. TSQL Tip O’ the Week – 9/20/11 – Comparisons

    This weeks tip: Know your comparison operators! Why? It may save you some embarrassment. For example: There is a big difference between > and >=. When writing TSQL, sometimes the “or equal to” of the comparison greater than or equal to gets forgotten. Pending on the standards there is a ...

  7. Statistics in Execution Plans

    I was presenting on execution plans when another question came up that I didn’t know the answer to immediately. Yes, I know you’ve seen that phrase before on this blog. I love presenting because you get exactly the kinds of questions that make you think and make you ...

Home

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