When hiring for an entry-level data professional role, you don't have the same technical benchmarks to measure prospective candidates against compared to when you're looking to fill higher-level technical roles.
17 questions every production DBA should ask to ensure that the architecture that surrounds the new database is appropriate, complete and as minimal as necessary to accomplish the correct level of support and service....More
In spite of technical and operational challenges, the stacking of SQL Server instances is something we should be driving toward in order to achieve the significant economic benefits of stacking instances....More
When compared to AlwaysOn Failover Cluster Instances or clustered deployments of SQL Server, one of the main problems with AlwaysOn AGs is that a single database is made to straddle multiple hosts....More
I talk to SQL Server users most days and the question I'm asked most often is always some variation of "How can I get more out of SQL Server for less money?" I tell users the secret to significantly reducing the cost of deploying SQL Server is simple: Stack instances....More
Make no mistake about it, the signs that the Illuminati exist are all around us. You can find their markings on our buildings, on our currency and even in our music videos. That’s right, they’re everywhere!...More
With Linked Servers configured to allow cross-host or cross-box communication between the servers you’re using to host your AlwaysOn Availability Groups, it’s time to start looking at some scripts that can be used to regularly check whether or not SQL Server Agent jobs are correctly synchronized across all servers in your topology....More