Sites anglophones


How to Download the Latest SQL Server Docker Image? – Interview Question of the Week #244

Publié le 29 septembre 2019 sur journey to sqlauthority
 

Question: How to Download the Latest SQL Server Docker Image?Answer: The command to download the latest SQL Server Docker Image is here:docker pull mcr.microsoft.com/mssql/server:2019-latestHowever, if you are reading this blog post only, I think the c …

SQL SERVER – SQL Agent – Job Start Whenever the CPUs Become Idle

Publié le 28 septembre 2019 sur journey to sqlauthority
 

Today let see a quick question which I was recently asked by a customer of Comprehensive Database Performance Health Check about SQL Agent and Job starting whenever CPU Become Idle.Become IdleSQL Server Agent is one of the most important tools for DBA. …

SQL SERVER – Strange Error Related to Alias

Publié le 27 septembre 2019 sur journey to sqlauthority
 

Just another day I got an email from a client who wanted to hire me urgently for their SQL Server Performance issue on the production server. They immediately paid for Comprehensive Database Performance Health Check and we got online to look at their s …

Take the 2019 State of Test Data Management survey – you could win a $250 Amazon voucher

Publié le 27 septembre 2019 sur sqlservercentral.com
 

The post Take the 2019 State of Test Data Management survey – you could win a $250 Amazon voucher appeared first on SQLServerCentral.

Brent Ozar’s DBA Training Plan no.15: What’s Your SQL Server Waiting On?

Publié le 27 septembre 2019 sur sqlservercentral.com
 

The post Brent Ozar’s DBA Training Plan no.15: What’s Your SQL Server Waiting On? appeared first on SQLServerCentral.

Glenn’s Tech Insights For September 26, 2019

Publié le 26 septembre 2019 sur sqlskills.com - glen berry
 

(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …

SQL SERVER – Unable to Start SQL Server Service or Connect After Incorrectly Setting Max Server Memory to a Low Value

Publié le 26 septembre 2019 sur journey to sqlauthority
 

One of my clients contacted me for whom I assisted incomplete installation of SQL Server along with health check and backup automation. Here is the email which came across about max server memory.Hi Pinal,Please help! This is urgent as SQL Server is do …

Getting Started with SQL Server on Google Cloud Platform

Publié le 26 septembre 2019 sur sqlservercentral.com
 

There are a number of providers for SQL Server in the cloud. Having multiple options brings along the complexity of having to decide which option works best for you. This means you get to play, test, and maybe even have a proof of concept with differen …

SQL Change Automation 4.0: Collaborative Database Development Across Visual Studio and SQL Server Management Studio

Publié le 26 septembre 2019 sur sqlservercentral.com
 

The post SQL Change Automation 4.0: Collaborative Database Development Across Visual Studio and SQL Server Management Studio appeared first on SQLServerCentral.

Why Attend 21 Essential Scripts: Performance Tuning for Everyone?

Publié le 25 septembre 2019 sur journey to sqlauthority
 

It has been the entire year since I am doing various road tour with my training – 21 Essential Scripts: Performance Tuning for Everyone. I have been presenting on this topic for about a year and now is the time that I put it to the rest. My final …

Sort Alphanumeric Values in SQL Server

Publié le 25 septembre 2019 sur sqlservercentral.com
 

The post Sort Alphanumeric Values in SQL Server appeared first on SQLServerCentral.

New: SQL Monitor 9.1 – control and refine the alerts for your growing estate

Publié le 25 septembre 2019 sur sqlservercentral.com
 

The post New: SQL Monitor 9.1 – control and refine the alerts for your growing estate appeared first on SQLServerCentral.

Building Machine Learning Models to Solve Practical Problems

Publié le 24 septembre 2019 sur simple-talk.com
 

Machine learning has been reshaping our lives for quite a while now. Be it the smallest thing such as unlocking your phone through Face Recognition to useful interactions with Siri, Alexa, Cortana, or Google using Speech Recognition, machine learning i …

High-End 4K AMD Gaming PC Build Guide

Publié le 24 septembre 2019 sur sqlskills.com - glen berry
 

Continuing the series I started last week, I thought I would put together a build guide for a High-End 4K AMD Gaming PC. I am classifying a high-end gaming machine as costing above $1500.00 for the main components. You can easily spend significantly mo …

Updated First Responder Kit and Consultant Toolkit for September 2019

Publié le 24 septembre 2019 sur brentozar.com
 

This month’s release has a lot of new feature goodness: the Consultant Toolkit can automatically upload the results to Amazon S3, plus sp_BlitzCache adds a new sort order to better catch unparameterized queries burning up CPU, a new warning for s …


Pages :