Blog » Entries from 7/2012

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

July

  1. 13
  2. 214
  3. 310
  4. 45
  5. 57
  6. 610
  7. 75
  8. 81
  9. 911
  10. 1013
  11. 118
  12. 1210
  13. 136
  14. 142
  15. 152
  16. 1611
  17. 179
  18. 187
  19. 198
  20. 206
  21. 212
  22. 225
  23. 2313
  24. 2410
  25. 256
  26. 268
  27. 274
  28. 283
  29. 294
  30. 3011
  31. 319
Home

  1. Keep Calm and Recover with Backups

    It’s going on midnight here so I wanted to share some advice I have for anyone on the overnight shift: You *do* have backups, right? Keep Calm and Recover with Backups is a post from: SQLRockstar | Thomas LaRock

  2. Unattended (Silent) SQL Server Installations

    As promised from my last post, Relocating SQL Server System Databases without Access to the Instance, today I will be blogging about ‘unattended’ or ‘silent’ installations of SQL Server. I will be discussing the concept and uses of the unattended installation and then I will provide detailed explanation of my ...

  3. Use Powershell import-csv to enumerate list items from a CSV array

    Question: I have a csv file with two columns. Both columns have headers , with values under both columns , with a comma delimiter. An example of the list is : Musician,Instrument Prince,Guitar... Click title to read full article

  4. Come See Me. I’ll Probably Be Just Down the Street Soon!

    Even though I’ve recently changed jobs, I’ll still be speaking at a lot of SQL events across the country and internationally.  There are still a few trips that I’ve yet to finalize, in particular with the fine folks in Houston, run by my friend Nancy Hidy (blog ...

  5. Bad business practices damage your company, KRG Technology

    I just composed and sent this message to eleven members of a single California-based recruitment company. I’ll let the email speak for itself, but you, dear reader, should also know that the positions they reference range from Business Objects to Android programming, with nary a DB job in sight ...

  6. Reading Excel into SSIS via OpenXML Scripting

    Reading Excel data isn't easy.  It should be, but there's a lot of unfortunate barriers in the way that I've discussed before.  They boil down to one main reason: Excel wasn't created for IT, it was created for business users.  We're quite obviously an afterthought ...

  7. SQL Audit 201 – Creating an Audit Solution

    Welcome back, folks! Ok so, now that we’ve covered the basics of creating a SQL Audit and viewing the output, let’s put the pieces together to form a complete solution. As with any implementation, the key to success lies in careful planning. Before we take off running, we ...

  8. Using the WebService() function in Excel 2013

    One thing that piqued my interest when looking over the new functions in Excel 2013 were the new functions available that allow you to retrieve data from a web service directly into worksheet: EncodeURL(), Webservice and FilterXML(). Here’s a brief demo of how to use them. First, find a ...

  9. Alerts with More than E-Mail

    One of the things I love about this community is that you’re always being pushed to learn new things. And when I present, someone always asks a question or raises a point that makes me figure out something I didn’t know. One of the pieces of feedback I ...

  10. Do your backups run at the right time?

    Many articles on database backups reference running database backups and maintenance processes overnight. In lots of situations this is a great idea, especially if you’re dealing with a transactional system that has users connecting to the database during the day and minimal activity outside of business hours. But for ...
Home

Get Syndicated on SQLServerPedia

Have you been blogging for six months or more? Want to see your own posts here on SQLServerPedia too? Follow these easy steps to increase your visibility in the community and attract more visitors to your blog.

  1. Create a Blog Category for Syndicated Posts

    Using your blogging software, create a new category for posts that should be syndicated on SQLServerPedia and add a few posts to it. (This allows you to keep off-topic posts from being syndicated.)

  2. Find the URL to Your Syndicated Posts Feed

    Most major blogging platforms will create a RSS or Atom feed for each category you create. On WordPress blogs, the feed can be accessed by appending /feed/ to the category page URL. On Blogger blogs, the feed for a label is at http://<yourname>.blogspot.com/feeds/posts/default/-/<categoryname>.

  3. Email Us with Your Feed URL, a Picture, and a Bio

    Once you're ready to set up syndication, send us an email introducing yourself. Include the URL to your feed, a headshot of yourself, and a short professional bio.