Tag: Microsoft SQL Server

SQL Server Integrity Check – A Necessary Routine

Today I’ll be discussing Integrity Check on SQL Server – we have some very good info in the community, but I’d like to summarize my thoughts here. When a DBA talks about Integrity Check, the conversation is usually redirected to…

Read More >

SQL Server Statistics: Maintenance and Best Practices

What are Statistics? There are multiple paths a database can use to answer a query, some of them being faster and more efficient than others. It is the job of the query optimizer to evaluate and choose the best path,…

Read More >

Untold Secrets of SQL Server: What if?

It’s common practice for IT vendors to keep some of the commands and statements for their own use, and to avoid publishing or documenting these tools for two reasons: Some of these commands are unsafe for production environments and should…

Read More >

Merge Replication Identity Range Management – An Identity Disorder? Part 2

part 2 explores how transactions and batches can affect Merge replication identity range management. It shows a case where batch insert inside a transaction caused applications to fail and provides a resolution to the case.

Read More >

SQL Server versions – Should you upgrade to the next release?

Today there are five versions of SQL Servers serving at the hearts of business enterprises, and the sixth is coming soon. Current SQL Server versions are 2000, 2005, 2008, 2008R2, 2012 and the upcoming version SQL Server 2014. The question…

Read More >

How to Configure Transactional Replication-Mirroring Failover

Configure SQL Server Transactional Replication with Mirroring – this was one of the recent interesting and unusual projects that came our way. At first it looked really odd and intriguing at the same time. The question was, can it really…

Read More >

Merge Replication Identity Range Management – An Identity Disorder? Part 1

This blog will shed some light on identity range management and how it works. Part 2 will explore how batch inserts can affect the identity range management.

Read More >

Script to Collect Database Information Quickly

As a DBA there are occasions where we are required to collect details from a database which can be used for further analysis. For example, getting the status of the database (i.e. File Size, Free Space, Status of the database,…

Read More >

2013 in Review — SQL Server

It’s that time of year. When I take some time away from work, hide out, and reflect on the past year. 2013 was a big year for Microsoft, particularly SQL Server, Windows Azure, and HDInsight. While I’d love to recap…

Read More >

SQL Server 2012: Installing and configuring Distributed Replay

Today we are going to discuss one of the powerful new functions of SQL Server 2012. The name of the feature is Distributed Replay which can be used to assess the impact of changes and upgrades or SQL Server tunings…

Read More >