Diana May

Diana
May

Diana May is a former technical editor for SQL Server Pro and Windows IT Pro. She has been a DBA and worked in software development for more than 16 years.

Articles
Oracle Provides Free .NET Development Tools in Visual Studio
Why is Oracle developing free tools for Visual Studio? The answer is in the number of companies managing a mixture of Windows SQL Server and Oracle. Oracle recognizes the growing number of companies standardizing on the .NET platform.
Kevin Kline Gives Highlights of the 2007 PASS Community Summit
In a SQL Server Magazine exclusive interview, Kevin Kline, President of PASS gives his highlights of this year's Summit and trends he sees in the SQL Server Community.
Is Microsoft SQL Server 2008 Necessary? 2
What are the new features in SQL Server 2008 you are waiting so desperately for? New date/time types for one thing. Nobody can argue with these especially if they include the DATE (only) datatype.
Restart SQL Server Services With One Click
The latest release of SQL Farm Combine 1.8 features a one-click restart of SQL Server services on all network machines to automate SQL patches and multi-server configuration changes.
Microsoft World-Wide Partner's Conference 2007
This conference really highlights the importance of the vendor partners in the overall success of Microsoft.
Quest Introduces New Software
I spoke with Quest Software during TechEd this month for a briefing on Change Director, Performance Analysis, and the latest release of Toad.
Microsoft Acquires Stratature an MDM Software Provider
Microsoft plans deployment of Statature’s MDM software across the SQL Server, Business Intelligence (BI) and Microsoft Office SharePoint technology groups to deliver a unified Master Data Management solution.
SQL Sentry Announces Competitive Upgrade Promotion
SQL Sentry announces a competitive upgrade promotion for companies interested in purchasing SQL Sentry Event Manager software. DBAs can trade in any job scheduling, alerting or automation software tool and receive SQL Sentry Event Manager for free.
What Ever Happened to BI for the Masses?
So what ever happened to “BI for the Masses”? If I had to make a guess after attending last week’s first Business Intelligence Conference put on by Microsoft, I’d say it has become “BI for the Rich Guy.”
Avanade Helps Businesses Align BI Technology and Strategy
Avanade focuses their efforts on helping organizations develop business applications and apply technology to business problems.
DevConnections Kicks Off in Orlando
It's kind of like the Oscars for the SQL world. The who's who of SQL is certainly here and the best part is you can, not only rub shoulders with the experts, you can walk up and ask them questions.
Help for the DATETIME data type and DST on SQL Server
We've noticed a surge in the number of searches for articles on the DATETIME data type on the site lately. We thought a consolidated list of DATETIME articles might come in handy.
SQL Server Pros Stay the Course
Our second annual salary survey shows you the face of the typical database professional.
The Typical SQL Server Pro:
  • White male
  • 30-something
  • Holds a bachelor's degree or higher
  • Been in current job 1-5 years
  • 6-10 years' experience in field
Survey Process

SQL Server Magazine conducted its annual salary survey from August 23, 2005, to September 6, 2005. We sent 30,000 invitations to SQL Server professionals who have opted to receive information from the magazine. We promoted the survey in our UPDATE email newsletters and on our Web site. We offered five $100 American Express gift certificates as an incentive to participate in the survey. A total of 775 respondents provided data for the 61-question survey by the close date. 78 percent of respondents subscribe to SQL Server Magazine.

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