SQL SERVER – Top 10 SQL Server 2008 Features for Independent Software Vendor Applications

Microsoft SQL Server 2008 has hundreds of new and improved features, many of which are specifically designed for large scale independent software vendor (ISV) applications, which need to leverage the power of the underlying database while keeping their code database agnostic. This article presents details of the top 10 features that we believe are most applicable to such applications based on our work with strategic ISV partners. Along with the description of each feature, the main pain-points the feature helps resolve and some of the important limitations that need to be considered are also presented.

Read More

SQLAuthority News – SQL Server White Paper: SQL Server 2008 Compliance Guide

Note: Download White Paper by Microsoft Organizations across the globe are being inundated with regulatory requirements. They also have a strong need to better manage their IT systems to ensure they are operating efficiently and staying secure. Microsoft is often asked to provide guidance and technology to assist organizations struggling…
Read More

SQLAuthority News – TOP Downloads – Bookmark

Recently I have gotten many, many requests for SQL Server Interview Questions and Answers as well as related articles. It seems many people are looking for Job or appearing for an interview at this time of the year. I have included lists of the my top downloads in the sidebar of the blog, still I receive many curious questions as side bar does not show up in the RSS feed.

Read More

SQL SERVER – Introduction to CLR – Simple Example of CLR Stored Procedure

CLR is abbreviation of Common Language Runtime. In SQL Server 2005 and later version of it database objects can be created which are created in CLR. Stored Procedures, Functions, Triggers can be coded in CLR. CLR is faster than T-SQL in many cases. CLR is mainly used to accomplish task…
Read More

SQLAuthority News – SQL Server 2008 – Microsoft Certifications for 70-432 70-433 70-450 70-452

I have received many emails requesting information about SQL Server certifications examples. Microsoft has released new set of exams for SQL Server 2008 certifications. I am listing them here for quick reference. Exam 70-432 – TS: Microsoft SQL Server 2008, Implementation and Maintenance Installing and Configuring SQL Server 2008 (10…
Read More

SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported – VS SP1 ISO Download

I previously wrote article SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported where I discussed how downloading Visual Studio SP1 will fix the error of Visual Studio 2008 connecting to SQL Server 2008. I have provided link to SP1 which…
Read More
Menu
Exit mobile version