Will SQLskills IEPTO2 Class make me a better DBA? IT DEPENDS!

I've been working with SQL Server for about 2 years now and in those 2 years, one of the most important things I did was make http://www.sqlskills.com one of the pages that automatically open when I launch Chrome. Also, signed up for the SQLskills newsletter. The wealth of information available on SQLskills website is astounding, … Continue reading Will SQLskills IEPTO2 Class make me a better DBA? IT DEPENDS!

Lost SA Password? Don’t worry! Use these 2 methods to reset your SA Password!

Option 1 – Using Windows built-in Administrator Account If you have installed the SQL Server with the Windows Administrator in a sysadmin role, you can log in to the server then into the SSMS with that account. After you log in, in the Object Explorer go to Security > Logins > Double Click on SA … Continue reading Lost SA Password? Don’t worry! Use these 2 methods to reset your SA Password!

SQL Server Configuration, sp_configure And Options You Need To Know – Part 1

If you’ve ever went through the process of installing SQL Server, you’ll know that it’s very simple. Provide an admin password, pick your directories and viola, server is installed. The downside of this simplistic setup is that many configuration options are at their default values. 99 times out of a 100, this will not be … Continue reading SQL Server Configuration, sp_configure And Options You Need To Know – Part 1

Processor Power Settings – How to ensure your SQL Server is running optimally.

The processor(s) in your server have been advertised to run at a certain frequency, for example 3.0GHz. This article will help you identify if your processor is indeed running at the advertised speed, and if it’s not, what you can do about it. First, in order to be able to obtain real time information about … Continue reading Processor Power Settings – How to ensure your SQL Server is running optimally.