Pulse » Popular Items

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.

  1. F107
  2. J182
  3. D156
  4. N102
  5. O225
  6. S352
  7. A975
  8. J1k
  9. J882
  10. M242
  11. A226
  12. M4k
  13. F18k
  14. J22k
  15. D16k
  16. N15k
  17. O22k
  18. S18k
  19. A17k
  20. J16k
  21. J19k
  22. M20k
  23. A21k
  24. M18k
  25. F4k
  26. J217
  27. D139
  28. N179
  29. O228
  30. S344
  31. A150
  32. J132
  33. J170
  34. M161
  35. A221
Home

  1. Be careful with two digit years

    I recently had a scary conversation with a user, which can be broken down to: User: Why would the data have customers with a birth date of MM/DD/2020? Me: What are you talking about? Lemme take a look. Me again, this time with a changed voice: Umm, Umm ...

  2. PASS Summit Tips and Tricks

    Wanna learn where to go after hours? What to take with you during the day? What to say to presenters? It’s all here in this week’s Technology Triage Tuesday webcast: ...Free webcasts coming up: running SQL Server in the cloud, designing smarter indexes, and PASS Summit tips. Register ...

  3. What is the best Disaster Recovery Plan (DRP)?

    I am really surprised at how often that I see questions like this. I have been answering a few questions on a few different forums and I see this more and more often. Here is the quick answer: I don’t know. There really is no way to find the ...

  4. The Minimalist Guide to Database Administration

    Every great DBA I know is both driven AND lazy. They are driven to be as efficient as possible, so they can do less work. It’s a wonderful pair of personality traits to have as a DBA. The unfortunate part is that the more driven they are, the more ...

  5. Don’t Splint Your Database Server To Death

    A trauma patient can be “splinted to death.” So can a database server. It happens during at least one ambulance call each year and I’m sure it happens in many more data or network operation centers each year, too. This post is my attempt to start back up with ...

  6. SQL Server 2012 (“Denali”): T-SQL Enhancements

    SQL Server 2012 has a number of new T-SQL features. Listed below are all of the new features, along with the best links I have found that describe each feature: WITH RESULT SETS, OFFSET AND FETCH, THROW, SEQUENCE: See New T-SQL Features in SQL Server 2012 and SQL Server 2012-DENALI-whats ...

  7. SQL Server – Moving table with LOB data to different file group

    Last week, i posted about moving tables to different file groups by recreating indexes. However, this method does not *work* when there is LOB data involved. When we recreate indexes on a table containing LOB data, the LOB data pages are not moved to destination file group. This can be ...

  8. I Made You a Cheatsheet of Cool Things! #sqlpass

    I made you something wonderful. It’s a cheatsheet for the PASS Summit, which has info about us (of course), about PASS, some helpful tips, and best of all a list of cool things happening at this year’s PASS Summit. Choose your print-your-own flavor, or come and see me ...

  9. What is a Microsoft Regional Director?

    First off, they don’t work for Microsoft. A Microsoft Regional Director (RD) is an unbiased third-party evangelist of Microsoft products and services. Regional Directors are members of an elite, worldwide group of technology thought-leaders known for their national and international speaking tours, their authorship of books, articles and blogs ...

  10. SSIS Lookup Cache Connection Manager with Excel

    The lookup transform in SSIS 2008 gives you the ability to join data and eliminate non matching rows. One of the limitations of the lookup is the fact it requires an OLEDB connection. However, with the cache connection manager you can use just about any other data source as your ...

Home

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