Sites anglophones


SQL SERVER – Installation Stuck at Offline Installation of Microsoft Machine Learning Server Components

Publié le 7 décembre 2018 sur journey to sqlauthority
 

I was trying to install SQL Server 2017 on my latest formatted machine and was stuck at below screen which says – Offline Installation of Microsoft Machine Learning Server Components. In this blog, we would learn about how to move forward in the …

Azure SQL DB is Slow: Do I Need to Buy More DTUs?

Publié le 6 décembre 2018 sur brentozar.com
 

You’ve got an Azure SQL DB, and your queries are going slow. You’re wondering, “Am I hitting the performance limits? Is Microsoft throttling my queries?” There’s an easy way to check: run sp_BlitzFirst. sp_BlitzFirst is ou …

How to reset your development database in seconds using SQL Clone

Publié le 6 décembre 2018 sur sqlservercentral.com
 

Let’s say you’re making experimental changes to your development database and, to explore a hypothesis, you’ve just dropped a table. How long does it take you to restore the database to its previous state, so you’re ready to con …

Configuring SQL Server Always on Azure Servers(Iaas)

Publié le 6 décembre 2018 sur sqlservercentral.com
 

Configuration of SQL Server Always on in Azure Virtual machines differs in multiple ways comparing with the on-premise Implementations. This article will help you to have a handy note to configure always on in Azure servers from a DBA perspective.

Write more compact SQL Server code using new features

Publié le 6 décembre 2018 sur sqlservercentral.com
 

Learn about new functions in SQL Server 2016 and 2017 to have more readable and compact code including STRING_AGG, TRIM, TRANSLATE and DROP… IF EXISTS.

SQL SERVER – SETUP Error: The Syntax of Argument “/ACTION” is Incorrect

Publié le 6 décembre 2018 sur journey to sqlauthority
 

Recently, I was trying to uninstall SQL Server via command prompt and faced an interesting situation. In this blog, we would learn about the error “The syntax of argument “/ACTION” is incorrect” and how to fix it. THE SITUATION …

Indexed View Matching With GROUP BY And DISTINCT

Publié le 5 décembre 2018 sur brentozar.com
 

Bit Of A Kick I’ve been playing with indexed views a little bit lately for some demos in my Bits Precon. There are a whole bunch of limitations in creating indexed views. One of them is that you can’t base the query on DISTINCT. Fair enough …

Data Quality

Publié le 5 décembre 2018 sur simple-talk.com
 

Around the years 2000 to 2005, the trade press filled with articles on data quality. Several good books (see references) were written on the subject, and then it seemed to fade from the popular view. It really is something that should be taught in data …

Adding Disks – Level 3 of the Stairway to SQL Server on Linux

Publié le 5 décembre 2018 sur sqlservercentral.com
 

In this level we examine how to add disks to separate our data, log, and tempdb files.

SQL SERVER – Unable to Uninstall – Index was Outside the Bounds of the Array

Publié le 5 décembre 2018 sur journey to sqlauthority
 

This was an interesting error which I received while trying to uninstall SQL Server.  In this blog, we would learn how to fix error Index was outside the bounds of the array, which might come during uninstallation of SQL Server. I must say this wa …

Indexed View Creation And Underlying Indexes

Publié le 4 décembre 2018 sur brentozar.com
 

Accidental Haha While working on some demos, I came across sort of funny behavior during indexed view creation and how the indexes you have on the base tables can impact how long it takes to create the index on the view. Starting off with no indexes, t …

Overview of Azure SQL Database Information Protection

Publié le 4 décembre 2018 sur sqlservercentral.com
 

Information protection becomes one of the dominant factors that drive modern database design and implementation. This becomes particularly evident when operating in a cloud computing environment, with Azure SQL Database serving as one of the prime exam …

PackPrecScale CLR function

Publié le 4 décembre 2018 sur sqlservercentral.com
 

CLR can be used to pack Precision and Scale of a SqlDecimal How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottleneck …

Create, protect and manage non-production databases with SQL Provision

Publié le 4 décembre 2018 sur sqlservercentral.com
 

SQL Provision allows teams to create a secure, scalable and repeatable process for managing data as it moves through your SQL Server estate, without causing administrative burdens. To find out more and how it can work alongside your existing database D …

SQL SERVER – The OLE DB Provider “Microsoft.ACE.OLEDB.12.0” for Linked Server “(null)” Reported an Error. Access Denied

Publié le 4 décembre 2018 sur journey to sqlauthority
 

Here is another blog which explains a situation I was in while reading data from excel. In this blog, we would talk about error “Access Denied” error while using The OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server. …


Pages :