SQL Server Articles


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

SQL Azure Performance – Query Optimization

This article outlines the main techniques for optimizing queries running on SQL Azure.

Using PowerShell to Manage SQL Server

The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell’s flexibility by creating a set of commands customized to our needs. I will call this framework comprised of a library of modules and functions specialized to manage […]

Ensure a .NET App Works in Both 32 bit and 64 bit Environments

With 64 bit versions of Windows fast becoming the standard it is imperative that an app work in both 32 bit and 64 bit environments, this article demonstrates how to ensure your app can work in both environments.

SQL Server Index Maintenance Performance Tuning for Large Tables

It is nothing really new that indexes have their right to exist in SQL Server. It is also nothing really new, that these indexes need to be maintained every now and then, even though this might be surprising for people who are lulled by the otherwise low maintenance for SQL Server. But if you think […]

Monitoring Disk Usage in Windows Server

This article demonstrates how to monitor the usage of the various drives attached to a Windows Server installation.

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.

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  […]
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 |