Sites anglophones


Power BI for Business Intelligence

Publié le 30 avril 2021 sur sqlservercentral.com
 

The post Power BI for Business Intelligence appeared first on SQLServerCentral.

Execution Plans Don’t Have the Yellow Bang They Really Need.

Publié le 29 avril 2021 sur brentozar.com
 

When SQL Server is purely making an estimate up out of thin air, with no freakin’ idea what the real answer is, it doesn’t give you any kind of warning. It just produces an estimate that looks scientifically accurate – until you …

Finding the Optimal Value of Hyperparameters through Grid Search

Publié le 29 avril 2021 sur sqlservercentral.com
 

Summary This article aims at demystifying what grid search is and how we can use to obtain optimal values of our model parameters. It would be highly beneficial for the reader if the prequels to this article are read to gain a holistic understanding of …

DIY Database Clones

Publié le 29 avril 2021 sur sqlservercentral.com
 

Database DevOps techniques require an easy way to provision many copies of a database, even a large database, for development work and especially for testing work. Ideally, these databases should be disposable and easy to create; developers should be a …

How do you monitor your databases? Take the survey!

Publié le 29 avril 2021 sur sqlservercentral.com
 

The post How do you monitor your databases? Take the survey! appeared first on SQLServerCentral.

Detecting Database Drift during Flyway Database Development

Publié le 28 avril 2021 sur sqlservercentral.com
 

The post Detecting Database Drift during Flyway Database Development appeared first on SQLServerCentral.

Five Facts about the SQL Server Resource Database

Publié le 28 avril 2021 sur sqlservercentral.com
 

The post Five Facts about the SQL Server Resource Database appeared first on SQLServerCentral.

Announcing Fundamentals Week: May 10-14, $295

Publié le 27 avril 2021 sur brentozar.com
 

You love learning from me. You’ve attended some of my free online streams, read my blog posts, and you use the First Responder Kit. You enjoy my laid-back, humorous approach to sharing what I’ve learned over the years. You love live classes …

Identify Profiles Actually In-use to Make Database Mail Migration Efficient

Publié le 27 avril 2021 sur sqlservercentral.com
 

Introduction According to Microsoft, Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine. Using Database Mail, your database applications can send e-mail messages to users. The messages can contain qu …

How to improve DevOps communication clarity

Publié le 27 avril 2021 sur sqlservercentral.com
 

The post How to improve DevOps communication clarity appeared first on SQLServerCentral.

SQL Server security – Providing a security model using user-defined roles

Publié le 26 avril 2021 sur simple-talk.com
 

When developing an application that accesses SQL Server, you need to set up a security model, so each user gets the access they need based on their job duties. Some applications require the same access for all users, while other application might requi …

Reducing the Frequency of SQL Server Central Newsletters

Publié le 26 avril 2021 sur sqlservercentral.com
 

We are reducing the frequency of SQL Server Central newsletters from 5 a week to 3 starting on May 3. We will send out our regular newsletter on Monday, Wednesday, and Friday to all subscribers. The Database Weekly newsletter will continue to come out …

SQL Server plan cache mining – Plan attributes

Publié le 26 avril 2021 sur simple-talk.com
 

The execution plan cache in SQL Server is a treasure trove of information about queries that have recently executed. In addition to query text and execution plan details, a wide variety of statistics, options, and parameters are available to research, …

Creating Database Build Artifacts when Running Flyway Migrations

Publié le 26 avril 2021 sur sqlservercentral.com
 

The post Creating Database Build Artifacts when Running Flyway Migrations appeared first on SQLServerCentral.

An Introduction to Azure Data Explorer

Publié le 26 avril 2021 sur sqlservercentral.com
 

Introduction Big data consists of very large datasets, which can be structured, unstructured, and semi-structured. Data may be coming from various data sources in real-time or in batches. The traditional tools and technologies we have used in the past …


Pages :