Implementing Restart Ability For Shell Scripts
Introduction Shell Scripts are widely used in various systems, whether it be for system administration or performing ETL processing. Shell Scripts are mostly designed to perform specific capabilities that an administrator needs. For example, let’s …
The 201 Buckets Problem, Part 2: How Bad Estimates Backfire As Your Data Grows
In the last post, I talked about how we don’t get accurate estimates because SQL Server’s statistics only have up to 201 buckets in the histogram. It didn’t matter much in that post, though, because we were using the small StackOverfl …
Simple Database Development with SQL Change Automation
The post Simple Database Development with SQL Change Automation appeared first on SQLServerCentral.
The 201 Buckets Problem, Part 1: Why You Still Don’t Get Accurate Estimates
I’ll start with the smallest Stack Overflow 2010 database and set up an index on Location:USE StackOverflow2010 GO CREATE INDEX Location ON dbo.Users(Location); GO SELECT COUNT(*) FROM dbo.Users; GO There are about 300,000 Users – not a lot …
Automating Oracle Database Deployments using the Hybrid Approach
The post Automating Oracle Database Deployments using the Hybrid Approach appeared first on SQLServerCentral.
Business Reasons For Implementing Power BI
Data is stored in heterogenous environments in many organizations. Enterprise reporting for management and other departments is created using a variety of tools. There are Excel Workbooks, SSRS Reports, Tableau Dashboards, flat files, data stream …
Monitoring SQL Server with PowerShell Core Object Setup
The post Monitoring SQL Server with PowerShell Core Object Setup appeared first on SQLServerCentral.
Updated First Responder Kit and Consultant Toolkit for July 2020
This month, 15 community folks contributed code – I think that’s an all-time high for a single month’s release! Good work, y’all. Thanks for payin’ it forward. The bad news is that they’re almost all bug fixes, hahah …
Availability Groups with Docker Containers
Introduction Containers continue to revolutionize enterprise architectures. Although there are many benefits of using this technology, many DBAs shy away from it. Perhaps because it’s a foreign technology, or simply because they don’t …
SQL Server Licensing and SQL Monitor
The post SQL Server Licensing and SQL Monitor appeared first on SQLServerCentral.
The importance of remote monitoring
The post The importance of remote monitoring appeared first on SQLServerCentral.
Azure Data Factory vs SSIS vs Azure Databricks
The post Azure Data Factory vs SSIS vs Azure Databricks appeared first on SQLServerCentral.
How Bad are Bad Page Splits – The Rest of the Story
In Part 1 of this article we looked at a specific use case (probably exaggerated) that gave us an idea about how CPU and IO performance might be affected by a bad page split. We continue this analysis looking at what really happens to the data on the l …
Easily manage SQL Server licensing with SQL Monitor 10.1
The post Easily manage SQL Server licensing with SQL Monitor 10.1 appeared first on SQLServerCentral.
What Do You Do Better Than the Cloud?
It sounds like a trick question, but I’m serious. If your company’s management is just now starting to consider the cloud in 2020, your reaction shouldn’t be to cast a shadow on cloud vendors. Instead, think of it as writing your own …