Sites anglophones


Watch Brent Tune Queries at SQLSaturday Oslo

Publié le 29 août 2020 sur brentozar.com
 

This morning, I had the honor of presenting virtually at SQLSaturday Oslo. The session title, Watch Brent Tune Queries, explains it all. Enjoy! In the session, I used the 2018-06 Stack Overflow database, but any recent full-sized copy (not the 2010-201 …

Building a Personal Brand and a Bit About SQL with Pinal Dave – PodCast

Publié le 29 août 2020 sur journey to sqlauthority
 

Recently I got the opportunity to feature on the Podcast of amazing DeveloperWeekly by Barry Luijbregts. It was so much to discuss the personal brand and SQL with Barry. This weekend, I suggest you list to the podcast as I believe I have shared many pe …

Who Dropped Your Table? – SQL in Sixty Seconds #112

Publié le 28 août 2020 sur journey to sqlauthority
 

Who Dropped My Table? – I was recently asked this question in Comprehensive Database Performance Health Check. A very valid question indeed as my client was working on a table which was suddenly disappeared from the database. After a while, it wa …

Reverse-Engineering the Production Database into Source Control

Publié le 28 août 2020 sur sqlservercentral.com
 

The post Reverse-Engineering the Production Database into Source Control appeared first on SQLServerCentral.

3 Ways to Run DBCC CHECKDB Faster

Publié le 27 août 2020 sur brentozar.com
 

In my last post, I talked about how you can get 43%-67% faster backups. Today, I’m using that same SQL Server setup to discuss how throwing more CPU cores might help you check for corruption faster if you’ve already got modern fast storage. …

Understanding SQL Server Recovery Models

Publié le 27 août 2020 sur simple-talk.com
 

The #1 task that every DBA needs to be able to perform perfectly is to recover a database should it become corrupted for some reason. The recovery model of a database determines the options a DBA has when recovering a database. If a DBA can’t rec …

Single Column Single Row and TABLE SCAN – SQL in Sixty Seconds #111

Publié le 27 août 2020 sur journey to sqlauthority
 

Can a single column and single row result do an entire table scan? I recently got this question in my  Comprehensive Database Performance Health Check. I think it is a fair question when we retrieve very few rows from a gigantic table, we do expec …

Basic Git for DBAs: Managing PowerShell Scripts

Publié le 27 août 2020 sur sqlservercentral.com
 

This is the seventh article in a series on the basics of using Git. The other articles in the series are: Basic Git for DBAs: Getting Started with Git Basic Git for DBAs: Sharing Files Through GitHub Basic Git for DBAs: the Basics of Branches Basic Git …

Back Up SQL Server 43%-67% Faster by Writing to Multiple Files.

Publié le 26 août 2020 sur brentozar.com
 

Even if you’re not writing to different physical drives, you can get faster backups with Microsoft SQL Server when you back up to multiple files. Your exact numbers are going to vary based on your server and your utter inability to rub two sticks …

Dirty Read with NOLOCK – SQL in Sixty Seconds #110

Publié le 26 août 2020 sur journey to sqlauthority
 

My primary job is that help various organizations to tune their SQL Server performance Comprehensive Database Performance Health Check. Recently I noticed that my client has been using the WITH NOLOCK hint with their queries and expecting that it will …

DBA in training: Preparing for interviews

Publié le 26 août 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 Ah, the big black box – the technical interview. You’ve heard about them, but maybe you have never been through one – and it fee …

SQL Server Interview Questions for Developers on Querying

Publié le 26 août 2020 sur sqlservercentral.com
 

The post SQL Server Interview Questions for Developers on Querying appeared first on SQLServerCentral.

Updated Fundamentals of Database Administration Class: Just $39

Publié le 25 août 2020 sur brentozar.com
 

You’re a systems administrator or developer who’s been stuck in charge of the SQL Server. You have a couple of production SQL Servers, no high availability or disaster recovery, and around 100GB of data or less on each server. You’ve …

Undo Human Errors in SQL Server – SQL in Sixty Seconds #109 – Point in Time Restore

Publié le 25 août 2020 sur journey to sqlauthority
 

In this blog post, we are going to talk about how to undo human errors in SQL Server with the help of Point in Time Recovery. Let me start asking some questions –Have you ever dropped your table by mistake?Have you ever wrote an UPDATE statement …

Configuring Availability Groups in Ubuntu

Publié le 25 août 2020 sur sqlservercentral.com
 

In this article, we will review how to configure Always On Availability Groups in Ubuntu Server using the Pacemaker cluster. The following are the high-level steps to configure Always On Availability Groups (AOAG) with an Ubuntu server. Install SQ …


Pages :