Kathy Blomstrom


Kathy Blomstrom is former managing editor of SQL Server Magazine.

Foundation for the Future
In an exclusive interview with SQL Server Magazine, Gordon Mangione, Microsoft's new vice president for SQL Server, talks about SQL Server's central role in the .NET strategy.
Microsoft Posts Fix for Visual Studio's T-SQL Debugger 1
Microsoft has posted a downloadable fix for a problem with the T-SQL debugger in Visual Studio 6.0, Enterprise Edition.
Microsoft Releases Analysis Services Performance Fix
A new Microsoft article, "FIX: Query Performance Slower When Client Locale Differs from Server Locale," explains a fix for a known SQL Server 2000 Analysis Services problem.
Microsoft Releases SP2 for Office 2000 Developer Tools
Microsoft's new Office 2000 Developer Tools Service Patch 2 (SP2) updates the Workflow Designer for SQL Server to support SQL Server 2000 and includes the latest updates for the Visual Basic for Applications (VBA) tools.
Support WebCast: SQL Server 2000 Multiple Instances
Microsoft will host a WebCast about SQL Server 2000's multiple-instance support Thursday, March 22, at 10 AM (Pacific time).
SQL Server 2000 Wins eWEEK eXcellence Award
SQL Server 2000 has claimed eWEEK's 2001 eXcellence Award for best enterprise systems development tool.
Microsoft Releases Fix for Replication Problem
SQL Server 7.0 Service Pack 3 (SP3) includes a fix for a problem with transactional replication of updates.
Microsoft to Host Log-Shipping WebCast
Microsoft will host a Support WebCast about SQL Server 2000's log-shipping functionality February 15 at 10 A.M. (Pacific time).
Microsoft Articles Clarify SQL Server Functions
Microsoft has posted two new Knowledge Base articles that clarify how the ODBC driver for SQL Server 2000 and 7.0 returns messages from certain commands and how to create a SQL Server 2000 Blackbox trace.
WebCast to Cover SQL Server 2000 Windows CE Edition
Microsoft will host an overview of the SQL Server CE architecture during a January 25 WebCast at 10 A.M. (Pacific time).
Microsoft Articles Cover Transferring Logins with DTS and a Stored Procedure Bug
Microsoft has posted two new Knowledge Base articles for SQL Server: one that explains how to transfer logins and passwords between SQL Server 2000 or SQL Server 7.0 servers and one that provides workarounds for a SQL Server 2000 stored procedure bug.
Support WebCast: Understanding INSTEAD OF Triggers
Microsoft will host a support WebCast January 16 at 10 A.M. (Pacific Time) about SQL Server 2000's new INSTEAD OF trigger support.

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 29, 2015

Data Breaches and Insider Threats

I’ll sound a bit like Captain Obvious for bringing this up, but it’s important to remember that security encompasses a lot more than protecting sensitive data from the specter of outsider threats like hackers. Properly implemented security policies also account for threat-models that include insiders – or people within your organization....More
Sep 15, 2015

Setting Up Additional Checks to Ensure Regular Transaction Log Backups 1

There’s simply no way to overstate the importance of regular Transaction Log Backups. Not only do they help protect from disaster, but regular execution of T-Log backups on Full (and Bulk-Logged) Recovery databases helps keep thing “fit and trim”. Most of the time, setting up a Notification for when T-Log Backup Jobs fail is enough to let you know when something goes wrong....More
Sep 1, 2015

Stop Using INFORMATION_SCHEMA and SysObjects for Exists Checks 3

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