The Hammer

The Hammer

  • Home
  • Subscribe
  • Availability Group Architecture – DR on the Cheap

    Availability Group Architecture – DR on the Cheap

    Last time, I discussed how to limit data duplication between data centers as a cost-effective option with an Availability Group. In this post I will take cost reduction one step further by short-changing the disaster recovery site. Disaster recovery on the cheap This architecture is the most cost-effective way to use an Availability Group and have […]

    February 16, 2016
  • Availability Group Architecture – FCI hybrid

    Availability Group Architecture – FCI hybrid

    Last time, I discussed how to meet high-availability (HA) and disaster recovery (DR) using four stand-alone SQL Server instances in an Availability Group. In this post, I will add SQL Server Failover Cluster Instances to the mix and cut the number of SQL Server instances from four to two. Availability Group and Failover Cluster Instances […]

    February 11, 2016
  • Availability Group Architecture – Adding a Second Site

    Availability Group Architecture – Adding a Second Site

    Last time, I discussed the simplest Availability Group architecture, with only a single site. In this post I will expand upon the same architecture, adding in a second site to achieve more than just high-availability. Cross sub-net availability group In the architecture above, replica A and B are in the primary data center while replica […]

    February 2, 2016
  • Availability Group Architecture – High-Availability Only

    Availability Group Architecture – High-Availability Only

    Availability groups offer us a variety of features. They offer high-availability (HA), they can give disaster recovery (DR), and they have connectivity and off-loading features but we have to decide how to use them. This is the first of a four-part blog series which focuses on my recommended availability group architectures. I will cover; what they […]

    January 19, 2016
  • T-SQL Tuesday #74 – Be the change (MERGE static data)

    T-SQL Tuesday #74 – Be the change (MERGE static data)

    Each month, on the first Tuesday of the month, the announcement for the blog party T-SQL Tuesday comes out. Those that are interested then post their blogs, on the subject selected, on the second Tuesday of the month. If you’ve never heard of T-SQL Tuesday it’s a blog party started by Adam Machanic (b/t) over […]

    January 12, 2016
  • Keeping up with changes to Books Online

    Keeping up with changes to Books Online

    Keeping up with new features of SQL Server can be a challenge. What is even more challenging, though, is keeping up with changes to existing features. Re-reading Microsoft books online is tedious and differences between versions are not always easy to find. I support a PowerShell utility, QS-Config, which handles generating the configuration files necessary […]

    January 5, 2016
  • Performance tuning backup and restore operations

    Performance tuning backup and restore operations

    The standard backup strategy seems to always include backups running at midnight, hoping that they complete before anyone starts using the applications. There is value in performing maintenance on off-hours. However, many applications do not have off-hours or our databases grow in size and they stop fitting in static maintenance windows, or even into a whole […]

    December 21, 2015
  • Guest Post: Identifying and handling blocked processes in SQL Server

    Guest Post: Identifying and handling blocked processes in SQL Server

    Author Bio: Priyanka Chouhan is a technical writer in Stellar Data Recovery with 5 years of experience and has written several articles on SQL server & SharePoint. In her spare time she loves reading and gardening. Identifying and handling blocked processes in SQL Server Among other issues, blocked processes on the SQL Server (or SQL Server deadlocks) pose […]

    December 17, 2015
  • Statistics Parser

    Statistics Parser

    Today I’d like to recommend a free community tool, StatisticsParser.com. Statistics Parser is web-based tool for interpreting the text output of the T-SQL SET STATISTICS IO and TIME settings. The tool was created and is maintained by Richie Rump (b | t), a successful speaker, blogger, and all-around SQL Server community contributor. Quick SSMS demo […]

    November 26, 2015
  • T-SQL Search Snippets

    T-SQL Search Snippets

    Here are two snippets that I use often to search for objects on a variety of servers. The first will search any object within a database and the second will search various elements of SQL Agent jobs. Object search [sql]USE [$databaseName$] DECLARE @keyword VARCHAR(128) = ‘$keyword$’ SELECT o.[type_desc] , s.name [schema] , o.name [table] , […]

    November 16, 2015
←Previous Page
1 … 6 7 8 9 10 … 22
Next Page→

The Hammer

Proudly powered by WordPress