Setting Up Database Mail And SQL Agent Alerts With PowerShell
As a DBA, you need to know when there’s a problem on your SQL Servers. And while I highly recommend you use a full-fledged monitoring system, there are also some …
Slides From SQL Saturday Tampa 2020
SQL Saturday Tampa 2020 was this past weekend , and I have to say that I really enjoyed it! This was my first time at the Tampa event, and I …
Disable Telemetry On Multiple SQL Servers With PowerShell
Starting with SQL Server 2016, when you install SQL Server it also installs the CEIP (Customer Experience Improvement Program) Services, also known at Telemetry. In previous versions of SQL Server …
Speaking At SQL Saturday Tampa 2020
In just a little over 3 weeks I’ll be speaking at SQL Saturday Tampa 2020! This event will be held on Feb 29 2020 at USF MUMA College of Business, …
Slides From SQL Saturday Nashville 2020
The slides from my presentation “How To Be The DBA When You Don’t Have A DBA” can be downloaded here. In this particular presentation there are a lot of links …
SQL Scripts: List Databases A Login Can Access
When you are managing your SQL Server database permissions through Active Directory Groups (which you should be!), it can sometimes be difficult to know just which databases a user actually …
Speaking At SQL Saturday Nashville 2020
I am excited to announce that I have been selected to speak at SQL Saturday Nashville in January! The event will be held on January 18th, 2020, at Middle Tennessee …
Backing Up Databases With The dbatools PowerShell Module
We do a lot of database backups and restores at work, outside of our regular backup routines. A lot! I’ve actually done as many as 40 in one day. Our …
2020 IDERA ACE
I am super excited to announce that I have been selected to participate in the 2020 IDERA ACE program! IDERA made the announcement last week, and I am honored to …
Recover Deleted Indexes With SQL Server Metrics Pack
In my latest enhancement to SQL Server Metrics Pack , I added a new feature to the index metrics scripts that automatically generates a CREATE INDEX script and stores it …