SQL Server Articles


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

Installing Windows Server Backup

Despite Windows Server Backup being listed in Administrative Tools, the Windows Server Backup feature will still need to be installed, this article demonstrates how.

Monitoring CPU Usage in Windows Server

This article demonstrates how to monitor the processor usage on a Windows Server installation.

Using SSL Authentication for SharePoint Sites

Demonstrates how to use SSL to improve your SharePoint site’s security.

Monitor Windows Server System Memory and Pagefile Usage

Available memory is usually the most common source for performance issues on a Windows Server installation. Fortunately, however, it is an easy metric to measure since there are several counters in the memory object which can help troubleshoot memory issues.

SQL Azure Performance – Query Optimization

SQL Azure Performance Tuning is a much tougher task than SQL Server since SQL Azure lacks some of the basic tools available to SQL Server DBA’s

ERROR_PROCEDURE does not return a schema name

A recent blog entry I read reminded me again that I wanted to rant about an issue in SQL Server for quite some time now… SQL Server 2005 introduced the separation between user and schema. Though schemata already existed  before SQL Server 2005, they really became usable with this version, imho. At the same time  […]

SharePoint Performance Tuning – Resource Throttling

First introduced with SharePoint 2010, Resource Throttling allows the farm administrator to control the overall performance of a SharePoint farm.

Protect Your ASP.NET App From SQL Parameter Injection

Securing your ASP.NET web app from SQL Injection attacks paramount in the design of any ASP.NET app

Compression Using DeflateStream and GZipStream

The .NET System.IO.Compression namespace provides two general purpose compressions streams –  DeflateStream and GZipStream

SQL Server Data Mining with Microsoft Office Excel

Data Mining with Microsoft Office Excel Introduction A key issue in data mining is not only generating the results but also interpreting them. Unfortunately it is often difficult to interpret the results of data mining and many users are turning to Excel and its data mining add-in tool. Requirements You will need to have permission […]
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 |