Blog » Entries from 12/2010
-
SQL Server failed to communicate with Full-Text Service
Here is one of the forum questions I responded to yesterday. When executing a query using FREETEXT, the following error message was displayed.

Since the error message mentions about permissions of the service account, it was checked. The Service Account had sufficient privileges. This TechNet article clearly mentions the root ...
-
Can You Dig It? – StmtSimple Element

- She can dig it!
D Sharon Pruitt
We’re up to the seventh post on the in the plan cache series. This time we’ll be talking about the last of the possible children for the Statements elements – the StmtSimple element. StmtSimple, commonly referred to as statement simple, can contain ...
-
First SQLSaturday in Wheeling, West Virginia was a Success!
After SQL Saturday #36 on May 1st 2010 my wife and I headed to Spain. Somehow this post got lost in the shuffle when I got back. I thought it is important to share my thoughts of the event so here it is.
The first SQLSaturday in West Virginia can ...
-
Video: Interview – Part 1: Quest Software
Heather Eichman interviews Kevin Kline, the former President of PASS and strategy manager for the SQL Server business unit at Quest Software.
Posted January 24, 2008.
-
We are currently running on an EMC SAN. Did I hear you correctly, we should have databases, backups, temp, and logs on the same LUN? Thanks.
No, you want to put them on different LUNs. IBM is currently recommending that on the XIV array that everything can be put on a single LUN as the LUN is spread over all the disks in the array. For an EMC array you’ll want to have separate LUNs ...
-
Sixth Blog Birthday
Every year on December 30th (or thereabouts) I write a blog post summarising what I’ve been up to this year, to mark this blog’s birthday. Today is my blog’s sixth birthday which, to be honest, I find pretty amazing – but then every year I’m amazed at ...
-
SELECT * FROM SQLBLOGGERS WHERE LOCATION = ‘UK’
I published a post yesterday where I listed my top 5 bloggers from the worldwide SQL community for 2010. The long and short of it, these were the people whose blog’s I had read the most throughout the year. There are many other great blogs and bloggers out there ... -
Enhancing your SQL Server backups with additional information
For a more complete backup and recovery strategy, there are some additional items you can save off alongside your user database backups that can potentially save a lot of time and effort in a restore scenario. These can also be helpful to have on hand for archival or historical comparison ... -
Open Invitation: Atlanta SQL Server Writer’s Workshop
The Short & Sweet:
WHAT: Atlanta SQL Server Writer’s Workshop
WHO: Anyone who writes, presents, or is thinking of getting started in either
WHEN: Thursday, January 6, beginning at 6:30 PM (First Thursday of the month going forward)
WHERE: 12000 Findley Rd, Ste 150, John’s Creek, GA 30097 ... -
Finding Gaps, For Real..
In a previous post I outlined how to find gaps in number using both a common table expression and a sub query. This was incomplete and misleading to say the least, In my business we refer to it as an “AD”, accidental discharge. To present a functional solution the below ...
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.
