I have been working on a project recently to collect system metrics of a SQL Server environment. One of the items that came up that would like to collected is the date that SQL Server was installed on the server. In doing a quick search on where this property would be located I found that sys.server_principals […]
Category: Tibits
Support from Atlanta MDF
I have recently been notified that my neighboring SQL PASS Chapter Atlanta MDF will be sponsoring SQL Saturday 167 in Columbus GA. The Columbus GA SQL Users Group has been dubbed the “Extreme Southwest Atlanta Chapter” by Aaron Nelson (blog, twitter) For the past two years our two chapters have worked together in promoting […]
It was time for an upgrade
I am not one of these anti PC sorta guys, but I do love my MacBook Pro. I have owned a PC since 1993 when I got my Packard Bell 386 with Windows 3.1. Even with my MacBook I have 9 Windows flavored VM’s on it. To be honest, I have never had Windows run […]
Becoming the dumbest guy in the group
“Why I joined Linchpin People as a Teammate” It was announced publicly this past weekend at SQL Saturday #111 that I have joined Linchpin People as their first teammate. My friend Andy who is also a Chief Servant Officer of Linchpin made the announcement during the speaker dinner and gave me an official Linchpin dress […]
SQL Server Login Auditing
In recent months I have been asked to ensure we are auditing both successful and failed logins, not just failed logins. It is simple enough to open SSMS, connect to the instance, right click on the server, chose properties, click on security and then check the proper radio button. When putting together or most recent […]
Increase SQL Server Error Log Files
Recently I learned that you can and probably should increase the number of SQL Server Error logs that your instance of SQL Server maintains. This is real simple to change. You can make the change via the GUI with a few simple steps or accomplish it with TSQL. To make this change with SSMS, open […]
KB2463332 failed to install
This morning I was working on getting all new inherited SQL Servers patched to current levels of service packs when one particular server was failing on patching the database engine itself. A quick google search revealed articles tips that someone may have deleted the c:windowsinstaller contents. That wasn’t my case. After reviewing the summary.txt file […]
It is not a blame game.
Here is a hypothetical situation. A dba works for ACME Corp. Due to what ever reason a change has to be made to a user account within Active Directory that should not create any negative issues for the user account. Sounds typical right? The change is made (just happens to be the domain user account […]