Sites anglophones


57% of Your Bosses Are Cheap. (Well, maybe 100% of your boss in particular.)

Publié le 29 octobre 2019 sur brentozar.com
 

You know what I’ve noticed about companies? Some companies buy tools for you, but they just don’t have a training budget. They believe they hired you to solve problems, and you should have come with the knowledge to get your job done …

SQL Server Performance Tuning Recorded Class – 40% Discount for 4 Days

Publié le 29 octobre 2019 sur journey to sqlauthority
 

I have been blogging on SQLAuthority.com for almost 13 years. Well, to be honest, I will be completing the 13th year on November 1, 2019. I did my very first blog post on November 1, 2006, and since that day, I have been pretty much blogging every sing …

Oops, I deleted that data

Publié le 29 octobre 2019 sur sqlservercentral.com
 

We all have these days as a DBA,  hopefully they are few and far between for most of us. This morning I walked into the office and found a stack of emails saying that a developer had responded to a support ticket and modified the values in one of …

Planning for SAP HANA Deployments in Public Cloud Environments

Publié le 29 octobre 2019 sur sqlservercentral.com
 

The post Planning for SAP HANA Deployments in Public Cloud Environments appeared first on SQLServerCentral.

Understanding Auctions

Publié le 29 octobre 2019 sur simple-talk.com
 

In spite of the fact that they don’t get much attention in basic economics classes, we live in a world where we are subject to auctions almost constantly. It’s not just getting something on eBay or other auction sites, but it’s how ma …

Recreating Databases from Scratch with SQL Change Automation

Publié le 29 octobre 2019 sur sqlservercentral.com
 

The post Recreating Databases from Scratch with SQL Change Automation appeared first on SQLServerCentral.

Your Data Career is Stuck in a Rut.

Publié le 28 octobre 2019 sur brentozar.com
 

You haven’t really grown as a data professional this year. You’re kinda floating along in your database career, reading blogs, attending webcasts now and then. Maybe you’ll hit a SQL Saturday this year, but … you don’t re …

SQL SERVER – Getting Second Row from Table

Publié le 28 octobre 2019 sur journey to sqlauthority
 

The other day during one of my old clients sent me an email about if I know any trick to get the second row from the resultset. I know why he was asking this question as I had worked with him before Comprehensive Database Performance Health Check.Let u …

Using the SQL Compare command line with Argfiles

Publié le 28 octobre 2019 sur sqlservercentral.com
 

The post Using the SQL Compare command line with Argfiles appeared first on SQLServerCentral.

Transaction Isolation Levels

Publié le 28 octobre 2019 sur sqlservercentral.com
 

Introduction While working with SQL databases, we often write queries without giving a second thought about how the query is going to read data from the underlying tables. As we are aware, databases are designed to follow the basic ACID properties (Ato …

Why Query Store Actual Operation Mode is Not Same as Requested? – Interview Question of the Week #248

Publié le 27 octobre 2019 sur journey to sqlauthority
 

Question: Why Query Store Actual Operation Mode is Not Same as Requested?Answer: Recently, one of the largest bank institutes hired me to help them with their SQL Server Performance. The biggest issue which they were facing was query regression. While …

SQL SERVER – Identifying Query Generating Malicious Wait Type

Publié le 26 octobre 2019 sur journey to sqlauthority
 

Just another day in my life when I got involved in the SQL Server Performance Comprehensive Database Performance Health Check, where I ended up with a server with a high amount of malicious Wait Type. In this blog post, we will learn about how to fix t …

The Curious Case of… emergency-mode repair

Publié le 25 octobre 2019 sur sqlskills.com - paul randall
 

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

Updated First Responder Kit and Consultant Toolkit for October 2019

Publié le 25 octobre 2019 sur brentozar.com
 

This is a pretty doggone big release. There are a lot of improvements to sp_BlitzFirst, sp_BlitzCache, and sp_BlitzWho to prepare for a new release of the First Responder Kit Power BI Dashboard. If you’re using that today, I would strongly recomm …

SQL SERVER – Upgrade Rule Failure Error: No Custom Security Extensions

Publié le 25 octobre 2019 sur journey to sqlauthority
 

A few days ago, I wrote a blog about the issue with the SQL Server upgrade where issue was due to Reporting Services installation in a bad state. Here is the link for that blog. SQL SERVER – Upgrade Error: The Specified Service Does Not Exist as …


Pages :