Sites anglophones


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 …

SQL Server Management Studio is as Relevant as Ever

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

After fifteen years of heavy usage by developers and DBAs, it might seem like Microsoft’s free tool, SQL Server Management Studio, is about to go out of style. SSMS is no longer the cool new kid on the block: Microsoft has shown consistent …

SQL SERVER – Script to Get Partition Info Using DMV

Publié le 24 septembre 2019 sur journey to sqlauthority
 

I consider myself very fortunate as I get to see a new system every other day when I am working with a Comprehensive Database Performance Health Check. During the consultation, one of the questions was is there any way to see the information about the …

Using PowerShell to Generate Logins, Server and Database Permissions

Publié le 24 septembre 2019 sur sqlservercentral.com
 

The post Using PowerShell to Generate Logins, Server and Database Permissions appeared first on SQLServerCentral.

Using tsqlt Tests to Practice Queries

Publié le 24 septembre 2019 sur sqlservercentral.com
 

Recently I was talking with someone that was wondering what the value was of writing unit tests. They were concerned that trying to write tests was a large effort and that they might not catch all bugs, so why write the test? It’s a common viewpoint th …

Redgate need users looking to do CI/CD for Oracle Databases

Publié le 24 septembre 2019 sur sqlservercentral.com
 

The post Redgate need users looking to do CI/CD for Oracle Databases appeared first on SQLServerCentral.


Pages :