Microsoft SQL Server

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, or execution plan, for a given query. Using the available indexes may not always be…

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 be used carefully on non-production systems only – otherwise it may cause some adverse effects…

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 CIOs, VPs of IT and/or IT managers are asking themselves is, “Shall I upgrade SQL…

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 be done? Well, as it happens, Microsoft SQL Server has a pretty straight forward method…

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, and who is the current owner of the database). This kind of information is required,…

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 every Microsoft moment that excited me, there are too many to count, so I’ll just…

Page 5 of 50« First Page...34567...10...Last Page »