Refactoring and static code analysis tool for SQL Server
Got a SQL Server or .NET question? Discuss it in the forums. (SQL Server Forums | Dot NET Forums)
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Jacob's Blog

Recent Blog Posts

Most Viewed

Archive

May 2009 - Posts

New XQuery functions introduced in SQL Server 2008: upper-case() and lower-case()

The XQuery implementation of SQL Server 2005 supported only a limited number of XQuery functions. SQL Server 2008 added support for two more XQuery functions: upper-case() and lower-case() Both these functions are pretty simple to understand and self...
by Jacob Sebastian on 05-27-2009 | 1,211 Views

How to drop a SQL Server database that is in use?

I am not sure how many times you might want to forcefully close all the active connections and drop a database. However, this is a very interesting question. One option to do this is to take the database in SINGLE USER mode and then issue a DROP DATABASE...
by Jacob Sebastian on 05-24-2009 | 696 Views

FILESTREAM is not a DATATYPE

I am exploring the FILESTREAM data type these days for my next book. So expect a number of blog posts on FILESTREAM in the next few weeks. Yes, I am back to SQL Server blogging after a short break. I would like to start with clarifying a common misunderstanding...
by Jacob Sebastian on 05-24-2009 | 310 Views

Tech-ED India 2009 – Day 3

Tech-ED India 2009 is over. It was a great experience meeting a lot of technology experts, product team and developers from all around the country. I met many readers of my blogs and articles and had a great time interacting with them. It was really interesting...
by Jacob Sebastian on 05-15-2009 | 296 Views

Tech-ED India 2009 – Day 2

Tech-ED is rocking and the second day was quite interesting. The day started with Keynote Session by Resul Pookutty (Oscar Award Winner – Film Sound Designer) Keynote Session by Resul Pookutty Resul gave a detailed overview of how technology is used in...
by Jacob Sebastian on 05-14-2009 | 260 Views

Tech-ED India 2009 – Day 1

For those of you who are eager to know what is happening with me and with Tech-ED in Hyderabad, here is a quick update. The main attraction of the day was the Keynote session by Microsoft CEO Steve Ballmer. Keynote Auditorium Keynote by Steve Ballmer...
by Jacob Sebastian on 05-13-2009 | 364 Views

Tech-Ed India 2009, beyondrelational.com and TSQL Challenges

Some of you must have noticed that I became a bit irregular in blogging for the past few months. I was busy working on a number of critical assignments and most of my free time was dedicated to building the new website www.beyondrelational.com (which...
by Jacob Sebastian on 05-05-2009 | 324 Views

Copyright © Beyondrelational.com