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
Sep 1, 2015
blog

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks

Code like this isn’t optimal: IF EXISTS(SELECT * FROM sys.objects WHERE name = N'TableToDrop' AND type = 'U')         DROP TABLE TableToDrop; GO Neither is this: IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TableToDrop')         DROP TABLE TableToDrop; GO Yet, I see both of those used all of the time – over and over again. Even though it’s 2015.  ...More
Aug 27, 2015
blog

A Replacement for Maintenance Plan Backups 1

This blog post is a bit of a ‘repeat’ – since I already covered much of the rationale behind this post in Part 23 of my multi-part series on AlwaysOn Availability Groups and SQL Server Agent Jobs. But, I also figured that this is enough of an important topic to merit its own blog post....More
Aug 19, 2015
blog

Looking forward to Containers

Virtualization has long been a staple when it comes to computing. In essence, virtualization is really just the use of abstraction to make things either easier to manage or more fault-tolerant. Disks, for example, have long been virtualized in the sense that a single, physical, can easily be divided up into multiple logical (or virtual) volumes (or drives) just as easily as a number of discreet physical disks can also be virtualized into a single drive (via RAID) – which can further be partitioned into volumes, LUNs, and so....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) ×