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 Data Tools for SQL Server 2014 6
Learn how to get SQL Server Data Tools for SQL Server 2014.
Session 2: Creating Synchronous, Asynchronous and Read-Only Replicas 

Running Time: 56 minutes |

In this session, you'll see how you can create AlwaysOn Availability Groups that contain both synchronous and asynchronous replicas. You'll also see how you can offload reporting and backups to read-only replicas.

Session 3: Creating AlwaysOn Availability Groups in Azure 

Running Time: 50 minutes |

In the final session, you'll see how you can create SQL Server AlwaysOn Availability group replicas in Azure and use them for cloud-based disaster recovery.

Using the SQL Server Dedicated Administrator Connection
Learn how to use the SQL Server's Dedicated Administrator Connection (DAC).
compititors with raised fists into clouds
Microsoft’s Hybrid Cloud is Positioned to Win the Cloud Wars
Microsoft may not be the market leader in the cloud, but its new hybrid approach puts it in the best positioned best to provide useful and effective cloud services to businesses today.
Configuring AlwaysOn Read-Only Replicas 1
Learn how to configure your SQL Server AlwaysOn replica to allow read-only access.
Setup SQL Server AlwaysOn Replicas in Microsoft Azure
Azure can be a cost-effective alternative to setting up your own private disaster recovery site. Learn a couple of different ways that you can use Azure as a disaster recovery location for SQL Server.
The Azure Experience
Michael Otey shares with readers his hands-on experience using the new Microsoft Azure. Learn why you might want to give the new Azure a try.
Yellow triangle road sign marked Error
Increasing the SSMS Table Designer Timeout Value
Are you getting an error changing the schema for a table using the Table Designer in SQL Server Management Studio? Learn how to fix the problem!
Sizing In-Memory OLTP Hash Indexes
Learn how to size the bucket_count value for SQL Server 2014's In-Memory OLTP hash indexes.
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.

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 6

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) ×