Sites anglophones


New Objects, Columns, and Messages in SQL Server 2019 CTP 2.3

Publié le 3 mars 2019 sur brentozar.com
 

Sure, there’s official documentation on what’s new in SQL Server 2019, but Microsoft’s notorious for slipping undocumented stuff in. Sometimes these new features become officially documented in subsequent preview builds, like CTP 2.2 …

SQL Server 2019 Result Set Caching?

Publié le 3 mars 2019 sur brentozar.com
 

Friday’s new CTP 2.3 added a few new fields to sys.databases: But the highlighted one has me all tingly inside, kinda like the first time I heard Winona Ryders use the word “chainsaw” in a sentence. (Bonus points for readers who get t …

What is Clean Buffer in DBCC DROPCLEANBUFFERS? – Interview Question of the Week #215

Publié le 3 mars 2019 sur journey to sqlauthority
 

Question: What is Clean Buffer in DBCC DROPCLEANBUFFERS? Answer: I must give a big credit to the guy who actually asked me this question as in my over 20 years of the journey no one has ever asked me this question. Though the answer to this q …

SQL SERVER – FIX: The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) Node.

Publié le 2 mars 2019 sur journey to sqlauthority
 

Sometimes if the sequence is not followed correctly, we might see some weird errors. In this blog, we would learn how to fix always on an error while adding new replica “The specified instance of SQL Server is hosted by a system that is not a Win …

Calling all Oracle Database users

Publié le 1 mars 2019 sur sqlservercentral.com
 

We’re excited to announce that Redgate is doubling its efforts on Oracle and committed to aligning its DevOps solution across both SQL Server and Oracle. Please take a few minutes to complete this short survey to stay up-to-date on our Oracle dev …

Unit Testing with SQL Server

Publié le 1 mars 2019 sur sqlservercentral.com
 

Learn how to begin unit testing with tSQLt and SQL Server.

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 …

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 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 …

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 …


Pages :