Sites anglophones


Updated First Responder Kit and Consultant Toolkit for September 2020

Publié le 14 septembre 2020 sur brentozar.com
 

Let’s give a big round of virtual germ-free applause to Adrian Buckman, Erik Darling, Garry Bargsley, Greg Dodd, Ian Manton, John McCall, Kuldar Andares, Pierre Letter, Stephen Anslow, Tom Butler, …

DBA in training: Know your environment(s)

Publié le 14 septembre 2020 sur simple-talk.com
 

The series so far: DBA in training: So, you want to be a DBA… DBA in training: Preparing for interviews DBA in training: Know your environment(s) Ask any DBA what the first thing you need to know is, and 99.9% will say “backups”. Well, it …

What is Oracle ASM to Azure IaaS?

Publié le 14 septembre 2020 sur simple-talk.com
 

There is a natural desire for us to make sense out of confusion, and Oracle is a topic that confuses many. One of the challenges of being known as a subject matter expert on a topic that isn’t common in the Microsoft space, is that you end up wit …

SQL Server 2017 Installation Error with KB2919355

Publié le 14 septembre 2020 sur sqlservercentral.com
 

Recently I was installing SQL Server 2017 and I could not believe a simple installation took up my whole day. I was installing an instance on one newly built Windows 2012 R2 server. After clicking next a few times, I got an error: a rule failure, for K …

Fully Left-Shifted Deployments with Version Control and Automatic Cloning

Publié le 14 septembre 2020 sur sqlservercentral.com
 

The post Fully Left-Shifted Deployments with Version Control and Automatic Cloning appeared first on SQLServerCentral.

When SQL Server Performance Goes Bad: Implicit Conversions

Publié le 11 septembre 2020 sur sqlservercentral.com
 

The post When SQL Server Performance Goes Bad: Implicit Conversions appeared first on SQLServerCentral.

Delete Duplicate Rows with No Primary Key on a SQL Server Table

Publié le 11 septembre 2020 sur sqlservercentral.com
 

The post Delete Duplicate Rows with No Primary Key on a SQL Server Table appeared first on SQLServerCentral.

Computed Column Performance in SQL Server

Publié le 10 septembre 2020 sur simple-talk.com
 

SQL Server computed columns provide a handy tool for building expressions into table definitions. Still, they can also lead to performance woes, especially as expressions become more complex, applications more demanding, and data sets grow larger by th …

“Not to write any procedure over 50 lines”

Publié le 10 septembre 2020 sur brentozar.com
 

In Joe Celko’s Stairway to Database Design series, he writes: The rules of thumb for T-SQL are not to write any procedure over 50 lines (one page) This seems so radical at first, but it has precedence in NASA’s 10 Rules for Developing …

SCOM Alert: MSSQL 2014: SQL Server cannot authenticate using Kerberos

Publié le 10 septembre 2020 sur sqlservercentral.com
 

One evening I started receiving a flood of alerts from almost every single database server for one of my clients on a SCOM console. The error message appeared as follows: « MSSQL 2016: SQL Server cannot authenticate using Kerberos because the Service Pr …

Upcoming Free Webcast: 500-Level Career Guide: Building Your Brand

Publié le 9 septembre 2020 sur brentozar.com
 

At SQLBits 2020 on Saturday, October 3 at 11:10AM Eastern, 8:10AM Pacific (calendar), I’m presenting a session called 500-Level Career Guide: Building Your Brand. Here’s the abstract: If you want to work for yourself, you need to be able to …

Pinned Tab – SSMS Efficiency Tip – SQL in Sixty Seconds #121

Publié le 9 septembre 2020 sur journey to sqlauthority
 

This is a follow up of my earlier blog which got instant popular Split Screen for SSMS Efficiency – SQL in Sixty Seconds #120. Lots of people asked me to share the SSMS efficiency tip so I have shared the same in this blog post. Today’s top …

Creating and Using Inline Table-Valued Functions

Publié le 8 septembre 2020 sur sqlservercentral.com
 

In case we’ve forgotten or have never come across inline table-valued functions before, we’ll start with a quick explanation of what they are. Taking the definition of what a user defined function (UDF) is from Books Online, an inline table-valued func …

“UPDATE, INSERT, and DELETE are not normally processed in parallel”

Publié le 8 septembre 2020 sur brentozar.com
 

Years ago, when troubleshooting performance, I stumbled across this Microsoft documentation on parallel query processing that says: Certain types of statements cannot be processed in parallel unless they contain clauses, however. For example, UPDATE, I …

The Social Impact of Artificial Intelligence and Data Privacy Issues

Publié le 8 septembre 2020 sur simple-talk.com
 

The current era of AI and Big Data is already considered by many as the start of the fourth industrial revolution that will reshape the world in years to come. Google searches, Map navigation, voice assistants like Alexa, personalized recommendations o …


Pages :