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

February

  1. 15
  2. 211
  3. 38
  4. 42
  5. 50
  6. 67
  7. 77
  8. 86
  9. 95
  10. 104
  11. 113
  12. 121
  13. 135
  14. 1411
  15. 159
  16. 1611
  17. 177
  18. 181
  19. 192
  20. 208
  21. 2113
  22. 226
  23. 233
  24. 243
  25. 251
  26. 262
  27. 2710
  28. 288
  29. 296
Home

  1. PASS Volunteer Appreciation

    Do you know someone in the PASS Community who is a hidden hero? Perhaps a chapter leader who is doing terrific work to help the SQL community. Maybe its a member who is putting in 110% to organize a SQL Rally. A virtual chapter leader who is organizing great sessions ...

  2. Monday Morning Mistakes: Not Setting Memory Limits

    Welcome back to another addition of Monday Morning Mistakes series. Today’s issue is one I tend to run into quite often with clients and is an important topic to know about as a database administrator. Without further ado, let’s get to our issue Issue You have SQL Server ...

  3. SQL Server Agent Job Steps

    To list a SQL Server Agent Job Steps use the T-SQL example below. This example displays the step id, SQL Server Agent Job name, Step name. The code has 1 input parameter - @job_name DECLARE @job_name VARCHAR(128) SET @job_name = 'My SQL Server Agent Job' SELECT js.step_id ,j.name,js ...

  4. What’s Stopping You – from Snooping?

    No, this isn’t a touchy-feely inspirational post that talks you into taking leaps and bounds in your career. I write those every now and then, but that ain’t today. Instead, today’s post is about a question: what’s stopping you from snooping in your company’s data ...

  5. I Was Kidding Myself

    Do you know who Vizzini is? He’s a character from the Princess Bride story (I loved the book and if you want to read it, I would highly recommend the hard-to-find unabridged version). Most people know Vizzini from the movie. He’s this guy: For those who haven’t ...

  6. Using views in the a tabular model

    It is very handy to views as the table source definition in the the tabular model. The biggest advantage for using views – the columns can be renamed in the underlying data source without breaking your tabular model. If that’s not enough to convince you use views, here are a ...

  7. Learn Mirroring with me at SQLRally

    I just found out that I will be speaking at SQLRally Dallas in May. I submitted 3 sessions. As an event organizer, all 3 automatically went to community vote. I am very excited that my Mirroring session was voted in. Thank you to everyone who voted for me!Mirroring Start ...

  8. End-User Microsoft BI Tools – Clearing up the confusion

    Given two types of underlying data sources (a data warehouse and a OLAP cube built from the data warehouse) there are many different possible presentation layers (client tools) that serve different user communities with varying usage profiles. There is a lot of confusion on what is the best tool to ...

  9. Scripts for Backup and Restore

    Someone posed this question: How do you generate scripts for backing up all the databases on ServerA and restoring them on ServerB?BACKING UPGenerating the backup script is easy:SELECT 'BACKUP DATABASE [' + Name + '] TO DISK = ''D:\Backup\' + name + '.bak'''FROM sys.databasesORDER BY nameOr, refer to a post ...

  10. Building a new CoLo - Part 1 of n

    So if you follow me on twitter you might have seen this tweet a little while back. Since there aren’t many people out there that get the chance to buy and build a brand new data center from scratch, I figured that I’d go over the process with ...

Home

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