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

July

  1. 147
  2. 222
  3. 312
  4. 434
  5. 548
  6. 649
  7. 745
  8. 843
  9. 912
  10. 109
  11. 1155
  12. 1256
  13. 1362
  14. 1451
  15. 1536
  16. 1617
  17. 177
  18. 1848
  19. 1959
  20. 2052
  21. 2145
  22. 2237
  23. 238
  24. 247
  25. 2539
  26. 2633
  27. 2737
  28. 2855
  29. 2941
  30. 3014
  31. 3120

18

  1. 12 A3
  2. 12
  3. 20
  4. 30
  5. 40
  6. 52
  7. 61
  8. 71
  9. 80
  10. 91
  11. 101
  12. 110
  13. 12 P6
  14. 17
  15. 23
  16. 36
  17. 45
  18. 50
  19. 61
Home

  1. Want to take a look at Securing SQL Server for 30 days?

    Thanks to Amazon, now you can rent Securing SQL Server for 30 days, and if you like it you can buy it with the cost of the rental being applied to the cost to buy the digital copy of the book. This is all done through Amazon’s new ebook ...

  2. Want to take a look at Securing SQL Server for 30 days?

    Thanks to Amazon, now you can rent Securing SQL Server for 30 days, and if you like it you can buy it with the cost of the rental being applied to the cost to buy the digital copy of the book. This is all done through Amazon’s new ebook ...

  3. SQL Server – Denali CTP3 – DATEFROMPARTS() and TIMEFROMPARTS()

    These are new functions in SQL Server "Denali". DATEFROMPARTS() returns a DATE value with specified day, month and year. It takes three arguments: DATEFROMPARTS (@Year, @Month, @Day) If the arguments are invalid, it raises an error. – © 2011 – Vishal (http://SqlAndMe.com)   SELECT DATEFROMPARTS (2011, 07, 18) AS 'Today' ...

  4. Search Argument Case Study: WHERE the year was 2002…

    Content Rating: Beginner, Tips It’s entirely possible that you’re fiddling with your search arguments too much, and missing out on the boost a good index gives your query.  Here’s a quick demonstration of the power of a well-thought-out search clause on a date column.  For this example ...

  5. Why My Policy will not Evaluate System DBs

    Do you have a policy that is supposed to include “Every Database” as part of its condition, but for some reason it never includes the system databases?  The “Every” condition is a built-in condition that cannot be changed and does not include system databases. If you want to include the ...

  6. DAX Queries, Part 3

    Following on from my previous post, let’s now look at how you can add derived columns to a table expression. Let’s start with a simple query that returns every column in DimDate: evaluate( DimDate ) If I want to add some columns to this query without doing any grouping ...

  7. SQL Server “Denali”: Details on the next version of SSIS

    CTP3 of SQL Server Code Name “Denali” was made available recently, and it offers a lot of new features for SSIS.  Some of my favorites are: SSIS Projects, which is an encapsulation of multiple packages into a single unit that you build, deploy & execute.  See Introduction to SSIS Projects ...

  8. Interview with our new whipping boy Adrian Bethune

    While at Tech Ed 2011 I spent a good amount of time talking with Adrian Bethune (@canon_sense) who is the new product manager for SQL Server Manageability, originally hired onto the team by the magnificent Dan Jones (blog | twitter) who was smart enough to run screaming from the team ...

  9. Configuring a VMWare clone for SSRS disaster recovery

    Our environment contains two instances on SQL 2008 that host Reporting Services. They are not in a scale-out architecture, rather each SSRS instance points to two separate data centers. However the reports on both instances are identical. Both instances are being hosted as virtual servers using VMWare. Recently we began ...

  10. The Importance Of Maintenance On VLDBs

    One of the problems DBAs encounter when working with very large databases (VLDBs) is an obvious one – lack of disk space. These databases grow over time, seeming to swallow whatever disk space you can throw at them. As they get bigger, it also takes longer to perform basic maintenance ...

Home

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