Michael Otey

Michael
Otey

Michael Otey, senior technical director 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
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
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.

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
Dec 16, 2014
Sponsored

Eight SQL Server Signs the Illuminati Exist

Make no mistake about it, the signs that the Illuminati exist are all around us. You can find their markings on our buildings, on our currency and even in our music videos. That’s right, they’re everywhere!...More
Dec 2, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 16: Job Synchronization Checkup Logic

With Linked Servers configured to allow cross-host or cross-box communication between the servers you’re using to host your AlwaysOn Availability Groups, it’s time to start looking at some scripts that can be used to regularly check whether or not SQL Server Agent jobs are correctly synchronized across all servers in your topology....More
Abstract illustration of linked SQL Servers
Nov 18, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 15: Setting Up Linked Servers

Learn about setting up Linked Server definitions to let two (or more) servers in an AlwaysOn Availability Group talk to each other and check up on job statuses of jobs running on each other....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) ×