1. Home
  2. Blog
Feb 13/2014

How to solve identity problem in SQL 2012

Microsoft changed the Identity behavior to jump in increment of 1000 or 10000 whenever the SQL Server 2012 restart. For example: we have a Primary Key that was 10012, if you re-start the SQL server instant, then in the next Insert record you will get the Primary Key as 11012.
Jan 23/2014

How to disable User Account Control in Windows Server 2012

Running any program and dealing with the UAC could be a hassle and that process also evaluates if the user has the rights to proceed with the program any further. If you need to remove the below UAC and save you the additional click then follow some basic steps to accomplish just that.
Dec 13/2013

SQL Consulting

We are experts at SQL Server database administration, performance tuning and database optimization to maximize your company's productivity. In our team we have MS SQL MVP consultant and our highest experience person has 26 years of database solutions. We are located in central NJ and provide MS SQL consulting solutions all over the USA.
Apr 02/2013

Optimize your sql query for best search result

When developing solutions that require querying large amount of data, you may want to consider user Stored Procedures. When accessing multiple "query patterns", you want to program your system to use the most efficient algorithm to return your data to the user. While using dynamic SQL may work for small databases, a preferred method would be to use a Stored Procedure to optimize performance.

Categories

Recent Posts

Popular Tags

Custom Software Development SQL consulting Alpha Anywhere developer Remote DBA Alpha Five Developers Convert Access to Web MS Access Developers Dot Net Developers MS SQL Remote DBA Remote database administration

Develop different CAD Programs and Different Management Software

Develop MS Access Application to this Chemical Company.

Develop Accounting Modules for the accounting department

Develop Buying Power Membership Software to reduce the buying cost

Student Loan Management - No interest Loan Management at glance:

Car Rental Software - Contract manager for the Avis Car Rental Company. It has 30 different locations in North NJ USA.

Case Management Software to Manage the Law Firm Cases

Develop Inventory Control System for an Order Fulfillment Center

Develop a Search Engine and Inventory Control System for Truck Parts Distributor