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.
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
Index maintenance is critical to database performance, yet a huge number of shops don't have a decent solution in place. The MidnightDBA team has announced the release of Minion Reindex, a new, free index maintenance solution for SQL Server....More
The ability to use remoting to manage your SQL servers is critical to minimizing the time it takes to make sure everything's running smoothly, so you can focus on the problems that are impacting the business....More
SolarWinds recently announced the new SolarWinds Database Performance Analyzer (DPA) 9.0, an updated version of the SolarWinds DPA that includes new features for in-depth troubleshooting and database analysis....More
Recently, I was digging my way through a really nasty set of trace results from SQL Profiler when I ran across a series of commands that only provided insight into the fact that cursors were being employed....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