Sites anglophones

Registration Open for My Upcoming Pre-Cons: Belgium, Dallas, Iceland, Israel, Miami, Orlando!

Publié le 5 février 2019 sur

I’m hitting the road this spring. Here’s where to find me in person: SQLSaturday Iceland – Your First SQL Server Performance Tuning Class – March 16 – You’re stuck with a database server that’s not going f …

Complimentary access to Gartner’s 2018 Market Guide for Data Masking from Redgate

Publié le 5 février 2019 sur

According to Gartner, « security and risk management leaders should use data masking to desensitize or protect sensitive data to address threats and compliance requirements. » Gartner further adds, « by 2021, the global enterprise use of data masking (DM) …

A Tiny Trauma

Publié le 5 février 2019 sur

Unexpected issue with a hidden calculation on TinyInt

Better Code Reviews with GIT

Publié le 5 février 2019 sur

As more dev teams move their code to Git, it’s important to understand the differences between it and other tools they have used in the past. In this article, Michael Sorens provides some good advice about doing code reviews with Git.

SQL SERVER – Say No To Database Engine Tuning Advisor

Publié le 5 février 2019 sur journey to sqlauthority

I have been using SQL Server for over 20 years and have been working on the focused area of SQL Server Performance Tuning for over 12 years. In recent time I have been very busy doing Comprehensive Database Performance Health Check, and the client …

The “Guess the Next Release Date” contest continues…

Publié le 4 février 2019 sur

Back in December 2017, when I posted the Guess the Next SQL Server Release Date Contest, you could leave your guess in the comments for a chance to win a Live Class Season Pass and a Recorded Class Season Pass. Here’s how the guesses so far …

Creating Your First Stored Procedure

Publié le 4 février 2019 sur

Learn how to get started writing code modules inside of your SQL Server database,

Robotics Process Automation: The New Digital Assistant

Publié le 4 février 2019 sur

When most of us think of robotics used in enterprises, automating manufacturing processes comes to mind. Robotics Process Automation (RPA), however, deals with automating mundane office tasks. In this article, Arvind Kumar explains the benefits of RPA …

Compliant Database DevOps for SQL Server using Redgate Tools

Publié le 4 février 2019 sur

In this article Stephanie Herr looks at the Redgate tools that give you an end-to-end compliant Database DevOps Solution

Getting Started with Database containers

Publié le 4 février 2019 sur

A beginning look at containers in Windows.

Feb 2019 Updates – Webcast, SQLBits, SQL Saturday and Performance Tuning of Your System

Publié le 4 février 2019 sur journey to sqlauthority

As February starts, just thought of dropping a note to let you know where you can find me in the upcoming months. Do scroll down all the way to read the change in offering in SQL Server Performance Tuning Workshop. Optimize Server Performance by Reduci …

Does Parallel Threads Process Equal Rows? – Interview Question of the Week #211

Publié le 3 février 2019 sur journey to sqlauthority

Question: Does Parallel Threads Process Equal Rows? Answer: No. (Well usually no). I received the same question during the Comprehensive Database Performance Health Check. Here is the simple proof running the following query: SELECT [SalesOrderID] …

SQL SERVER – Msg 2555: Cannot Move All Contents of File to Other Places to Complete the Emptyfile Operation

Publié le 2 février 2019 sur journey to sqlauthority

Once upon a time, I was trying to remove TempDB database additional files, but it was not working. In this blog I would explain the steps needed fix Msg 2555: Cannot move all contents of the file to other places to complete the emptyfile operation. THE …

SQL Server Diagnostic Information Queries for February 2019

Publié le 1 février 2019 sur - glen berry

This month, I have just made some minor improvements to most of the query sets, mainly in the comments and documentation. I have a T-SQL script that you can use to check whether your instance of SQL Server has been patched to mitigate against the Spect …

[Video] Getting Started with the Consultant Toolkit

Publié le 1 février 2019 sur

You’re a consultant who needs to figure out why your clients’ SQL Servers are slow and unreliable. You’ve collected a bunch of diagnostic queries over the years, but they have a lot of holes, and you don’t really have the time t …

Pages :