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.

Mobilizer 3.0 by Forerunner's Software
Unlock the Power of SSRS Across All Devices
You can leverage the power of Microsoft’s SQL Server Reporting Services (SSRS) easier and faster on any device with the newly released Mobilizer 3.0 from Forerunner Software.
8 Free Business Intelligence Tools
Free tools are always handy. Here are eight free business intelligence-related tools for database administrators, business analysts, SQL Server developers, and other data professionals.
people looking at data
Top 13 SharePoint Resources for SQL Server DBAs
Here are 13 great resources to assist SQL Server database administrators (DBAs) with SharePoint configuration, installation, performance optimization, security, and more.
How To Be A Successful DBA
What does it take do be an effective and successful database administrators? Check out these suggestions such as being proactive with maintenance and disaster recovery.
dbForge Studiow for SQL Server version 3.8
New Product: dbForge Studio for SQL Server v3.8
New features and improvements in dbForge Studio for SQL Server v3.8 include SQL Server 2014 support and added database backup and restore features.
green road sign with clouds in the background pointing to solutions or problems
Does SQL Server Run Best on Microsoft Azure?
According to Microsoft, here are 13 key benefits to using Azure Infrastructure Services to optimize your on-premises data and data platform projects.
SQL Server 2012 SP2 Released
SQL Server 2012 Service Pack 2 (SP2) is now available for download from Microsoft. Check out the updates resulting from customer feedback.
Accidental arrow and Intentional arrow road sign
10 Essential Resources for Accidental DBAs
Are you an "accidental" database administrator (DBA)? If so, these basic resources for accidental DBAs covering performance, security, storage, virtualization, and more, may come in handy.
Two young men on grass with SQL Server books flying in the air.
Top 10 Highly Recommended SQL Server Books
Here are 10 technical SQL Server books you may want to consider for your bookcase. Whether you're responsible for servers running SQL Server 2014, 2012, or 2008, there's a book for you.
Microsoft sign on building
10 Must Read SQL Server FAQs
Here are the answers to 10 SQL Server-related questions related to database performance, PowerShell, virtualization, Visual Studio Online, SQL Server 2014's In-Memory OLTP Engine, and more.
TechEd 2014 Best of TechEd booth
Scenes from Microsoft TechEd 2014 in Houston
It's spring again and time for Microsoft's annual TechEd North America conference. The 2014 show is underway in Houston, Texas. Check out these event images.
Illustration of data security and encryption
5 SQL Server 2014 Security Enhancements
SQL Server 2014 security features include Transparent Data Encryption for better data protection and Encryption Key Management, allowing the storage of keys on a separate server.
ApexSQL default view
5 Free SQL Server Tools to Give You a Boost
Free SQL Server tools that help you solve problems are always handy. Take a look at these five useful and free SQL Server tools that can make you more productive, help you experience fewer hassles, and maybe even lower your job stress.
Old vintage suitcase in the middle of a road
Keep SQL Server 2008 Running 3
If you have no immediate plans to upgrade to SQL Server 2014 and will continue to maintain a SQL Server 2008 database, here are our 10 most popular SQL Server 2008 resources for your quick reference.
Secrets tab on blue hanging desk files
3 Things SQL Server Pros Need to Know Today 3.26.14
Get familiar with SQL Server 2014's enhanced integration with Azure, learn more about how SQL Server 2014 is bringing NoSQL speeds to a relational database, and find out seven secrets to make life easier in SSMS.

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

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

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

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