Sites anglophones


SQL SERVER – REBUILDDATABASE Error: 0x851A0012 – Missing sa Account Password. The sa Account Password is Required for SQL Authentication Mode

Publié le 25 mai 2019 sur journey to sqlauthority
 

I was in a situation where I was helping the customer to overcome a disaster. They had a hardware failure and the master database was corrupted. The plan was to first rebuild system databases and then restore ALL databases from the backup. Today we wil …

SQL SERVER – FIX: Msg 4353 – Conflicting File Relocations Have Been Specified for File. Only a Single WITH MOVE Clause Should be Specified for Any Logical File Name

Publié le 24 mai 2019 sur journey to sqlauthority
 

This was one of an interesting error which I received while preparing for a demo. I wanted to demonstrate a disaster recovery scenario by doing backup and restore. In this blog we would learn how to fix Msg 4353 – Conflicting file relocations hav …

Setting MAXDOP During SQL Server 2019 Setup

Publié le 23 mai 2019 sur brentozar.com
 

Just a short note – in SQL Server 2019, the setup process has a new MAXDOP tab: The hyperlink about MAXDOP configuration points here. I did a few quick test installs: 4 cores gave me a MAXDOP 4 8 cores offered MAXDOP 8 12 cores offered MAXDOP 6 H …

Query Store in SQL Server 2019 (CTP 3.0)

Publié le 23 mai 2019 sur SQLSkills.com - Erin Stellato
 

Friends, CTP 3.0 dropped today, and it includes some changes for Query Store in SQL Server 2019!  I am so excited!!  I’ve downloaded it and have WideWorldImporters installed and have a lot of testing planned, but if you’re impatie …

SQL SERVER – Maximizing Query Execution Plans On Screen – A Quick Tip

Publié le 23 mai 2019 sur journey to sqlauthority
 

My most of the Comprehensive Database Performance Health Check consulting engagement I do are online and I enjoy working on them when I am at home office and I have multiple monitors. However, I often travel to the customer’s location when my cli …

Bloor scores SQL Provision 4.5 out of 5 for test data provisioning

Publié le 23 mai 2019 sur sqlservercentral.com
 

The post Bloor scores SQL Provision 4.5 out of 5 for test data provisioning appeared first on SQLServerCentral.

My classes have really sucked lately, and I apologize.

Publié le 22 mai 2019 sur brentozar.com
 

I teach my Mastering classes in a regular rotation: Mastering Index Tuning, then Mastering Query Tuning, then Mastering Server Tuning. I go 1-2-3 like that because they build on each other, and I repeat ’em over and over through the year so peopl …

SQL SERVER – Script to Enable PAGE and ROW Level Compression – Disable Compression

Publié le 22 mai 2019 sur journey to sqlauthority
 

At midnight I got a call from a customer who earlier availed my service Comprehensive Database Performance Health Check. The issue which they were facing were sudden high CPU for their SQL Server. They sent me an SOS message for help and I responded. T …

SQL Server Subquery in Select Statement with Where Clause

Publié le 22 mai 2019 sur sqlservercentral.com
 

The post SQL Server Subquery in Select Statement with Where Clause appeared first on SQLServerCentral.

Monitoring your servers and databases with SCOM and SQL Monitor

Publié le 22 mai 2019 sur sqlservercentral.com
 

The post Monitoring your servers and databases with SCOM and SQL Monitor appeared first on SQLServerCentral.

9 Tips for Faster SQL Server Applications

Publié le 21 mai 2019 sur brentozar.com
 

Wanna make your SQL Server applications go faster? Here are 9 simple tips that will give you a better chance for success. They’re not carved in stone, but they’re a good place to start. Query Design Tips 1. Code for readability first. The e …

SQL SERVER – Difference Between Login Vs User – Security Concepts

Publié le 21 mai 2019 sur journey to sqlauthority
 

In the last 13 years of blogging, I have been asked this question again and again and so many times that I think if you wake me up in the middle of the night I can easily reply about the difference between Login Vs User – Security Concepts.Before …

Introduction to the Cosmos DB Emulator

Publié le 21 mai 2019 sur sqlservercentral.com
 

The post Introduction to the Cosmos DB Emulator appeared first on SQLServerCentral.

DBA Walkthrough – Adding space on IBM AIX Power Machines

Publié le 21 mai 2019 sur sqlservercentral.com
 

Editor’s Note: While this doesn’t mention SQL Server, as we can now run the platform on Linux, we thought this might be an interesting look at the process of adding disk space on a Unix platform. SQL Server does not run on Unix, but Linux is similar to …

Bringing certainty to the uncertainty of Brexit

Publié le 21 mai 2019 sur sqlservercentral.com
 

The post Bringing certainty to the uncertainty of Brexit appeared first on SQLServerCentral.


Pages :