-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

DBA Mastery

I am a very experienced multi platform Database Administrator (SQL Server, Azure SQL DB, Oracle and MySQL). I have more than 10 years of experience in the database administration field, working for large scale US based companies (multiple industries). I have multiple SQL Server certifications under my belt (MCP, MCTS, MCSA, MCSE), during my spare time I like to help others using the #SQLHelp hashtag in Twitter. I hope you find all the information/DBA tips shared in this blog useful

Cleaning up Query Store data after database restore

Query Store is a very powerful tool for performance tuning, if you are not using it already you should!! It will save you a lot of time and effort because it makes the performance troubleshooting easy for DBA’s. It helps you to quickly find performance differences caused by query plan… Read more

0 comments, 127 reads

Posted in DBA Mastery on 13 August 2018

SQLCMD mode in SSMS

I really like Microsoft philosophy nowadays, they are putting a lot of time developing good open source tools like SQLCLI, SQLOps and Visual Studio Code, those tools has something in common “a built-in terminal” a multi-platform and code geek like me really appreciate those details. It is pretty neat to… Read more

2 comments, 2,839 reads

Posted in DBA Mastery on 7 August 2018

First time speaker at Denver’s SQL local group

06/21 was the date that marked my career as data professional, for the first time ever I decided to participate as technical speaker in United States. Probably this is not a big deal for most people, but it is for a Guatemalan boy whose started dreaming as big as possible… Read more

0 comments, 109 reads

Posted in DBA Mastery on 1 August 2018

Is your SQL Server environment ready for GDPR? Part 1

Unless you have been living under a rock lately, you have not heard about GDPR. This has been hot topic in any technology website, blogs and social media network for the last past 2 weeks and even more today because this data regulation goes effective today (05/25).

In this post,… Read more

0 comments, 11 reads

Posted in DBA Mastery on 25 May 2018

SQL Vulnerability Assessment

Vulnerability assessment is probably one of the most underrated new security features in SSMS 17. This feature is not new to SQL Server though, it already exists on Azure SQL DB but it was finally introduced in SSMS with the version 17.

If you are supporting a SQL Server environment… Read more

0 comments, 9 reads

Posted in DBA Mastery on 21 May 2018

Reviewing the SQL Server ERROR log

 

The SQL Server ERROR log is the best source to understand what’s wrong with your SQL Server instance, think this log is like your flight recorder.

In case you are not too familiar with the SQL Server ERROR log, the xp_readerrorlog extended stored procedure is your friend; and as… Read more

0 comments, 12 reads

Posted in DBA Mastery on 10 May 2018

ITIL certification for DBAs – Part 2

 

In my previous post I did my best explain a little bit what ITIL is and how important is for DBAs to understand better about this framework.

Now let’s talk about how to get prepared to pass the ITIL foundations certification test. After spending quite some time researching about… Read more

0 comments, 12 reads

Posted in DBA Mastery on 13 April 2018

ITIL certification for DBAs – Part 1

 

In some point of your career as DBA you might have interacted with ITIL or at least your heard about it. ITIL is very common in the DBA workplace nowadays (moreover in larger companies) but no matter what level of involvement you have had I’m pretty sure at some… Read more

0 comments, 12 reads

Posted in DBA Mastery on 13 April 2018

SQL Saturday #695 Guatemala

This is probably a very delayed post, but I have been really busy lately.

As mentioned in my previous post, I was accepted to participate as speaker in Guatemala’s 2018 SQL Saturday organized in past February by SQL PASS organization.

It was an amazing experience, a very busy day full… Read more

0 comments, 6 reads

Posted in DBA Mastery on 23 March 2018

Speaker at SQL Saturday’s Guatemala city 2018

I’m very thrilled to announce that I will be participating as speaker in this year’s SQL Saturday event in Guatemala city!

Here are the details of the two sessions I will be presenting on February 03:

Advance SQL Server troubleshooting with DMVs

DMVs are the best source to conduct an… Read more

0 comments, 7 reads

Posted in DBA Mastery on 4 January 2018

MSDB Tuning by purging backup and restore history

Have you ever had problem with your backup jobs taking more time than usual overlapping your maintenance window? It is the disk IO throughput fast enough? or it is your SQL Server not performing well? what could be affecting the performance to avoid your backup job to completely in timely… Read more

0 comments, 17 reads

Posted in DBA Mastery on 1 December 2017

SQL Server Management Studio Reports

Today’s tip is a very basic functionality that comes with any SSMS (SQL Server Management studio), we are talking about SSMS Instance and Database level reports.

These SSMS reports does not require any additional plugin or either SSRS (SQL Server Reporting Services), all these aware reports are part of any… Read more

0 comments, 7 reads

Posted in DBA Mastery on 7 November 2017