by Aamir Syed | Mar 19, 2021 | SQL Server, Uncategorized
This is part 1 of a 2-part blog series. TempDB is a global database used by everything inside of SQL Server. It works in a round-robin fashion amongst the files that have been allocated to it. It is non-durable and clears its used space once processes are finished... 
by Dave Welch | Aug 3, 2020 | Dave Welch, Oracle Licensing, SQL Server, VMworld
Dave Welch (@OraVBCA), Chief Evangelist Hello everyone. Allan Hirt from SQLHA (Blog | Twitter) and I will be co-presenting session HCP1634 “Licensing Oracle and SQL Server on vSphere” at VMworld 2020 this September. I will be focusing on Oracle while Allan will be... by House of Brick Staff | Aug 23, 2019 | SQL Server
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 a symptom of potential... by House of Brick Staff | Apr 5, 2019 | SQL Server
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 end. You can... by House of Brick Staff | Feb 1, 2019 | General, Oracle, SQL Server
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 blogs on... by House of Brick Staff | Jan 11, 2019 | SQL Server
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 sprawl and its...