Caroline Marwitz

Caroline
Marwitz

 Caroline edits SharePoint Pro Magazine.

Articles
Considering SQL Azure 5
Is SQL Azure a possible alternative to on-premise SQL Server? Whether you're a developer or a DBA, you need to keep tabs on this technology.
Using SharePoint? Who Isn't? - 10 Aug 2009
SharePoint is the bright light in this deep recession--so how come you're not using it?
Backup Solution Aims to Help DBAs Turned Accidental SharePoint Admins
A SharePoint backup and recovery solution that might leave you more time for your other duties, like being a DBA.
Visual Studio Security Tool Released
Developers can write more secure software without having to become security experts, Microsoft says, with its SDL Process Template for Visual Studio Team System.
SQL Server Mission-Critical Support from Microsoft
When SQL Server goes down, you need mission-critical support--Microsoft aims new service at reducing downtime.
Microsoft Admits New SQL Server Vulnerability - 23 Dec 2008
Attackers exploiting a SQL Server vulnerability could remotely execute code.
SQL Server Permissions Management with ScriptLogic
ScriptLogic announced Security Explorer for SQL Server.
Probing for Vulnerabilities to Harden SQL Server
Security solution provider Fortinet offers an appliance that scans, assesses, and advises on securing your SQL Server databases (and it does Windows, too).
Database Encryption Solutions 2
Database encryption can protect your data from internal and external attacks. When choosing a solution, consider who you are protecting data for and who you are protecting it from, along with any compliance regulations.
Protecting the Database With Encryption 2
Thinking about database encryption? How do you select such a beast? That question assumes you recognize the need to protect your database from inside as well as outside threats. Do you?
ChangeAuditor 4.5 Offers Real-Time Auditing for SQL Server
Options for auditing your SQL Server databases just got more granular with NetPro's recent release.
LogRhythm 4.0 Manages, Organizes, Analyzes Logs

"Every log has potential value." If an executive had a mantra, this might be the one of LogRhythm execs Chris Peterson and Mike Reagan, CTO and vice president, respectively. You might not be surprised to learn, then, that LogRhythm is a log and security event management solution provider.

The Hedgehog and the Database: Sentrigo Crosses over to SQL Server

Sentrigo has added support for SQL Server to its database activity-monitoring solution, Sentrigo Hedgehog 2.0. The company wanted to move to being a cross-platform solution, and SQL Server was the logical next choice, say Slavik Markovich, Sentrigo’s CTO, and Rani Osnat, Sentrigo’s vice president for marketing. Sentrigo plans to add support for SQL Server 2008 also.

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