SQL Server Articles


Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

50 Tips to Boost Performance of an ASP.NET Application – Part 1

When we are looking to optimize the performance of  web applications we should keep in mind about Memory Load, Processor Load and Network Bandwidth. Here are 50  best practices to improve the performance and scalability of ASP.NET applications. 1. Page.IsPostBack Property Keep code which only needs to be loaded once inside an IsPostBack block. if(!IsPostBack) […]

Understanding WCF Hosting

 WCF is a flagship product from  Microsoft for developing distributed application using SOA. Prior to WCF   traditional ASMX Web services were hosted only on Internet Information Services (IIS). The hosting options for WCF services are significantly enhanced from Microsoft .NET Framework 3.0 onwards. In WCF there are three main parts: Service, Endpoints and Hosting Environment. […]

Using Analysis Services Processing Task & Analysis Services Execute DDL Task in SSIS

SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article Using WMI Data Reader and WMI Event Watcher Tasks in SSIS I discussed how to use the WMI Data Reader and WMI Event Watcher […]

Sonasoft Defaults on Payments. Directors – Andy Khanna , Dr Romesh K. Japra , W. Patrick Kelley Sr

Sonasoft, Directors – Andy Khanna ,  Dr Romesh K. Japra ,  W. Patrick Kelley Sr I haven’t written a notice like this before but I thought it was my duty to let you all know the situation regarding a former advertiser on SQL Server Performance.com . After ove 18 months of requesting payment of amounts […]

Using WMI Data Reader and WMI Event Watcher Tasks in SSIS

 SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article Using the Transfer Jobs Task in SQL Server Integration Services I discussed how to use the Transfer Job Task which is available in SQL […]

Auditing in SQL Server 2008

Introduction Auditing is the monitoring and recording all user actions on a database. You can base auditing on individual actions, such as database backup, change of user logins, insert etc. or on combination of factors. Why Audit? Though auditing has become a popular buzzword, many DBAs and developers still do not appreciate the requirement for […]

SQL Server Employment Trends

As a SQL Server Recruitment Consultant for Rullion Computer Personnel, I specialise in SQL Server and Database Professionals for a multitude of different clients throughout the UK. I am writing this article to give an honest reflection and hopefully cast a more positive light on the current economic situation, and reassure those candidates who are […]

Introduction to SQL Azure

Since the SQL Azure database services are in the cloud, you do not have to worry about high availability and scalability. SQL Azure will maintain a “Monthly Availability” of 99.9% during a calendar month. For example, you or your network administrators do not have to spend time on high availability which is taken care by […]

Writing Custom Rules for FxCop

Code review or monitoring inevitably becomes a part of our project’s life cycle. It’s a process which analyzes your code, helps to mitigate issues and reduce the percentage of bugs in testing by performing code cleaning. We can do the code review either manually or, preferably, automatically. In a big project reviewing code manually is […]

Tuning SQL Server 2005 Integration Services for EBCDIC Data Conversion

When searching the Web for solutions to use SQL Server 2005’s Integration Services to convert and load EBCDIC (IBM Mainframe) data, many will hit a massive roadblock. Through exhaustive searches you may be able to return a minimal amount of information, none of which will likely pertain to performance tuning once a conversion solution is […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |