Watch Brent Tune Queries at SQLSaturday Oslo
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
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
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
The post Reverse-Engineering the Production Database into Source Control appeared first on SQLServerCentral.
3 Ways to Run DBCC CHECKDB Faster
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
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
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
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.
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
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
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
The post SQL Server Interview Questions for Developers on Querying appeared first on SQLServerCentral.
Updated Fundamentals of Database Administration Class: Just $39
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
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
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 …