Blog » Entries from 1/26/2009
Sometimes when I am working with clients I need to take a look at execution plans for different stored procedures. Rather than digging around with SQL Profiler or executing the stored procedures with what I think might be the parameters I like to '”return to the source”.
Now I feel ...
So this past weekend I got myself an xbox 360 so that I could hook into my Netflix to watch movies instantly. At the same time I decided to ditch my TiVo as well as my old DVD player. So, a consolidation of sorts in terms of hardware, remotes, and ...
We've now closed session submission for SQLBits IV, which will be taking place on March 28th in Manchester. Once again we've had a great response and it's now time to vote for which of the 83 submitted sessions you'd like to see; to do this you ...
I have to run similar code on a regular basis, so I thought I would share it with everyone.
Basically, it grants access on every stored procedure that meets a certain naming pattern to a single user.
-- I've updated this with Aaron Bertrand's suggestions from the comments. -- Thanks ...
In SQL 2005 a COPY_ONLY option became available for backing up your databases. What COPY_ONLY does is take a backup (full or t-log) without affecting the backup/restore cycle. This is a great new feature as quite often DBAs are asked for an out of sequence backup to be taken ...
Apress has a new program called Alpha where they make available books in progress. You can download, for a price, an e-copy of some of the chapters of the book for early review. It allows you to get in on the action a bit and you can post comments to ...
Let’s suppose for a minute that you want to retrieve the top x number of rows from any given query. Keep in mind that x is a value that your users can supply.
Sure, you could do string concatenation and EXEC sp_executesql ‘SELECT TOP ‘ + @count + ‘ x FROM y;’. But ...
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.