SQL Server Articles


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

Moving To Agile Database Development – Part I

Agile Database development? What’s that? Why would I need that? These were questions I had myself until until recently when I tried it. Several couple of weeks ago, we successfully finished our first sprint and my intention is to pass on this experience and hopefully provoke some reaction from readers. I would love to hear […]

New SSIS Features in SQL Server 2012

SQL Server Integration Services (SSIS) has under-gone through some significant changes in SQL Server 2012 which I will outline in this article. Connection Managers Now you have project-based connection managers which mean those connection will be available for all the packages that you are creating. This avoids recreating frequently used connections for every package.  Those […]

Contained Databases in SQL Server 2012

Contained Databases have been an oft requested feature which has finally arrived in SQL Server 2012. In prior SQL Server versions, database were not 100% portable. In case you need to move a database from one server to another using backup and restore, the data in the database will of course be preserved. However, to […]

Managing the Report Content Using Report Manager: Caching

Introduction In the Managing the Report Content Using Report Manager: Part I we saw how  to go about setting the security for the Report Manager report items. In this article we will be focusing on caching SSRS reports. Caching Caching is when a copy of the processed report after the execution is saved into into […]

Common Table Expressions (CTE) for SQL Server Developers

What is A CTE? A CTE is a temporary view that exists only in the scope of running query. A CTE is similar to a view but a CTE is embedded into the query. CTEs can be used in Stored Procedures, User Define Functions (UDFs), Triggers and Views but not in Indexed Views. Below is […]

New T-SQL Features in SQL Server 2012

Paging Data Paging is a big issue for developers as it is required for many applications but entails many performance problems.  Developers have used different workarounds to support paging. For example, assume we need to display several pages of the HumanResource.Employee object with 5 rows per page. Below is the query you need to execute […]

Managing the Report Content Using Report Manager: Part I

What is Report Manager? Report Manager ships with Microsoft SQL Server Reporting Services and is a web application for managing deployed reports. The features of the report manager can be divided into following  types:- General Features: Creation of folders, folder hierarchies and data sources. Printing, searching, hiding, renaming, deleting ,downloading and moving the reports and data […]

Adhoc Reporting Using SSRS 2008 R2

Reporting Services comes with a built-in modeling tool called Report Model Designer which is used for developing adhoc reports. Due to their ease of creation, adhoc reports are often developed by end users as opposed to developers. The main purpose of the report model is to shred the dependency on the coding and give a […]

Replication Without Creating a Snapshot

In replication, the standard way of creating a publisher is to create a publication with a snapshot (which is what all the documentation recommends). However there are a few problems with this method: Creating the snapshots and then applying them is time consuming. Snapshots will consume disk space. There is an alternative to this, where […]

Transactions in SQL Server Part I – An Introduction

A basic requirements in most SQL Server based applications is implementing a database operation (DDL or DML) in a single unit of work. The DDL requirement is more from a DBA’s perspective rather than the application, since any application would perform only INSERTs, UPDATEs and DELETEs on the existing data, and a DBA would be […]
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 |