Profile cover photo
Profile photo
Thomas Mucha
66 followers
66 followers
About
Communities and Collections
Posts

Post has attachment
Querying the Execution Plan XML for Subtree Cost - Take 2
A few weeks ago I shared a query for probing the execution plan for the Estimated Subtree Cost value . That query was rather simple but it got the job done. In that post I also explained how, although there are several ways of finding missing index suggesti...
Add a comment...

Post has attachment
Querying the Execution Plan XML for Subtree Cost
There are quite a lot of great tools and queries available to the DBA that aid in troubleshooting and performance tuning. The list is incredibly long, but I mainly use RedGate's SQL Monitor (which has come on in the last 5 years in leaps and bounds), Glenn ...
Add a comment...

Post has attachment
SQL 2016 Database Scoped Configuration: MAXDOP
SQL Server 2016 Microsoft expanded the range of database level configuration settings . So now, among other things, we are able to: set certain options both at the instance and the database level (MAXDOP) set instance level trace flag settings at the databa...
Add a comment...

Post has attachment
Master Data Services Model Cloning
Yes! My company uses Master Data Services or MDS. Yes! It's a pain. And yes! I needed to learn how to use and administer it. For anyone that hasn't had this well meant tool forced upon on them, it feels, to be kind, a little unfinished. Based on my experien...
Master Data Services Model Cloning
Master Data Services Model Cloning
myhumblesqltips.blogspot.com
Add a comment...

Post has attachment
Check for SQL Server Connectivity
My company is revamping its domain structure and tightening up network security. I am one of the guinea pigs and therefore have been put into the new domain and OU groups. Obviously, we are experiencing some teething problems. As a result I can't access thi...
Check for SQL Server Connectivity
Check for SQL Server Connectivity
myhumblesqltips.blogspot.com
Add a comment...

Post has attachment
Cleanup SQL Server Logins
Cleaning up after someone leaves. We all do it right? Our companies all have water tight policies and procedures to handle that, or maybe they have policies but not procedures. Or maybe they just kind of don't. Well, if your company is anything lie most of ...
Cleanup SQL Server Logins
Cleanup SQL Server Logins
myhumblesqltips.blogspot.com
Add a comment...

Post has attachment
Compress your database tables
SQL Server has offered data compression since SQL 2008. It is a very good feature but, as with almost everything SQL Server, it needs to be deployed judiciously. Data compression has been written about and reviewed by many SQL experts who are much more qual...
Compress your database tables
Compress your database tables
myhumblesqltips.blogspot.com
Add a comment...

Post has attachment
Query To Find SQL Audit Details
I've been deploying a SQL Server auditing solution for our new SQL 2014 estate. I know, we're a few years behind. But if you saw some of the legacy systems I work with you'd understand that migrating to SQL 2014 is quite a coup! Anyway, I found a really gre...
Query To Find SQL Audit Details
Query To Find SQL Audit Details
myhumblesqltips.blogspot.co.uk
Add a comment...

Post has attachment
Emergency Access to SQL Server
There are times when you need to gain access to SQL Server in an emergency. It doesn't happen very often, but it does happen. Actually, part of the problem is that it happens so rarely! We all get to grips with the various back-door commands required of us ...
Emergency Access to SQL Server
Emergency Access to SQL Server
myhumblesqltips.blogspot.com
Add a comment...

Post has attachment
Restarting a service with PowerShell
We use Redgate's SQL Monitor to keep an eye on our mission critical servers. I like the product. It is reasonably user-friendly, reliable and it helps my team monitor our servers efficiently. I've used other products before and I think SQL Monitor compares...
Restarting a service with PowerShell
Restarting a service with PowerShell
myhumblesqltips.blogspot.com
Add a comment...
Wait while more posts are being loaded