Blog » Entries from 5/27/2009
I’m still barely scratching the surface working with spatial data in SQL Server 2008. We’ve ported some of the data into a table where we built a geography spatial data column and we’re begginning to work with point data. The requirements from the developers are, so far ...
Well, at least that is the impression I have from Operations Manager. Let me explain why.
It all started around the time we were making some adjustments to one of our servers that was not performing as well as our end users would have liked. The short end of that ...
Today at work we discovered that DATEADD can do date math involving quarters. Which, if you ask me, is pretty cool.
In an effort to
avoid workinvestigate this scenario, we started playing around with our calendar table and DATEADD.
SELECT [DATE], DATEADD(q, -1, [DATE]) AS OneQuarterAgo, DATEDIFF(d ...
Using the Timeout connection string property is a good way of making sure that your queries don’t run for too long, but sometimes – for example when you’re using SSRS – you want to restrict the amount of data that a query returns. You can’t properly do this with ...
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 at
.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.