I recently presented at SQL Saturday 184 in North Haven and was able to listen to Grant Fritchey’s present “Query Tuning in the Clouds”. What I got out of the presentation was the sense all your tuning skills could be used to optimize a Windows Azure SQL database. I knew Windows Azure SQL Databases have been around for a couple of years but never had the time or need to research them. With a possible data center consolidation in the future, I was wondering if my company could leverage a…
Tag: database administration
Azure SQL Database
I recently presented at SQL Saturday 184 in North Haven and was able to listen to Grant Fritchey’s present “Query Tuning in the Clouds”. What I got out of the presentation was the sense all your tuning skills could be used to optimize a Windows Azure SQL database. I knew Windows Azure SQL Databases have been around for a couple of years but never had the time or need to research them. With a possible data center consolidation in the future, I was wondering if my company could leverage a…
Using Password Safe
One of the daily tasks of a database administrator is the granting and the maintaining of access to the fleet of databases under your charge. It is important to to keep track of all the system administrator accounts and passwords as well as any application ones requested by developers or end users. Another important aspect of security is making sure that passwords are strong enough to meet your companies audit requirements. Why even use a password if it can be easily hacked? Today, I want to go review how the…