Linchpin People, LLC is an organization led by Brian Moran and Andy Leonard with Mike Walsh and Robert Pearl as Partners. For those who do not know about Linchpin, they are a technology company with a focus on the Microsoft Database stack on the front, but behind the scene they are about developing people. The […]
SQLSAT107
SQL Saturday 107
SQLskills IE3 #sqlskills
I attended my first SQLskills event in December 2011. Due to a big project at work I was able to work in week three of the Immersion Events which is HA/DR “High Availability and Disaster Recovery”. Although I am taking the training out of sequence my hope is to be able to attend IE2 later […]
SQL Saturday 103 Recap
SQL Saturday 103 was in Curacao, a beautiful Dutch Island in the Caribbean. I was fortunate enough to be able to attend this event and demo a couple of favorite tools of mine. SQL Prompt and SQL Compare. Being the PASS regional mentor for this area made me want to attend and show support even […]
Idera ACE Program
On March 9th a tweet went out by David Fargo announcing the 2012 Idera ACE’s and my twitter handle was included in the list. http://bit.ly/ABedR0 March 9th could also be deemed the day twitter blew up my iPhone. The congratulations from the SQL Community was truly amazing. The Idera ACE program is something that has […]
Find the version of the Master DB from a backup
Try researching recovering the master database online and you will see countless references to having to have SQL at the same version and builld level as the backup of the master database. Since most folks probably don’t have a routine in place to record the version number each time SQL server is patched we need […]
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 […]