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. M42
  2. A108
  3. M139
  4. F142
  5. J192
  6. D161
  7. N106
  8. O228
  9. S358
  10. A976
  11. J1k
  12. J882
  13. M242
  14. A226
  15. M4k
  16. F18k
  17. J22k
  18. D16k
  19. N15k
  20. O22k
  21. S18k
  22. A17k
  23. J16k
  24. J19k
  25. M20k
  26. A21k
  27. M18k
  28. F4k
  29. J218
  30. D139
  31. N179
  32. O228
  33. S345
  34. A151
  35. J132
Home

  1. Workspace database server was not found

    You might constantly see a warning message that appears like the one below when creating Analysis Services Tabular projects. It basically says, workspace database server ‘ServerName’ was not found. You’ll have to change this setting from the model properties. The server should be an Analysis Services Server running in ...

  2. Troubleshooting Database mail

    Last week we blogged about “How to configure Database mail” – this week we’ll have a closer look at what to do when everything looks fine, but no mail is flying through the system – what is wrong?. After testing, if you are unable to receive notification emails, you could ...

  3. Why is my SSAS Query Log Table Empty?

    Overview: Just a quick tip re: resolving an issue with getting SSAS the query logging table populated. Level: 101 Enabling the SSAS Query Log In Management Studio, if you right-click the SSAS Server instance, you are presented with Analysis Server properties. Here is where you tell SSAS to log queries ...

  4. 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 ...

  5. CREATE INDEX and STATISTICS_NORECOMPUTE

    Question : When a CREATE INDEX is executed on an existing table with rows in it, is it required to execute a UPDATE STATISTICS or will CREATE INDEX update the stats? Does the STATISTICS_NORECOMPUTE effect whether statistics are updated on a INDEX rebuild? Answer: The STATISTICS_NORECOMPUTE setting doesn’t determine whether ...

  6. Are You Using the Right SQL Server Performance Metrics?

    No matter what our profession, we all have our favorite set of tools to help us get the job done. Database Administrators will have a set of scripts that we use in order to gain insight into the server instances under our care. I often see beginner DBAs look to ...

  7. OneNote 2010 Sort Utility

    These days, I live and die by OneNote. I read a ton of technical blogs and come across a number of great scripts and when I do, I save them to OneNote. I take notes from meetings in OneNote and I even save videos and webcasts that I feel are ...

  8. SSDT – Installation confusion

    SQL Server Data Tools (SSDT) is a Business Intelligence Development Studio (BIDS) replacement, meaning it has a suite of Visual Studio 2010 add-in tools for building Integration Services (SSIS), Analysis Services (SSAS) & Reporting Services (SSRS) solutions (let’s call that suite SSDT-BIDS). It is also a suite of Visual Studio ...

  9. Are you a fit DBA?

    Over my career I have seen many articles on what it takes to be a DBA. I always enjoy reading other viewpoints on the topic; so much so I’ve wanted to share my mentality on how I attack being a DBA. Every person is different and unique in their ...

  10. April 2012 – Monthly SQL Server Checklist

    Another month goes by and it’s time again to ask… are your SQL Servers healthy? Have they been properly configured? Is your SQL Server patching up to date? You should know. And if you don’t you should make it your business to find out. At the end of ...

Home

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