If have been working with SQL Server then you might already be familiar with a reporting service packaged with SQL Server, called SQL Server Reporting Service. Which basically allows user to create and host reports. Actually when you install SQL Server 2008, you are present with an option to install additional component called Business Intelligence
Category: SQL Server
Remote Debugging in SQL Server Management Studio …
If you are a developer you know very well that a good programmer is not someone who can write fancy code but someone who knows how/when/where to press F9-F10 no offence. And it is equivalently true for SQL Server as well. Front end used to manage SQL Server instance is called SQL Server Management Studio
IDENTITY key is not itself set to be Primary Key or Unique Key ??
If you have done any sort of development in database you might be familiar with IDENTITY column. It basically gives you a column which increments it self to a given value (aka Seed and Increment). General syntax for IDENTITY is, IDENTITY [ ( seed , increment ) ] It is basically a “Plan B” for
Handling NULL DATES in .NET and SQL Server
I think no matter how solid is your application development skills and application testing skills … the end users always find ways to make your application do things which it not suppose to do and so eventually it crash. Or worse, they can generate inconsistency in your database. Being both as application developer and a
SQL Server 2011 CTP is here !!
Well, I wouldn’t believed it when I read it on few of my favorite sites like SSC and SQLBlogs … but it is actually here !! MSFT has released CTP for next version of SQL Server Code name “Denali”. From initial reading it looks like the next generation of SQL Server will have more enterprise
Access to SQL Server migration … and Compatibility Issues !!
Recently I was involved in a migration project. Client was/is using ancient application built on Access 2.0 (yup … its 2.0) … I think it was started as a small app for just couple of users and with time it grew larger and soon it became mission critical application which still is built on old
SQL Server Views … gotcha while using sp_refreshview
Last week I blogged about use of Views in SQL Server. We also saw different types of view and best practices for designing new view and limitations that may prevent us creating a view too. As a part of best practice while designing we should always include keyword, WITH SCHEMABINDING which prevents any accidental changes