Jayleen Heft

Jayleen
Heft
Former Editor, Web Content Manager,
SQL Server Pro

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

Articles
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 2
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.
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.
graph
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.

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 14, 2015
Commentary

For Data Quality, Intelligent Rules Add Value to the Golden Record 4

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
Mar 6, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 19: Availability Group Database Backups

One of the biggest strengths of AlwaysOn Availability Groups is that they allow DBAs to address both high availability and disaster recovery concerns from a single set of tooling or interfaces. But, this doesn’t mean that you won’t still need backups....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) ×