Michael Otey

Michael
Otey

Michael Otey, Senior Contributing Editor for Windows IT Pro and SQL Server Pro, is president of TECA, a software-development and consulting company in Portland, Oregon. Michael has covered the topic of virtualization extensively for Windows IT Pro, having written several features articles showing how to take advantage of virtualization in the enterprise as well as reviewing all of the major virtualization products. Follow Michael on Google+ and Twitter.

Articles
space rocket launch
SQL Server 2014 Launch About What You Don’t Get
Microsoft's data platform vision is all about the future, but there are many SQL Server 2014 users that won’t get any of this cool stuff that makes up this new data platform.
network ports
SQL Server TCP and UDP Ports
Tired of trying to figure out which TCP and UDP ports SQL Server uses? This quick reference points you in the right direction.
Q & A
SQL Server 2014 Developer Edition Licensing 1
Learn whether or not the SQL Server 2014 Developer Edition is licensed per user and, if so, if it limited to a single user at a time.
Express subway train sign
SQL Server 2014 Express Editions
Learn about the new SQL Server 2014 Express editions.
SQL Server 2014 Hits General Availability—No April Fools
Microsoft releases SQL Server 2014 for General Availability.
Top 10 written in gold
Top 10 New Features in SQL Server 2014

SQL Server 2014 has plenty of significant enhancements, but there are no major changes to SSIS, SSRS, or SSRS. Here is Michael Otey's list of the top 10 new features you'll find in SQL Server 2014.

Visual Studio Online FAQs
Microsoft has recently released Visual Studio Online, a newer version of Team Foundation Service. Here are some FAQs about the cloud-based development software.
evolution
The Evolution of SQL Server 2014 2
See how SQL Server has evolved into an enterprise data platform over the past two decades.
Important New Features in SQL Server 2014 1
SQL Server 2014 has several compelling new features, such as the In-Memory OLTP engine, that might justify an upgrade in your organization.
SQL Server 2014 in white letter with red background
SQL Server 2014 RTM Announced, April 1 General Release 2
Microsoft has announced that SQL Server 2014 has been released to manufacturing (RTM) and will be generally available on April 1.
green computer memory board on yellow background
More FAQs about SQL Server 2014 In-Memory OLTP
Since SQL Server 2014 In-Memory OLTP was announced, there have been many questions from many different people about the new feature and how it works. Here, Mike Otey will answer some of the more frequent questions.
trucks hauling storage containers
SQL Server Storage Best Practices 1
Knowing some basic best practices can help you optimize SQL Server's storage availability and performance.
Is Documenting Code a Necessary Evil or Just Plain Wrong?
Should you still document your code?
magnifying glass sitting on papers, magnifying the word ERRORS
SQL Server Log Files Update
To fix SQL Server problems, it's crucial to know as much as possible about the issue. Here are the best places to find log files for troubleshooting.
SQL Server 2014 In-Memory OLTP database engine cover photo
Rev Up Application Performance with the In-Memory OLTP Engine
The In-Memory OLTP engine is SQL Server 2014's most important new feature. Here's a look at this revolutionary new technology.

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
May 18, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 24: Synchronizing SSIS Packages

In my previous post I covered options for adding “If-checks” into SSIS Packages – or SQL Server Maintenance Plans (which are, effectively, specialized SSIS packages). Once you’ve tackled that process, you’ll need to tackle something else when it comes to managing SSIS packages in conjunction with AlwaysOn Availability Groups. Or, more specifically, you’ll actually need to tackle two tasks....More
May 13, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 23: Maintenance Plan Backups and SSIS Packages

In my last post, we took a look at some of the details involved in actually implementing backups against databases being hosted in AlwaysOn Availability Groups. In addition to providing a high-level overview of how sys.fn_hadr_backup_is_preferred_replica() works, I also mentioned that integrating it into backups managed by SQL Server Maintenance Plans isn’t as easy as what you’ll run into with other types of backups....More
Apr 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 22: Executing Backups

Ultimately, there are a number of ways that DBAs can regularly create backups of their databases. Some of the more common options for managing backups include:...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) ×