by Rahul Singla | Mar 16, 2012 | Blog, Sql Server, Sql Server 2005, Sql Server 2008
In one of our Enterprise web application, we rely on Sql Server’s Service Broker backed Query Notification feature a lot. Basically the database of that application is exposed to many other client-specific apps, and our app needs to respond to changes being made...
by Rahul Singla | Jan 20, 2012 | Blog, Sql Server
I am in the process of revamping server setups for my office as a part of which I am establishing different Windows servers for Sql Server Developer 2008, Sql Server Express and Svn Server. Considering that I often work late nights from my home as well as when I am...
by Rahul Singla | Jul 31, 2011 | Blog, Sql Server
This week 2-3 days back, I got a really strange Sql Server error when browsing to one of my ASP.NET applications in the brower on my development server. As soon as I opened the app, the following error greeted me: M8ZWJBN5J8RV The log for database...
by Rahul Singla | Dec 19, 2010 | Blog, Sql Server
Performing database side paging has always been a headache in Sql Server (as opposed to MySql which provides a built-in LIMIT clause for easy paging). However, I recently found an easy, fast and intuitive way of paging the data on the database side in Sql Server...
by Rahul Singla | Nov 30, 2010 | Blog, Sql Server
You would find some useful links on web, if you search with the title of this blog post. Basically you cannot pass parameters to a Trigger because Triggers get fired automatically by the database engine, and you do not interact with them directly as they...
by Rahul Singla | Oct 29, 2010 | Blog, Sql Server
The title sounds like related to a logging operation, isn’t it? Well yes, it is.In an existing logging operation, I needed to ensure that the number of log entries remained below a specified threshhold. And I came up with the following sql quickly: DECLARE...
Recent Comments