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
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.
The PC Is Far From Dead
The PC is not dead. Here's why it will be with us for the foreseeable future.
solid state disk (SSD) and hard disk drive (HDD)
Hot Database Industry Trends
Hot new database trends include In-Memory OLTP, solid state disks (SSDs), and software-defined networking (SDN).
New Features in Visual Studio 2013
Learn about the top new features in Visual Studio 2013.
The In-Memory Revolution
Learn about SQL Server 2014's In-Memory OLTP Engine
SQL Views: Steps to Setting Up SQL Agent
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.
Reflections from IT/Dev Connections 2013
Michael Otey shares the hot trends explored at IT/Dev Connections 2013.
Changes to SQL Server 2014 AlwaysOn Availability Groups
Learn about the new AlwaysOn Availability Group features in SQL Server 2014.
Microsoft Faces Uncertain Times
Whoever winds up running Microsoft they have a tough and uncertain climb ahead

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
Feb 25, 2015
Commentary

Data Profiling to the Rescue by Pushing Metadata Boundaries

Don’t let bad data sneak up on you when and where you least expect it. Ferret out bad data with Melissa Data’s newest Profiling Component for SSIS. Learn how to take control of your data using knowledge-base-driven metadata. The truth shall set you free!...More
Feb 11, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 17: Creating Jobs to Check on Synchronization

In my previous post, I provided a high-level outline of the core logic (and rationale behind that logic) that would be needed to set up regular synchronization checks on SQL Server Agent Jobs for servers where AlwaysOn Availability Groups have been deployed. In this post, I’ll walk through the steps--and the code--needed to setup those checks....More
Jan 22, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 18: Health Checks for Availability Groups

Now that we’ve outlined the process to let servers in a SQL Server AlwaysOn Availability Group "talk to each other" by means of setting up linked servers, it’s possible to set up some additional or improved checks on Availability Group Health....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) ×