Handling Inconvenient Requests
Brad gives a little guidance on how you might want to respond to inconvenient requests with an eye on doing yourself a favor.
2018-08-02 (first published: 2009-12-07)
321 reads
Brad McGehee
How To Recondition Batteries
These days we are all looking for ways to save money and even to help the
environment. If you came across this site you are most...
2018-04-24
Online T-SQL Scripts and Copyright
The issue of copyright for online scripts is a grey area. If a script is published without any form of copyright notice, most people assume that it is freely available for reuse. It's not necessarily the case.
2016-11-25 (first published: 2009-04-20)
521 reads
Brad's Sure Guide to SQL Server Maintenance Plans
Brad's Sure Guide to Maintenance Plans shows you how to use the Maintenance Plan Wizard and Designer to configure and schedule eleven core database maintenance tasks, ranging from integrity checks, to database backups, to index reorganizations and rebuilds.
2013-08-26
7,823 reads
How to Become an Exceptional DBA, 2nd Edition
Brad McGehee provides a "career guide" for DBAs. It is intended both to help prospective DBAs find a "way in" to the profession, and to advise existing DBAs on how they can excel at their jobs, and so become Exceptional DBAs.
2013-08-26
10,886 reads
Brad's Sure Guide to SQL Server 2008
SQL Server 2008 has hundreds of new features and improvements for Production DBAs, Developer DBAs, and Business Intelligence specialists…in this book I focus on what I thought were the ten most important new features for Production DBAs.
2013-04-11
13,951 reads
Mastering SQL Server Profiler
SQL Server Profiler can troubleshoot a wide range of SQL Server issues, such as poorly-performing queries, locking and blocking, excessive table/index scanning, and a lot more. Brad's book will allow you to master the use of this versatile tool.
2013-03-15
18,876 reads
SQLServerCentral Best Practices Clinic: Part 1
We exposed the SQLServerCentral cluster for monitoring with SQL Monitor. Just like other companies, we have constraints on resources, and we have more work that needs to be done. Help us configure SQLServerCentral’s database servers with your suggestions on what is the highest priority for a website database back end.
2012-12-25 (first published: 2011-03-07)
22,716 reads
Southwest Missouri SQL Server Users Group to Have First Meeting in October
The Southwest Missouri SQL Server Users Group (SWMOSSUG) is dedicated to providing SQL Server Education and Career Guidance for IT...
2012-08-29
1,779 reads
At the End of One Chapter and the Beginning of a New Chapter
I have been told by hundreds of DBAs that I have the best DBA job in the world as Director...
2012-08-15
1,087 reads
Blogs
Life Support 2008 – Audit Logons
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep...
All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT
This is the first in a series of posts about gatekeeping in Information Technology...
None of the IP addresses configured for the availability group listener can be hosted by the server Either configure a public cluster network 19456
By MUTHUKKUMARAN KALIYAMOORTHY
Requirement: Remove a node from one of... [[ This is a content summary only. Visit...
Forums
full text search
Trying to understand why when I search for numerics in full text, contains does...
New CVE-2019-1068 vulnerability - is there a patch for MSSQL 2012?
MSSQL Server 2012 Service Pack 4 is officially supported until 2022-07-12: https://support.microsoft.com/en-us/lifecycle/search?alpha=sql%20server%202012 The new...
SSIS Package/Agent Job Not Failing!!!
I have a package running in SQL 2016 using Project Deployment. One of the...
Ask SSC