Nuggets Of SQL Server Knowledge
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 …
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, …
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 …
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 …
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 …
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 …
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 …
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 …
This morning I updated the Index Metrics piece of SQL Server Metrics Pack. This update mainly introduced some new functionality, with a few minor bug fixes. The two big enhancements …
In a previous article, I went over how SQL Server will recommend an index that it believes will help a query run faster, and I showed how to find missing …