Orin Thomas

Orin
Thomas

Orin Thomas is an MVP, an MCT and has a string of Microsoft MCSE and MCITP certifications. He has written more than 30 books for Microsoft Press on topics including Windows Server, Windows Client, System Center, Exchange Server, Security, and SQL Server. He is an author at PluralSight and is a contributing editor at Windows IT Pro magazine. He has been working in IT since the early 1990's and regularly speaks at conferences in Australia and around the world. Orin founded and runs the Melbourne System Center, Security, and Infrastructure Group. Follow him on twitter to check out his most recent tweets.

Articles
Acronis Recovery for MS SQL Server Management Console screenshot
SQL Server Backup Comparison 2
If SQL Server's native tools aren't meeting your database backup and restore needs, there are alternative tools you can use. Here's a look at how backup solutions from Acronis, Quest Software, and Red Gate Software stack up against each other.
How to Upgrade to SQL Server 2008 from SQL Server 2000 2
There’s a lot to know about upgrading from SQL Server 2000 to 2008. This article guides you through the process.
Compression in SQL Server 2008
Get the facts about the new data compression feature in SQL Server 2008 and the stored procedure that can help you estimate how much space you might save by compressing your data.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Mar 14, 2015
Commentary

For Data Quality, Intelligent Rules Add Value to the Golden Record 5

The quest for the Golden Record to achieve a single, accurate and complete version of a customer record is worth the pursuit to attain survivorship. Record matching and consolidation are only the beginning. Melissa Data takes a new approach. Learn how to apply intelligent rules based on reference data to make smarter and better decisions for data cleansing....More
Mar 12, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 20: Avoiding Backup Fragmentation

On SQL Servers where Availability Groups (or Mirroring) isn’t in play, I typically recommend keeping a combination of on-box backups along with copying said backups off-box as well. Obviously, keeping databases AND backups on the SAME server is the metaphorical equivalent of putting all of your eggs in one basket – and therefore something you should avoid like the plague....More
Mar 6, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 19: Availability Group Database Backups

One of the biggest strengths of AlwaysOn Availability Groups is that they allow DBAs to address both high availability and disaster recovery concerns from a single set of tooling or interfaces. But, this doesn’t mean that you won’t still need backups....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×