Sites anglophones


Implementing Restart Ability For Shell Scripts

Publié le 9 juillet 2020 sur sqlservercentral.com
 

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

Publié le 8 juillet 2020 sur brentozar.com
 

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

Publié le 8 juillet 2020 sur sqlservercentral.com
 

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

Publié le 7 juillet 2020 sur brentozar.com
 

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

Publié le 7 juillet 2020 sur sqlservercentral.com
 

The post Automating Oracle Database Deployments using the Hybrid Approach appeared first on SQLServerCentral.

Business Reasons For Implementing Power BI

Publié le 7 juillet 2020 sur sqlservercentral.com
 

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

Publié le 7 juillet 2020 sur sqlservercentral.com
 

The post Monitoring SQL Server with PowerShell Core Object Setup appeared first on SQLServerCentral.

Updated First Responder Kit and Consultant Toolkit for July 2020

Publié le 6 juillet 2020 sur brentozar.com
 

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

Publié le 6 juillet 2020 sur sqlservercentral.com
 

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

Publié le 6 juillet 2020 sur sqlservercentral.com
 

The post SQL Server Licensing and SQL Monitor appeared first on SQLServerCentral.

The importance of remote monitoring

Publié le 3 juillet 2020 sur sqlservercentral.com
 

The post The importance of remote monitoring appeared first on SQLServerCentral.

Azure Data Factory vs SSIS vs Azure Databricks

Publié le 3 juillet 2020 sur sqlservercentral.com
 

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

Publié le 2 juillet 2020 sur sqlservercentral.com
 

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

Publié le 2 juillet 2020 sur sqlservercentral.com
 

The post Easily manage SQL Server licensing with SQL Monitor 10.1 appeared first on SQLServerCentral.

What Do You Do Better Than the Cloud?

Publié le 1 juillet 2020 sur brentozar.com
 

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 …


Pages :