Jayleen Heft

Jayleen
Heft
Editor, Web Content Manager,
SQL Server Pro

Jayleen is the SQL Server Pro editor and web content manager. Responsibilities include writing, managing the SQL Server Pro website, and working with authors to acquire and edit technical SQL Server articles. She also handles SQL Server training development and management for web seminars, virtual trade shows, and the IT/Dev Connections Conference. In addition, Jayleen manages the SQL Server Pro social media accounts including Facebook, Google+, LinkedIn, and Twitter.

Articles
2014 IT SKills and Salary Survey graphics
Take the 2014 IT Skills and Salary Survey
Please take a few minutes to complete the 2014 IT Skills and Salary Survey! The survey will be open until October 24. We will start sharing insights in November and will publish the full survey results in early 2015.
GenesisOne's T-SQL Source Code Unscrambler
T-SQL Unscrambler Automatically Documents Legacy Code for SQL Server
GenesisOne has released version 2 of its T-SQL Source Source Code Unscrambler—the industry's first tool to read SQL code and automatically create professional, data-flow documentation without altering the code in any way.
Solution and Problem direction road sign with clouds in background
10 Resources for Tackling SQL Server Errors
Check out these 10 helpful resources for addressing SQL Server errors.
IdeaXchange: What It Means for SQL Server Pro
IdeaXchange is a user-first, user-generated content offering available to SQL Server Pro's readers. Here's what it means for readers..
Update spelled out in colorful letters
SQL Server 2014 Cumulative Update 3 Now Available
Microsoft has released the cumulative update package 3 (Build number: 12.0.2402.0) for SQL Server 2014.
10 SQL Server Indexing Essentials
Great tips for proper SQL Server indexing to make a sluggish database perform better.
SQL Server Migration Assistant for Oracle
SQL Server Migration Assistant v6.0 for Oracle Available
The latest version of SQL Server Migration Assistant (SSMA), a free tool from Microsoft that simplifies the database migration process from Oracle to SQL Server and Azure SQL DB, is now available for download.
How To writting on a green chalkboard
SQL Server Data Tools Update for Visual Studio 2013
Here are the instructions for creating an administrative install of SQL Server Data Tools (SSDT) update for Visual Studio 2013.
SQL Server professionals at a training conference
Upcoming SQL Server Events in 2014-2015
Join your SQL Server colleagues for a variety of upcoming in-person and online networking and training events scheduled for 2014-15.
Jefferson Memorial in Washington, D.C.
SQL Server News from Microsoft WPC 2014
Get a glimpse at some of the SQL Server-related news to come out of the 2014 Microsoft Worldwide Partner Conference (WPC) held July 13-17 in Washington, D.C.
Hybrid SQL Server cloud computing
Top 5 SQL Server Hybrid Cloud Resources
A hybrid cloud scenario may be economical and practical for your SQL Server environment. Learn more about possible options.
ASP.NET Session State Provider for SQL Server 2014 In-Memory OLTP
Microsoft has created a new ASP.NET Session State Provider that enables you to optimize ASP.NET web farms and more easily take advantage of SQL Server 2014 In-Memory OLTP using a packaged solution.
sql server 2008 and sql sever 2008 R2 Support Table
Mainstream Support Ends for SQL Server 2008, 2008 R2
Microsoft will continue to provide technical support, including security updates, for both SQL Server 2008 and SQL Server 2008 R2, until July 9, 2019.
EMS SQL Backjup for SQL Server version 1.5
EMS SQL Backup for SQL Server 1.5 Released
EMS Database Management Solutions, Inc., has released the latest version of their SQL Backup for SQL Server tool used for executing multiple maintenance tasks.
New Service: Backup SQL Server in the Cloud with IDrive
IDrive, a cloud data backup and storage provider, has launched advanced server backup to the cloud for Microsoft SQL Server.

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
detetecitve dressed in black looking at data
Sep 24, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 7: Detecting Primary Replica Ownership

In my mind, there are two logical ways that you might want to have your code check to see if the Primary Replica of a given AG database is currently hosted on a particular server or not...More
Two women looking a man's computer monitor
Sep 17, 2014
Article

AlwaysOn Availability Groups and SQL Server Jobs, Part 6: High-Level Options and Rationale for Handling Batch Jobs

There are a couple of options for how we could handle batch jobs when Availability Groups are thrown into the mix....More
Sep 12, 2014
Sponsored

Managing a Healthy SQL Server Database: Three Principles We Overlook

In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....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) ×