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
Q & A
SQL Server 2014 Developer Edition Licensing
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.
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).

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 17, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 21: Assigning Backup Preferences

An option when creating new AlwaysOn Availability Groups is to specify Backup Preferences. It’s also something you can easily configure once the Availability Group has been set up as well – by simply right-clicking on the Availability Group and selecting Properties – then navigating into the Backup Preferences tab.  ...More
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
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) ×