Categories for SQL Server

Page Life Expectancy and What it’s Telling You

posted August 23, 2019, 10:12 AM by

Aamir Syed (@sqlevo), Senior Consultant

SQL Server keeps data pages in memory for quicker access rather than reading from disk every time. Now, keep in mind that Page Life Expectancy doesn’t prove or disprove anything on its own. It’s simply…

Quickly Finish Your SQL Server 2008 Upgrade Project

posted April 5, 2019, 1:32 PM by

Shawn Meyers (@1dizzygoose), Principal Architect 

On July 9, 2019 Microsoft will officially end extended support for SQL Server 2008 and SQL Server 2008 R2.  This means that no further security updates will be available and support for issues will also…

Top Tools for Troubleshooting & Performance Benchmarking

posted February 1, 2019, 6:40 PM by

Jim Hannan (@jim_m_hannan), Principal Architect

Is this blog, we have gathered some of our favorite blogs and tools related to benchmarking and performance troubleshooting. Feel free to bookmark this blog, as we will be updating it as we author new…

SQL Sprawl and Its Impact on Your Licensing

posted January 11, 2019, 12:55 PM by

Phil Ekins (@SQLPhilUK), Principal Architect

At House of Brick we regularly provide license based consulting across the SQL Server and Oracle database stacks. We have numerous blogs on the Oracle stack, but today we will be talking about SQL Server…

Monitoring Database Mail for SQL Server

posted November 21, 2018, 4:05 PM by

Phil Ekins (@SQLPhilUK), Principal Architect

The second blog in this series on Database Mail discussed how to troubleshoot and identify some common issues seen with Database Mail and some options for resolution.

In this blog, we shift our focus to being…

Troubleshooting Database Mail for SQL Server

posted November 16, 2018, 9:20 AM by

Phil Ekins (@SQLPhilUK), Principal Architect

This is part two of our database mail blog series. You can read part one, Database Mail 101 Troubleshooting, here.

At House of Brick, one of our regular interactions with our clients is to assist them…

Database Mail 101 Troubleshooting

posted November 12, 2018, 5:24 PM by

Shawn Meyers (@1dizzygoose), Principal Architect 

This blog covers the basics of troubleshooting Database Mail, and is more tailored to issues related to setup rather than installations that have been working for a while and all of a sudden have stopped….

Patching Availability Groups

posted October 30, 2018, 9:27 AM by

Shawn Meyers (@1dizzygoose), Principal Architect 

In the course of our travels, we have deployed Availability Groups (AG) for many of our clients. One of the questions that comes up over and over again is “how are we supposed to patch…

SQL Server on Linux Install – The Basics

posted August 8, 2018, 10:36 AM by

Phil Ekins (@SQLPhilUK), Principal Architect

In our prior posts in this series we discussed Linux basics and provided a how to for installing Linux. This post picks up the story from that point, with us prepping our server for a…

Oracle and SQL Server on the VMware Cloud on AWS

posted July 27, 2018, 12:31 PM by

Nathan Biggs (@nathanbiggs), CEO

Yesterday, I had the privilege of being invited to participate in a webinar offered by the VMware Cloud on AWS team. It has been an exciting opportunity to work with VMware and AWS, as this offering…