SQL Server Articles


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

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

Who is the SQL Server Guest User ?

Have you noticed the ‘guest’ user in all of your databases? Who The Guest User? When you login to the SQL Server, it first verifies you for authentication on the server. If it succeeds, SQL Server checks whether your login is associated or mapped with a database user in the database that the login is […]

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