Blog

A journey through technology obsession :)
All Stories in Category: SQL Server

Paging re-imagined in SQL Server

How easy can you implement paging in SQL Server? Here is how you can achieve it.


Populate dummy records in SQL Server

Here is a quick script to generate dummy records in SQL Server


Sql Server–Saving changes is not permitted, from Design View

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the 



Sql Server – Drop all tables and stored procedure

For last few days, I’s makings come changes to one of the website that I have hosted recently. Since, it’s dynamic website, yes, it contains dozens of tables and stored procedures. As part of testing,


cannot load file or assembly microsoft.sqlserver.management.sdk.sfc

All of a sudden, my SQLDataSource connection failed with an error: "Could not load file or assembly ‘Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral,


Bulk Insert/Update/Delete in Sql Server

Handling data operation, like Insert/Update/Delete in Bulk, is always a crucial thing for a developer, when dealing with performance and less-codes. For example, inserting 100 records together into



Warning: ‘Saving changes is not permitted’ in Sql Server 2008

Recently, I installed the new build in of Sql Server 2008 R2. Using the Management Studio, I created and saved a Table in the Design View. Later on, I added a couple of columns to the same Table and