Categories for SQL Server

Can Max Server Memory Impact CPU?

posted February 22, 2018, 12:42 PM by

Shawn Meyers (@1dizzygoose), Principal Architect 

Recently while at a client site, I ran into a situation that stumped me for a bit and shows why best practices exist. This experience reminded me that max server memory is important, and forgetting…

Snapshots with Availability Groups

posted June 21, 2017, 11:17 AM by

Shawn Meyers (@1dizzygoose), Principal Architect 

Recently during a discussion on patching of Availability Groups (AG), the topic of snapshots for virtual machines came up. If I have an AG running in a virtual environment, can I do a snapshot and…

Giving Away Free SQL Server Licenses… Wait What?

posted March 15, 2016, 10:51 AM by

Shawn Meyers (@1dizzygoose), Principal Architect 

On March 10, 2016 Microsoft held a #DataDriven event touting all the really cool and neat features of SQL Server 2016. One of the topics covered was that Microsoft is going to be giving away…

Is Oracle Still the “Largest” Relational Database Vendor?

posted February 18, 2016, 10:10 AM by

Shawn Meyers (@1dizzygoose), Principal Architect 

A couple of weeks ago one of my coworkers, Dave Welch, published a great blog post about Oracle licensing terms. In this post, he mentions Oracle is the largest relational database vendor in the…

A Look Back at 2015

posted December 23, 2015, 5:04 PM by

Jim Hannan (@HoBHannan), Principal Architect

In this blog we would like to take a look back at 2015. A lot happened this year. I will point out some of the highlights of our work at House of Brick during 2015,…

Highlights of vNUMA & SQL Server Session at VMworld 2015

posted October 22, 2015, 10:00 AM by

Shawn Meyers, Principal Architect

Last week I was at VMworld Europe giving a presentation on vNUMA and its impact on SQL server. This post will cover some of the highlights from my presentation and items you should be aware of…

Changing a SA Account

posted August 28, 2015, 3:25 PM by

Shawn Meyers (@1dizzygoose), Principal Architect

I was at SQL Saturday #397 in Omaha earlier this month and sat in on an excellent session on “SQL Server Performance and Resiliency” by Chris Shaw. In his session, Chris talked about the SA…

Load Testing with HammerDB

posted June 23, 2015, 10:13 AM by

Mike Stone (@HoBMStone), CIO & Principal Architect

When we are asked to introduce new database technology or a new architecture at an existing customer site, some of the first questions we’re always asked are around performance. Of course there’s plenty…

SQL Server & HA – What to Know Before You Decide

posted May 18, 2015, 10:49 AM by

Shawn Meyers (@1dizzygoose), Principal Architect

In this post I will discuss High Availability (HA) and list native SQL Server types along with their pros and cons. This is a brief overview and while there is a lot more to each…