-->
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

Archives: August 2018

MAXDOP Calculator

Every time I conduct a SQL Server health check, it’s pretty common for me to find wrong configurations at instance level. But one of the most common mistakes I see on the wild, is SQL instances having the “max degree of parallelism” (MAXDOP) set to “1” (single core) , probably… Read more

0 comments, 736 reads

Posted in DBA Mastery on 28 August 2018

Guatemala SQL Server local group

Good news for all the Guatemalan data professionals, starting from August 2018 you have an official PASS SQL Server local group near to you!

What is PASS?

First thing first, for all those future members of this local group I will like to explain what is the PASS organization all… Read more

0 comments, 270 reads

Posted in DBA Mastery on 23 August 2018

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

2 comments, 2,000 reads

Posted in DBA Mastery on 13 August 2018

Enable SQLCMD Mode on 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

5 comments, 3,308 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, 227 reads

Posted in DBA Mastery on 1 August 2018