Despite similar intentions and high-level goals, the ways in which AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups tackle high availability and disaster recovery are quite different....More
The Microsoft SQL Server Distributed Replay feature helps you assess the impact of future SQL Server upgrades. You can also use it to help assess the impact of hardware and operating system upgrades, and SQL Server tuning....More
Here's a story that I'd like to share, about the infamous SQL Server 833. As you may know, an event 833 (or error 833, as it’s sometimes called) is a signal from the SQL Server that it’s waiting for records that it’s requested....More
Let's take a look at a few common bad habits that need to be broken in order to provide better, consistent data and some of the silent killers when foreign key constraints are not added to the database model....More
In situations where elevated permissions are needed to execute particular SQL Server jobs, or more importantly, steps within given jobs, a more secure way to tackle elevated permissions is to use credentials and proxies....More
Concerned about the disruptive changes introduced by cloud, big data and mobile technologies? Read this new white paper to learn how Dell Foglight for Oracle can help Oracle DBAs embrace these challenges and transform the data center....More
The days of building an application and rolling the dice are over. Load and stress testing early, and often, in the development cycle, gives developers more control over the quality of their code....More
Free SQL Server tools that help you solve problems are always handy. Take a look at these five useful and free SQL Server tools that can make you more productive, help you experience fewer hassles, and maybe even lower your job stress.