SQL Server Agent is a handy job-scheduling program built for SQL Server; with it, users can easily create essential jobs and specify what steps will be taken, when a job will be executed, set alerts for specific events, and more.
In this updated version of "Avoid Referential Integrity Errors When Deleting Records from Databases," Chandra Sekhar Pathivada goes more in-depth into the concepts behind his PR_HIERARCHIAL_DATA stored procedure....More
Michael Otey, Senior Technical Director for SQL Server Pro, outlines in this webcast video how to take advantage of all the options for SQL Server vitualization while also gaining the most performance advantages....More
I've been involved in virtualization projects for about 10 years now. In that time, I've had the opportunity to track my own list of best practice items. It's a list I share freely with customers that seek out virtualization advice....More
As far as I'm concerned we'll likely always have SQL Injection around to haunt us. Even though this attack vector has been well-publicized and well-documented for well over a decade (and then some), failure to account for it continues to pop all the time—even in catastrophic places....More