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...
2018-08-29 (first published: 2018-08-13)
2,070 reads
DBA Mastery
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,...
2018-08-10 (first published: 2018-08-07)
3,502 reads
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...
2018-08-01
242 reads
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...
2018-05-25
133 reads
SQL Vulnerability Assessment
Vulnerability assessment is probably one of the most underrated new security features in SSMS 17. This feature is not new...
2018-05-21
134 reads
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...
2018-05-10
109 reads
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...
2018-04-13
224 reads
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...
2018-04-13
241 reads
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...
2018-03-23
100 reads
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...
2018-01-04
98 reads
Blogs
Advice I Like: Ranch Rules
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
Three Ways to Use Snowflake Data in Microsoft Fabric
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Forums
You Have Homework
Comments posted to this topic are about the item You Have Homework
SSIS 2019 or 2022 - Microsoft Connector for Oracle
Hello all, I am having one heck of a time installing Microsoft Connector for...
bringing a .bak across the wire without rdp'ing or mapping into the sql server
hi, a peer of mine would like to be self sufficient in bringing small...
Question of the Day
The Query Optimizer and Page Density
If I have a fillfactor set to 70%, this reduces my page density to roughly 70%. Does this affect the query plans that the optimizer chooses?
See possible answers