SQL Server Articles


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

Capture SQL Server Deadlocks using Extended Events

Deadlocks in SQL Server usually occur when users try to place exclusive locks on each other’s objects. For example, a database user Bob first acquires an exclusive lock on Sales table and then attempts to place an exclusive lock on Orders table. Another database user Joe already has an exclusive lock on Orders table, and […]

Tips For Minimizing Deadlocks in SQL Server

A deadlock or fatal embrace is a situation which occurs when the a process is waiting for the resource that is locked by a second process and that second process is waiting for a resource that is locked by the first process. In this article, we will learn about ways to minimise deadlocks. Tips for […]

Understanding SQL Server Fixed Server Roles – Part 1

When considering the security and protection of the database engine, one of the first considerations that comes to mind is SQL Server Fixed Server Roles. The Server Roles are named Fixed Server Roles as the user cannot alter these under any conditions. Assigning the appropriate roles to the user helps keep the SQL Server Environment […]

Agile Database Development – The Sprint

In Moving to Agile Database Development I discussed the reasons that led our organisation to the decision to incorporate Agile methods into our software development. That part ended with a lead into our first Sprint. For readers who are already familiar with development in sprint cycles will the following explanations not be completely new, but […]

Entity Framework Performance Optimization

Query Tuning Minimise the Data Requested Minimising the data queried is a fundamental tenet of performance tuning for any method of data access. In querying a database using SQL, the below query should almost never make it into production : Select * From [Table] Instead, the query should specify the fields to be returned from […]

Find Orphaned Users In SQL Server

Orphan users can occur once you detach databases or restore a database from another SQL Server database instance. The reason for this is that whenever a user is created, a login name and SID will be created. Each database user is mapped with an SID. This SID is different from one SQL Server instance to […]

Using Entity Framework With An Existing SQL Server Database (Code Second)

Entity Framework originally shipped with two modes – Model First which allowed for the entity model to be created using the designer UI and Database First which created the EF model from a database. EF 4.1 introduced Code-First development, enabling developers to simply generate the EF model and database directly from code. This method rapidly […]

Managing the Report Content Using Report Manager : Subscriptions

In last article Managing the Report Content Using Report Manager: Caching we looked at caching and maintaining the history of the SSRS report. In this article we will be focusing on subscriptions. Reporting services comes with two methods of subscriptions: Windows File Share : Using this method you can place your report in the shared […]

Enhanced Features in Database Restore in SQL Server 2012

Point of time Recovery In a typical production environment, in order to recover data in the even of disaster, most DBAs will schedule a robust backup plan. Since scheduling a full back-up during peak times will have an impact on database performance, most DBAs will have combination of full, differential and log backup in the […]

Entity Framework Gotchas

Entity Framework is fast becoming the default data access method for small to medium sized apps in .NET. Whilst it offers a lot of benefits in terms of productivity and security, working with EF is often very different from working with the standard ADO.NET data-access objects and poses several common issues or ‘gotchas’: Using Different […]
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 |