SQL Server 2005 vs SQL Server 2008 Overview: Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query languages are MS-SQL and T-SQL.Below is the Release History for SQL server:VersionYearRelease NameCodename1.0 (OS/2)1989SQL Server 1.0-4.21 (WinNT)1993SQL Server 4.21-6.01995SQL Server 6.0SQL956.51996SQL Server 6.5Hydra7.01998SQL Server 7.0Sphinx-1999SQL Server 7.0OLAP ToolsPlato8.02000SQL...

Read more »

Resource Governor in SQL Server 2008  SQL Server 2008 introduces a new feature called Resource Governor which enables Database Administrators to manage SQL Server workload and critical system resource consumption. Resource Governor enables DBA to specify limits on the amount of CPU and memory which the incoming sessions to the SQL Server can use. In a production environment DBA's will come across scenarios when there could be...

Read more »

Shortcuts – Prakash Chheatry (December 20, 2010)

 SQL Query Analyzer Hotkeys - Keyboard Shortcuts CTRL-SHIFT-F2         Clear all bookmarks. CTRL+F2                   Insert or remove a bookmark (toggle). F2                        Move...

Read more »

OverviewThe release of Windows 7, the latest Microsoft operating system, is an opportunity for engineers and scientists to harness new technologies to solve technical problems. Like the predecessor, Windows Vista, users can select between a version for 32-bit processors and a version for 64-bit processors. Whether porting a system to a new version of Windows, or starting new development on the OS, it is important to understand which version best...

Read more »

The difference between 64 and 32 bit processorsPrakash Chheatry - Monday, December 20, 2010In the future, the battle between 64 bit vs 32 bit processors will inevitably yield the 64 bit processor as the victor, but this transition is going to take some time. First, I'll talk about the pure mathematics and structure of the processors that are involved here. I'll keep this part short and sweet.   A bit is short for "binary digit." It is basically...

Read more »

Change Data CaptureAs we are looking through the new features in SQL Server 2008 we found a potentially interesting one called Change Data Capture.  Can you give us a detailed explanation of how we go about using this one?SolutionChange Data Capture is a new feature in SQL Server 2008 that records insert, update and delete activity in SQL Server tables.  A good example of how this feature can be used is in performing periodic updates to...

Read more »