Sites anglophones


Improve Power BI Performance with Horizontal Filtering

Publié le 7 octobre 2020 sur sqlservercentral.com
 

The post Improve Power BI Performance with Horizontal Filtering appeared first on SQLServerCentral.

What is database continuous integration?

Publié le 7 octobre 2020 sur simple-talk.com
 

Continuous Integration (CI) is an essential step of application development for DevOps organisations. Whenever a developer commits code, a build is kicked off. The code must compile and pass automated testing before it is merged into the main branch. D …

Poor Man’s Resource Governor: Database-Scoped Configurations

Publié le 6 octobre 2020 sur brentozar.com
 

Let’s say you had report queries that were going wildly parallel, and you wanted to put a stop to it, but you couldn’t afford SQL Server Enterprise Edition. You could do is create databases with different MAXDOP settings:CREATE DATABASE [MA …

Storage 101: Monitoring storage metrics

Publié le 6 octobre 2020 sur simple-talk.com
 

The series so far: Storage 101: Welcome to the Wonderful World of Storage Storage 101: The Language of Storage Storage 101: Understanding the Hard-Disk Drive  Storage 101: Understanding the NAND Flash Solid State Drive Storage 101: Data Cente …

Experimenting with PostgreSQL in a Container

Publié le 6 octobre 2020 sur sqlservercentral.com
 

PostgreSQL is a popular Open Source relational database platform. It is available at https://www.postgresql.org, and it was designed as a better Ingres database. Across the last 30 years, it has improved and grown quite a bit. This was the first open s …

SQL Server High CPU Query Use Monitoring with PowerShell

Publié le 6 octobre 2020 sur sqlservercentral.com
 

The post SQL Server High CPU Query Use Monitoring with PowerShell appeared first on SQLServerCentral.

Free Webcast on Wednesday: The New Robot DBAs in SQL Server 2017, 2019, and Azure

Publié le 5 octobre 2020 sur brentozar.com
 

The robots are really just people wearing metallic masks. You’ve been hearing about all these robots that are coming to take your job. They’re going to automate all the performance tuning and make your life way easier, right? Or harder, I g …

Application down after SQL Service logon account change

Publié le 5 octobre 2020 sur sqlservercentral.com
 

I was working on one of my clients server recently. This was during a normal maintenance monthly activity to reboot the database server every first weekend. I rebooted the machine, and as per the defined steps, I checked the SQL services after the rebo …

Azure Database for MySQL

Publié le 2 octobre 2020 sur sqlservercentral.com
 

The post Azure Database for MySQL appeared first on SQLServerCentral.

Want to use columnstore indexes? Take the ColumnScore test.

Publié le 1 octobre 2020 sur brentozar.com
 

When columnstore indexes first came out in SQL Server 2012, they didn’t get a lot of adoption. Adding a columnstore index made your entire table read-only. I often talk about how indexing is a tradeoff between fast reads and slow writes, but not …

Comparing Two SQL Server Databases: When, Why, and How

Publié le 1 octobre 2020 sur sqlservercentral.com
 

The post Comparing Two SQL Server Databases: When, Why, and How appeared first on SQLServerCentral.

Configure Replication Between an On-premises SQL Server and AWS RDS

Publié le 1 octobre 2020 sur sqlservercentral.com
 

In this article, we will review how to migrate the data from on-premises SQL Server to AWS RDS for SQL Server using transactional replication. There are several ways to migrate data from on-premises SQL Server to AWS RDS for SQL Server and transac …

Implementing SQL Server Security with Stored Procedures and Views

Publié le 1 octobre 2020 sur sqlservercentral.com
 

The post Implementing SQL Server Security with Stored Procedures and Views appeared first on SQLServerCentral.

Efficiently polling remote data sources

Publié le 30 septembre 2020 sur simple-talk.com
 

Data rarely resides in one place. Oftentimes, there is a need to collect data from many different data sources and combine them locally into meaningful reports, analytics, or tables. The process for accessing, collecting, validating, and using data fro …

Cross Tab Report in SSRS

Publié le 30 septembre 2020 sur sqlservercentral.com
 

The post Cross Tab Report in SSRS appeared first on SQLServerCentral.


Pages :