Sites anglophones

38 Blog Posts We Couldn’t Write in 2018

Publié le 31 décembre 2018 sur

Behind the scenes here at Brent Ozar Unlimited, we’ve got a place where we jot down blog post ideas. Anybody from the company can add ideas, and anybody can pluck those ideas back out and flesh them out into blog posts. We’ve got a whopping …

Talking T-SQL (among Many Other Enterprise SQL Server Topics)

Publié le 31 décembre 2018 sur

Microsoft experts discuss the current state of cloud adoption, T-SQL enhancements, the evolution of enterprise SQL Server performance tuning and mentorship.

Cloning SQL Server Instances with Containers

Publié le 31 décembre 2018 sur

Learn how containers and WinDocks can be used to quickly provision copies of databases.

SQL SERVER – Installation Failure – Specified Instance Via Transform is Already Installed. MSINEWINSTANCE Requires a New Instance that is not Installed

Publié le 31 décembre 2018 sur journey to sqlauthority

This is one of the situations where my client installed one clustered instance of SQL Server and the second one was failing. In this blog, I would share my findings of error: Specified instance via transform is already installed. MSINEWINSTANCE require …

Thoughts About the 2019 Salary Survey’s New Questions

Publié le 30 décembre 2018 sur

Our annual Data Professional Salary Survey is open now and closes this Sunday. We’re asking a few new questions this year (based on your feedback), and here’s what we’re seeing so far. At how many companies have you held this job? Thi …

How to Sort a Varchar Column Storing Integers with Order By? – Interview Question of the Week #206

Publié le 30 décembre 2018 sur journey to sqlauthority

Question: How to Sort a Varchar Column Storing Integers with Order By? Answer: I recently received a very interesting question during my Comprehensive Database Performance Health Check, one of the Senior Developer asked if I know how to Sort a Var …

SQL SERVER – Measuring the Length of VARCHAR and NVARCHAR Columns with COL_LENGTH

Publié le 29 décembre 2018 sur journey to sqlauthority

I love my job because I get to help people learn new technology as well as help them clear their confusion about the older technology. Recently during SQL Server Performance Tuning Practical Workshop, I was asked a very simple but interesting question …

How to Check if Your Processor Supports Second Level Address Translation (SLAT)

Publié le 28 décembre 2018 sur - glen berry

If you want to run Docker for Windows, you will need to be running Windows 10 Professional, Windows 10 Enterprise, Windows 10 Pro for Workstations, or Windows 10 Education Edition. Since Docker for Windows requires Microsoft Hyper-V, you will also need …

20 Questions to Ask About Your Availability Group Design

Publié le 28 décembre 2018 sur

Questions about the overall project: What are your RPO and RTO goals? Are there financial penalties if we miss the goals? (Like contracts, refunds to customers, etc) Does this app have regularly scheduled maintenance windows, or is it 24/7? What’ …

Understanding Peer-to-Peer Transactional Replication, Part 2

Publié le 28 décembre 2018 sur

As the Peer-to-Peer series continues, we set up an example topology in Peer-to-Peer Transactional replication and test it.

SQL Prompt Code Analysis: A Hint is Used (PE004-7)

Publié le 28 décembre 2018 sur

I feel sympathy with the frustration of database developers who see the ever-increasing range of hints that are available or see the wide use of hints in commercial database applications, some of which sound like they can help solve their query perform …

Creating Measures Using DAX

Publié le 28 décembre 2018 sur

The series so far: Creating Calculated Columns Using DAX Creating Measures Using DAX A measure is any formula which aggregates data, whether it be counting the number of transactions in a database, summing the sales figures for a region, or working out …

SQL SERVER – How to Count a Particular Value Across All Columns?

Publié le 28 décembre 2018 sur journey to sqlauthority

This question came up in the recent SQL Server Performance Tuning Practical Workshop. During the workshop, I have answer questions of users during lunch break. One of the users had a very interesting scenario where he had to change one of their em …

When Does SARGability Matter Most?

Publié le 27 décembre 2018 sur

!erehT iH I know what you’re thinking. Another post about how you should just never do this one thing and all your queries will magically end up faster. Just watch the video.   For more reading, check out these posts: Sargability: Why %strin …

Building a Collaborative Platform to Speed up Data Analysis

Publié le 27 décembre 2018 sur

In this article, Feodor demonstrates the architecture, workflow, and some of the challenges of a collaborative platform (cloud foundation) for speeding up enterprises in their search for analytical power. He uses an example from the EA Billing solution …

Pages :