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

2

  1. 12 A0
  2. 11
  3. 20
  4. 31
  5. 41
  6. 50
  7. 61
  8. 73
  9. 80
  10. 90
  11. 100
  12. 110
  13. 12 P5
  14. 13
  15. 22
  16. 32
  17. 40
  18. 55
  19. 65
Home

  1. Applying a Snapshot -AltSnapshotFolder Parameter

    Did you know a snapshot can be applied using the Distribution and Merge Agent –AltSnapshotFolder parameter? This means that after generating a snapshot, it can be copied to Subscribers manually using removable media for instance, and applied locally. This can be useful with large snapshots and when replicating over slow ...

  2. SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Finding Apostrophes in String and Text – Day 3 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. Finding Apostrophes in string and text For the last two days ...

  3. SQL Server – Renaming database and physical database files

    Sometimes we need to change the name of the database, for example, a database might have been restored using a different name. Whatever the reason may be, this can be easily done via Management Studio or T-SQL.   1. Rename a Database using Management Studio: Step 1: Renaming Database: Right ...

  4. Awesome new features in SQL Server 2011 “Denali”: IIF and CHOOSE functions

    SQL Server 2011 “Denali” introduces two new features for flow control which may help you to keep your T-SQL cleaner than in previous versions. It is IIF and CHOOSE. These two function are very simple but it’s good to know they’re there.IIF Function Any developer should be ...

  5. Awesome new features in SQL Server 2011 “Denali”: IIF and CHOOSE functions

    SQL Server 2011 “Denali” introduces two new features for flow control which may help you to keep your T-SQL cleaner than in previous versions. It is IIF and CHOOSE. These two function are very simple but it’s good to know they’re there.IIF Function Any developer should be ...

  6. Run as Radio Podcast – A little Denali

    In this podcast on the uber-popular podcast “RunAs Radio”, host Richard Campbell asks me about what topics are of particular interest at Tech-Ed 2011, focusing the discussion on cloud and SQL Server “Denali” You can download the MP3 version of the podcast or the transcript here.

  7. Microsoft SQL Server Internals & Architecture Matter!

    EPIC FAIL! This was supposed to go out last week. But I didn’t schedule it properly, so I’d just like to point out that there are lots of other great webcasts to watch at the Pragmatic Works webcast URL below. Plus, my session will be available via streaming ...

  8. Microsoft SQL Server Internals & Architecture Matter!

    EPIC FAIL!  This was supposed to go out last week.  But I didn’t schedule it properly, so I’d just like to point out that there are lots of other great webcasts to watch at the Pragmatic Works webcast URL below.  Plus, my session will be available via streaming ...

  9. SQL Server Functions- An Introduction

    SQL FUNCTION: - Function in a database can be defined as the code segment consisting of a logical group of SQL statements which takes some input arguments (if required), run in a sequential order and returns the output either in the form of a single value or in the form ...

  10. TSQL Tip O’ the Week – 8/2/11 – Records Per Day

    This weeks tip: Often times I’ll need to count how many records are added to a table based on the date. To do this, I use the GROUP BY and the CONVERT function. The idea is to convert the datetime to just a date, then group and count the ...

Home

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