SQL Server Articles


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

Getting Started with PowerShell for SQL Server

xx

Restoring a Publisher Database in SQL Server

Introduction Restoring any database is a critical task which will be  complicated by the database to be  restored being a publisher database. For the purposes of this article, I will assume familiarity with the different types of replication and their features. All   examples in this article  are with respect to transactional replication. Let us consider […]

Getting Started with Hyper-V Server

xxx

ASP.NET MVC Routing Tutorial

xxxx

Using Full Text Search in SQL Server 2008

Introduction SQL Server 2008 Full-Text Search feature can be used by application developers to execute full-text search queries against character based data residing in  a SQL Server table. To use full text search the developer must create a full-text index for the table against which they want to run full-text search queries. For a particular […]

Windows Server 2008 R2 Backup and Restore

xxx

Light Weight Monitoring using Extended Events

Introduction SQL Server 2008 introduces Extended Events for performance monitoring. SQL Server Extended Events is a general event-handling system for server systems. So  why another event handling system? We already have activity monitor, Perfmon, SQL Profiler, DMVs,. However, Extended Events have several major advantages: 1. Light Weight. This is the primary advantage of  Extended Events. […]

Retrieving Data from an Audit Table

Retrieving data from an audit table. Retrieving information from a history table for a given point in time is a common data task. For example, using a table that contains all historical prices, what where the prices of all products as they were 30 days ago? There are a number of ways to different methods […]

A High Level Comparison Between Oracle and SQL Server – Part IV

Error Log vs. Alert Log SQL Server maintains a running log of its operations. This log includes information about the start-up and recovery events, user actions, backups, configuration changes, invalid login attempts, errors, warnings etc. Every time the SQL service starts up, a new log file is created. This log file is known as the […]

A High Level Comparison Between Oracle and SQL Server – Part III

Start-up and Configuration Parameters When SQL Server is installed, a number of Windows registry keys are also created. These registry keys specify various parameters values required by the instance. For example, one registry key would specify the location of the error log file; another would contain the location of the default backup folder and so […]
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 |