Blog » Entries from 2/2012
-
A Great Lineup of Sessions at SQL Rally 2012
SQL Rally 2012, in Dallas, is coming up in May. I am honored (and simply shocked) to have two sessions in the lineup. Both were community picks – how amazing is that? A huge thanks for everyone who voted. And, a big thanks to the organizers who I’d imagine are ... -
Top 3 Things You Should Learn In SQL 2012
I know three areas of SQL 2012 that have bright future, and learning these three will serve you well for years to come. I am at the MVP Summit this week and I am soaking up as much information about these three items as I possibly can. 2012 is a ... -
Script SQL Server Agent Jobs Using PowerShell
As many of you already know, I’m a big fan of Automating Everything and so I’ve been learning to use PowerShell with SQL Server. Interested to know what other DBAs are using PowerShell for, I reached out to the Twitterverse for insight. @JohnSansom I use #powershell for #configuration ... -
Dynamic Management View Extravaganza
It was at the PASS Summit 2011 this year as I sat in a session being presented by Jason Strate on extended events that I made a mental note…….why the heck aren’t you utilizing the DMV’s as much as I could be. Then last week I am ... -
Write a Variable To a File Using SSIS
Problem I’ve a SSIS package. When it fails execution, I want to write a custom message including the package name and error description to a text file. Solution One way to accomplish this is to declare a variable, populate it with the message you want, and write it’s ... -
SQL SERVER – Function: Is Function – SQL in Sixty Seconds #004 – Video
Today is February 29th. An unique date which we only get to observe once every four year. Year 2012 is leap year and SQL Server 2012 is also releasing this year. Yesterday I wrote an article where we have seen observed how using four different function we can create another ... -
How’s Microsoft doing with community involvement?
I’m at the Microsoft MVP Summit in Bellevue, WA this week (and having a simply lovely time, thanks for asking!) MS Community Program Manager Jen Lussier tweeted: Looking 4 MVPs in Redmond 2 talk about how MS employees can engage better in the community. Game? DM me #MVPsummit #MVPsummit2012 ... -
Natural and Unnatural Hierarchies in the SSAS 2012 Tabular Model
I’m sure you’re all aware of the difference between natural and unnatural user hierarchies in the Analysis Services Multidimensional model (if you’re confused as to what I mean when I say ‘Multidimensional model’, have a quick read of this post from a few weeks ago which explains ... -
Stuff in the FROM clause: Temporary & Semi-Temporary structures
So way back in October, I started a blog series on Stuff in the FROM clause; I never finished it. I’m trying to return to writing, so I thought it would be best if I completed the remaining two posts (so I can tick one more item off my ... -
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 ...
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.
-
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.)
-
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 athttp://<yourname>..blogspot.com/ feeds/ posts/ default/-/ <categoryname> -
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.