Blog

A journey through technology obsession :)
All Stories in Tag: 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


Fix: Login failed for user IFC\WIN5177$ in ASP.NET MVC

Here is the fix for error : Login-failed-for-user-IFC\WIN5177$, while trying to connect to SQL Server database from ASP.NET MVC project.



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 


List of Microsoft free ebook collections

Are you a Geek targeting Microsoft Technology Stack, then checkout below links, which contains the largest collection of free Microsoft e-books including Windows Phone, Windows 8, Office, Sharepoint,


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,



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


Build database connectionstring easily

No doubt! This article belongs to stone-age era. There is a reason why I walk to the same ancestor era. Last few week, I’s interviewing techies for the post of .net developer. Before that; I always