The Perils Of VSS Snaps
So much, so often Ah, backups. Why are they so tough to get right? You start taking them, you find out you’re not taking enough of them, or that they’re not the right kind, or that you’re not using checksums or compression, or that yo …
SQL Server Patches for Meltdown and Spectre Attacks
The Meltdown and Spectre attacks are newly announced ways of hacking CPUs. They affect both Windows and Linux. If you’re running under virtualization or cloud IaaS, any other running guest can try to leverage the attacks to compromise your unrela …
A Brief History of Data Analysis
Take a look at Data Analysis from ancient times to current days
If you hear these phrases, you might need Microsoft Visual Studio Team Services
There are so many features in Microsoft Visual Studio Team Services that it can be difficult to wrap your head around what all they do and if you’re utilizing the tool to its fullest potential.
SQL Saturday Nashville: I’m Speaking
Going home y’all. On January 13th, I will be speaking at the Nashville SQL Saturday. I moved from Nashville less than 1 year ago, and I always look forward to making a trip up (and not just for hot chicken at Big Shakes , though it does figure into it. …
SQL SERVER – Puzzle – Why Does UNION ALL Work but UNION Produces Error?
You already know what UNION and UNION ALL operators do. They combine datasets while UNION keeps the distinct data UNION ALL will retain all the data. You can read more about that over here: SQL SERVER – Difference Between Union vs. Union All …
Azure Data Lake Store library for Delphi
From Microsoft-Docs on GitHub: Azure Data Lake Store is an enterprise-wide hyper-scale repository for big data analytic workloads. Azure Data Lake enables you to capture data of any size, type, and ingestion speed in one single place for operational an …
Network Issue or THREADPOOL waits?
I’ve had a handful of clients that were experiencing significant THREADPOOL waits. This isn’t a wait type that I had any knowledge of prior to joining Brent Ozar Unlimited. Looking back, I am pretty sure that a few servers that I’ve b …
The top 10 considerations when designing a data platform
Designing a data platform for a new product or service is a fascinating and exciting challenge. It’s also a daunting one.
How to Turn on Instant File Initialization
Not having instant file initialization turned on slows down the process of adding pages to your database, because prior to allocating the data pages to your database, SQL Server needs to zero out the newly allocated pages.
Stairway to MDX – Level 4: The Order() Function: Beyond Cube Hierarchies
Bill Pearson continues his examination of the versatile Order() function, focusing upon its use in providing dataset sorts that reach beyond dimensional hierarchies
SQL SERVER – Slow Filestream Data Cleanup. What Should We Do?
One of my clients reported an issue where they were running low on free disk space on the drive where they have file-stream files. They are one of a heavy user of the filestream feature as compared to any of my previous clients. As per their observatio …
Amazon, Salesforce Shifting Business Away From Oracle
Amazon.com Inc. and Salesforce.com Inc., two of Oracle Corp.’s biggest customers, are actively working to replace Oracle software running on crucial business systems with lower cost open-source database software.
NVIDIA Wants to Block Use of Cheaper Consumer GPUs in Data Center
A change in software license agreement has drawn angry comments online, accusing the company of trying to steer users of GPUs for AI applications toward the expensive, high-end Tesla product line.
How to Remove 'Open PowerShell' from Windows 10 Context Menu
You may not want or need easy access to PowerShell. So why not clean up your context menu a bit?