Sites anglophones


Getting Started with Power BI – Part 1

Publié le 1 mars 2019 sur sqlservercentral.com
 

In this tip we will show how Power BI works and how to create a simple report from scratch and the options available for creating reports.

SQL SERVER – SQL Server Configuration Manager Missing from Start Menu

Publié le 1 mars 2019 sur journey to sqlauthority
 

Earlier I wrote a blog on the same topic and today I found another way to do the same thing. In this blog, we would discuss the steps you can take to open SQL Server Configuration Manager when its missing from Start Menu in the Windows operating system …

What was the first SQL Server concept that stumped you?

Publié le 28 février 2019 sur brentozar.com
 

What’s the first thing you remember struggling with on SQL Server? Your first memory of, “Dang, I just can’t figure this out,” and then you had a Eureka moment later when it was so much more clear?” I asked folks on Twitte …

SQL Provision Makes Light Work of Compliance

Publié le 28 février 2019 sur sqlservercentral.com
 

With SQL Provision it takes seconds to spin up database copies for dev and test, with whatever level of protection you need – masked data, unmasked data, or synthetic data sets. This means you can meet the needs of DevOps while ensuring your data …

Improve the Performance of Your Azure SQL Database (and Save Money!) with Automatic Tuning

Publié le 28 février 2019 sur sqlservercentral.com
 

Organizations may have many concerns about performance when migrating databases to Azure. Fortunately, Microsoft provides some great tools to help improve performance and save money. In this article, Monica Rathbun explains how to take advantage of the …

Index Column Order – Be Happy!

Publié le 28 février 2019 sur sqlservercentral.com
 

Ever wonder about index column order; this piece should give some insight.

SQL SERVER – How to Drop All the Hypothetical Indexes of Database?

Publié le 28 février 2019 sur journey to sqlauthority
 

Earlier I wrote a blog post SQL SERVER – Say No To Database Engine Tuning Advisor and I got an email from my existing client where I frequently engage for Comprehensive Database Performance Health Check. They wanted me to help them remove all the …

PREEMPTIVE_OS_FLUSHFILEBUFFERS waits on Linux

Publié le 27 février 2019 sur sqlskills.com - paul randall
 

Last week I blogged about Using the Wait Statistics Report in Azure Data Studio, using a Linux VM in Azure as an example host. As that was my first time running wait stats analysis on a Linux host, I found that the PREEMPTIVE_OS_FLUSHFILEBUFFERS wait w …

Where do I file bugs and feature requests for Microsoft Data Platform products?

Publié le 27 février 2019 sur brentozar.com
 

It’s not just you: it’s hard for all of us to figure out where to go when we find a bug or want to add a feature. Here’s a quick rundown: Azure Data Studio – open an issue in the Github repo. While you open an issue, Github …

Updating Rows in Incremental Loads – Level 4 of the Stairway to Integration Services

Publié le 27 février 2019 sur sqlservercentral.com
 

Part four of this stairway series examines the process of updating the data in an existing table in a load. MVP Andy Leonard talks about the way in which packages can handle changes in a repeatable fashion.

Verify File Exists Using PowerShell

Publié le 27 février 2019 sur sqlservercentral.com
 

In this tip we look at a PowerShell script that can be used to compare actual files that exist against a list of files that should exist for a project to identify any missing files.

Monitoring Azure SQL Database with SQL Monitor

Publié le 27 février 2019 sur sqlservercentral.com
 

SQL Monitor provides a full suite of monitoring specific to Azure SQL Database and SQL Elastic Pools. You can therefore use it to monitor all your databases, regardless of whether they are on local physical servers or virtual machines, or in the Azure …

SQL SERVER – SQL Service Not Getting Started Automatically After Server Reboot While Using gMSA Account

Publié le 27 février 2019 sur journey to sqlauthority
 

This was the first experiment with gMSA account in my lab and I faced an interesting issue. In my lab environment, I have a complete domain server and member servers. Once I configured gMSA for SQL Server service and restarted the machine, SQL Service …

There’s a bottleneck in Azure SQL DB storage throughput.

Publié le 26 février 2019 sur brentozar.com
 

As you pay more for Business Critical Azure SQL DB servers, they’re supposed to get more storage throughput. The documentation on this is kinda hard to read, but boiling it down, for every core you add to a Gen5 server, you’re supposed …

What are Inline Indexes?

Publié le 26 février 2019 sur simple-talk.com
 

Usually, the added features of the CREATE TABLE syntax in new releases of SQL Server are esoteric, and unless you are dealing with memory-optimized tables or other esoteric stuff, they aren’t of great interest. However, the Inline INDEX for both …


Pages :