Pulse » Popular Items from 3/2012

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.

2012

  1. J199
  2. F165
  3. M182
  4. A154
  5. M120
  6. J188
  7. J223
  8. A165
  9. S114
  10. O173
  11. N158
  12. D107

March

  1. 15
  2. 27
  3. 31
  4. 44
  5. 57
  6. 612
  7. 710
  8. 86
  9. 99
  10. 102
  11. 113
  12. 129
  13. 138
  14. 149
  15. 1512
  16. 165
  17. 173
  18. 181
  19. 197
  20. 205
  21. 217
  22. 227
  23. 235
  24. 242
  25. 253
  26. 2611
  27. 274
  28. 287
  29. 297
  30. 303
  31. 311
Home

  1. Managing Data Sources in a PowerPivot Gallery

    Overview: A quick tip about how to manage data source connections within a SharePoint PowerPivot Gallery. Level: 101 The PowerPivot Gallery The PowerPivot Gallery is a specific type of SharePoint document library, intended for storing & sharing PowerPivot workbooks as well as BISM connections to tabular models. The PowerPivot Gallery ...

  2. March Madness – SQL Azure – sys.dm_exec_query_stats

    Yesterday we saw how to view the query plan for the statements hitting your SQL Azure instance. Looking at the statement and the plan itself is good, but it does not give you a complete picture for performance tuning. For that you will need some historical context. One way to ...

  3. SQL Server Upgrade error: It is not possible to change the SQL Server features to be upgraded in this release. Validation errors. There are no features selected for upgrade.

    On a recent project I was asked to “upgrade” a licensed SQL Server 2008R2 Standard Edition to SQL Server 2008R2 Enterprise Edition. I have done this multiple times with no issues. The “kicker” was that the upgrade required a 48-hour turnaround time but no installation media for SQL Server Enterprise ...

  4. Evolution of T-SQL between SQL 2005 & 2008 versions

    Ever wondered what has changed under the hood between versions of Microsoft SQL Server? Well, then this post is for you! What’s new in SQL 2008 Programmability Enhancements (Database Engine) What got deprecated in SQL 2008 Deprecated Database Engine Features in SQL Server 2008 What was discontinued in SQL ...

  5. Querying Microsoft SQL Server 2012 (71-461) Afterthoughts and Study Notes

    I have just finished the first of the Microsoft SQL Server 2012 Beta exams, Querying Microsoft SQL Server 2012 (71-461). I took them for a couple of different reasons, I feel that certifications are important and it was an opportunity for me to upgrade my current certifications. My thoughts after ...

  6. Using Rank function to get newest (or oldest) record from related records.

    I'm slow in applying the new SQL Server functions. Recently I ran into a request where I needed to pull the newest record for a related table several joins deep. I finally decided to dig into and use the new rank function to do it. It resulted in a ...

  7. Caveats of a CONTROL SERVER permission

    Today morning I was working on one of the server to complete the regular documentation of security audit with details of logins with sysadmin rights and their access to various database. Later I have realized that, one login has access to all database but it is not captured by my ...

  8. Utilizing SQL CMD Variables in Transactional Replication

    In some situations it maybe necessary to use SQL CMD variables while executing scripts. This happens when utilizing a replication process I have. To start off with I must iterate that to use SQL CMD variables you have to have the setting actually turned on in SSMS. The enabling is ...

  9. SQL Server Replication and DR

    Every once and a while people ask me if they should use SQL Server Replication to get data to a DR site. And typically to them my answer is “probably not”. The reason that I say that is for a couple of reasons. 1. If there are triggers on your ...

  10. Importing data from Excel – using INSERT statements

    You can easily import data from an Excel file to SQL Server using SQL Server Import and Export Wizard. However, when the data is simple and limited I avoid using it (too lazy to click through 6 screens… ) instead I generate INSERT statements using CONCATENATE function in Excel and ...

Home

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