If you’ve been following this series, you know that in part one, I addressed reasons for upgrading to Microsoft SQL Server 2016, as well as some pre-upgrade tasks to be mindful of, and in part two, I focused on tasks that should take place...
SQL Server Agent allows you to create a virtual team of DBAs to work when you can’t – i.e. 24 hours per day, seven days per week. It allows you to schedule jobs to fire on any schedule you can conceive and as the SQL services come online.
Most technical articles written explore new features of existing products or identifying a problem and providing a solution.
...
Microsoft has been on a rapid clip of releasing new SQL Server focused products and plugins as they also continue to move strongly forward with their scale-out to Linux and continued leadership in cloud data with Azure SQL Database and Azure SQ...
In the first post of this series on upgrading to Microsoft SQL Server 2016, I addressed reasons for upgrading, as well as some pre-upgrade tasks to be mindful of. In this installment, I’m going to focus on tasks that should take...
Those of you who are regular readers may notice that my content has shifted towards scripting and some of the emerging platforms and tools for interacting with Microsoft SQL Server. There is a method to this madness but I can’t go into details ...
In a recent article I presented you with an option for searching for any string of t-sql text inside your stored procedures; for that I used sys.syscomments. A point was raised by a reader that sys.syscomments, being a System Compatibility vi...
IT/Dev Connections Early Bird Rates end next Friday, June 16. These rates get you $600 off an All Access Pass...
Have you ever been asked for your thoughts on upgrading a database server? If you’re like most data professionals, your response probably included something along the lines of, “it’s difficult” and “everything breaks...