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's In-Memory Technology May Require Database Changes 4
There are a good number of SQL Server data types and features that aren't support by this initial release of In-Memory OLTP.
Brad Anderson speaking at Microsoft TechEd 2014
The New Microsoft
Expect a more rapid rate of change from Microsoft—especially for Azure-based services—as well as a better hybrid experience that incorporates more mobile devices and other technologies.
HammerDB Transaction Counter
Generating a TPC-C OLTP Workload
Learn about a free tool that you can use to generate a TPC-like workload on your SQL Server system.
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.

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
New Power BI Designer unifies the “power” tools
Jun 3, 2015
Article

Power BI Preview Gaining Market Momentum

As summer nears, the Power BI Preview is making bigger waves with every weekly release. Popular data sources and a plethora of Power BI Designer enhancements are being released at light speed pace. Check out the highlights on what has been released and what we might see next....More
Evolution of SQL Server continues
Jun 3, 2015
Article

What is Coming in SQL Server 2016 for Business Intelligence 1

Over the past few years we did not hear anything from Microsoft about SQL Server on-premises business intelligence enhancements. The extended cricket-chirping silence left us speculating about the future of Reporting Services, Analysis Services and other key technologies that are being used today to power critical decision making solutions. Good news, the waiting and wondering is over. Microsoft recently announced significant SQL Server on-premises upgrades for business intelligence in numerous presentations at both //build and Ignite conferences....More
May 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 25: Final Remarks on Backups

In the last few posts (posts 19 – 24) I’ve covered some high-level concerns and reviewed some details about how to implement and manage database backups against AlwaysOn Availability Group databases. Most of the information I’ve provided was pretty basic or elementary – along with some additional guidelines for things to watch out for when managing backups. Which is to say that backups are never something you can simply take for granted and they’re never something you just take lightly....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) ×