Pulse » Recent Items from 8/1/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.

August

  1. 133
  2. 239
  3. 333
  4. 439
  5. 543
  6. 69
  7. 710
  8. 846
  9. 951
  10. 1050
  11. 1138
  12. 1251
  13. 139
  14. 1421
  15. 1532
  16. 1639
  17. 1757
  18. 1849
  19. 1937
  20. 2010
  21. 2119
  22. 2234
  23. 2333
  24. 2436
  25. 2511
  26. 266
  27. 271
  28. 283
  29. 2948
  30. 3042
  31. 3153

1

  1. 12 A0
  2. 12
  3. 22
  4. 30
  5. 40
  6. 50
  7. 60
  8. 71
  9. 80
  10. 91
  11. 100
  12. 111
  13. 12 P1
  14. 13
  15. 22
  16. 34
  17. 41
  18. 52
  19. 63
Home

  1. August Monthly SQL Server Checklist

    First day of the month and first Monday of the month.  The list is coming out a bit late due to these, hopefully you were more on top of this that I was.  As I mentioned back in June, the premise of this post is help DBAs maintain their environments ...

  2. SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Wildcard – Querying Special Characters – Day 2 of 35

    Answer simple quiz at the end of the blog post and - Every day one winner from India will get Joes 2 Pros Volume 1. Every day one winner from United States will get Joes 2 Pros Volume 1. Querying Special Characters Some special characters can be tricky to pattern ...

  3. PowerPivot in Denali: User Feedback and the Fourth Golden Rule of Interface Design

    Here, we will look at an example of PowerPivot user feedback that is improved in Denali from SQL Server 2008 R2. User feedback is a vital part of any software. In particular, this is especially important in the case of error handling, regardless of whether it is a pre-emptive measure ...

  4. SQL Server – New OS Related DMF – sys.dm_os_volume_stats

    sys.dm_os_volume_stats is a new dynamic management function introduced in SQL Server 2008 R2 SP1 and Denali CTP3. It returns information about partitions on which database files reside. You can now check for free space on a particular partition, instead of using xp_fixeddrives which does not support this. sys.dm_os_volume_stats ...

  5. Advantages of using CMS

    The most obvious advantage of a CMS is that it holds an inventory of all the SQL servers in our environment.  We can now connect to a single place and get a quick view of every server in our environment without having to remember each server and instance name. We ...

  6. SQL Server “Denali”: Project Apollo

    Project Apollo is a new feature in CTP3 of SQL Server Denali that enables a new columnstore index that offers 10-100x performance improvements for a star join or similar query.  Apollo brings together the in-memory columnstore technology (VertiPaq) that is used in PowerPivot and a new query execution paradigm called ...

  7. SQL Server won’t start due to LUNs being unavailable

    This question came up on ServerFault a while back and a wanted to expand on the solution more.  The basic problem that the person was having was that the iSCSI disks were taking a long time to come online which was causing the SQL Server to crash when the server ...

  8. Standing upon the shoulders of Giants

    In the very late nineties and early naughties I used to co-habit the Microsoft Newsgroups (which was then located at news.microsoft.com over the NNTP protocol), and in particular I posted primarily on the SQL Server forums to help others where I could. A by product of my helping ...

  9. Standing upon the shoulders of Giants

    In the very late nineties and early naughties I used to co-habit the Microsoft Newsgroups (which was then located at news.microsoft.com over the NNTP protocol), and in particular I posted primarily on the SQL Server forums to help others where I could. A by product of my helping ...

  10. Redundancy for SQL Server

       Designing Redundancy for SQL Server  is critical for High Availability  (HA) and Disaster  Recovery (DR) strategies. General areas in considering the HA  and DR stack. Physical locations (buildings,geography) Electricity Network Storage Load Balancers Servers Web Layer Middleware Database Layer Management\Monitoring    Focus on Storage Separate physical SAN switches per ...

Home

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