Sites anglophones


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.

Hidden treasures of SQL Prompt

Publié le 30 septembre 2020 sur sqlservercentral.com
 

The post Hidden treasures of SQL Prompt appeared first on SQLServerCentral.

Editor Tips and Tricks for Azure Data Studio

Publié le 30 septembre 2020 sur sqlservercentral.com
 

Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I’ve written a few articles on how ADS works, shown here: Getting Started with Azure Data Studio Getting Comfortable Writing Code in Azure Data Studio Using Notebooks in Azure Da …

Questions about Comparing Databases with SQL Compare that you were Too Shy to Ask

Publié le 30 septembre 2020 sur sqlservercentral.com
 

The post Questions about Comparing Databases with SQL Compare that you were Too Shy to Ask appeared first on SQLServerCentral.

Announcing a New Class: Fundamentals of Columnstore

Publié le 29 septembre 2020 sur brentozar.com
 

Your report queries are too slow. Will columnstore indexes help? You’ve tried throwing some hardware at it: your production SQL Server has 12 CPU cores or more, 128GB RAM, and SQL Server 2016 or newer. It’s still not enough to handle your g …

Running Container Workloads in Microsoft Azure

Publié le 29 septembre 2020 sur sqlservercentral.com
 

The post Running Container Workloads in Microsoft Azure appeared first on SQLServerCentral.

How SQL Prompt Improves SQL Server Database Development

Publié le 29 septembre 2020 sur sqlservercentral.com
 

The post How SQL Prompt Improves SQL Server Database Development appeared first on SQLServerCentral.

When one of your DBA colleagues leaves the company, what is your checklist?

Publié le 29 septembre 2020 sur sqlservercentral.com
 

Whether it’s in our personal lives our professional one, we do have checklists for certain tasks. On the professional level, these checklists can be purely technical, like steps for a SQL Server installation, configuration, or even uninstall …


Pages :