Changing SQL Agent Job Owner with Powershell
This blog post came from a question on the MSDN Forums asking how to change the owner of all SQL Agent Jobs on a server
This blog post came from a question on the MSDN Forums asking how to change the owner of all SQL Agent Jobs on a server
Yesterday I received an email asking me a question related to my Using a Certificate Signed Stored Procedure to Execute sp_send_dbmail on SQL Server Central
Two weeks ago at SQL Connections in Orlando, FL, I got to participate in a session that Paul and Kimberly do at the end of
When Microsoft announced that changes were being made to the Microsoft Certified Masters program for SQL Server 2008 last year I was initially pretty bummed
The Database Compression feature in SQL Server 2008 Enterprise Edition can provide some significant reductions in storage requirements for SQL Server databases, and in the
On my blog post Virtualizing SQL on VMware Reference List, Oscar Zamora (Blog | Twitter) asked the following question in a comment: As a virtualized
If you follow me on Twitter (@SQLPoolBoy) you probably saw tweets about a bug I encountered in SQL Server 2008 recently. What was hoped to
In my last post Does the tempdb Log file get Zero Initialized at Startup? I questioned whether or not tempdb is actually created from the
While working on a problem today I happened to think about what the impact to startup might be for a really large tempdb transaction log
The other night I was asked on Twitter by Todd McDonald (Twitter), for a build list for SQL Server 2005 and 2008. My initial response
A good while ago I was asked if it was possible to consistently produce a parallel plan by Tom LaRock(blog/twitter), and I recalled from reading
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.