Microsoft SQL Server Management Issues

SQL Server 2014 due out in late 2013, in-memory OLTP a big feature

Microsoft announced that the next version of its database, SQL Server 2014, will have in-memory features and be generally available in late 2013.News | 03 Jun 2013

Understanding SQL Server virtualization

These days, virtual servers are often seen as time- and money-saving efforts for businesses. When deciding if going virtual is the right thing to do, it’s important to consider myriad of things, including the age of your physical servers, the amount of data to be migrated to the virtual server, the experience of your IT staff and the I/O benefits.E-Handbook

When to consider SQL Server Enterprise Edition

Is SQL Server Enterprise Edition the right choice for you? Expert Robert Sheldon explains the advantages to consider when making your selection.Feature

SQL Server Standard Edition: Why it's worth the cost

Should your IT shop consider a move to SQL Server Standard Edition? Expert Robert Sheldon explains the pros and cons you should know.Feature

SQL Server editions: Is Microsoft SQL Server Express right for you?

Which SQL Server edition is right for your IT shop? In this article by Bob Sheldon, find out if SQL Server Express is an option.Series

Virtualizing SQL Server? What to keep in mind

Thinking about virtualizing SQL Server? Roman Rehak gives you a rundown about what you should keep in mind when planning your migration.Tip

In-memory SQL Server: The implications of integration

How is in-memory SQL Server different from SQL Server with a bunch of RAM? SQL Server guru Serdar Yegulalp explains what to know before you install.Tip

Excerpt: Planning a Microsoft SQL Server install

For many DBAs, a SQL Server installation can be tough. Read this excerpt from Dusan Petkovic's book on Microsoft SQL Server 2012.Excerpt

Evaluating the ROI of a SQL Server 2008 R2 upgrade

Are we there yet? The slow road to SQL Azure

HIPAA compliance and SQL Server: Tricks and tools of the trade

Find out which tools help attain HIPAA compliance. Lena Weiner profiles HIPAA pro Brandon Leach, who explains the steps needed to secure SQL Server.Feature

Staying hip to HIPAA regulations: How one DBA stays compliant

How do DBAs who adhere to HIPAA regulations get their jobs done while staying compliant? We asked DBA Brandon Leach for some pointers.Feature

Basic SQL Server security best practices

Read this article by Ashish Kumar Mehta to learn the basic SQL Server security best practices everyone should know -- but many forget.Feature

Eight ways that SQL Server developers hurt performance

Application developers who access SQL Server can affect server performance without knowing it. Here are eight things SQL Server developers often do wrong.Tip

Speed up execution times in Microsoft SQL Azure

Compare the time cost of database calls to SQL Azure versus calls to a local server and get recommendations for improving the speed of database calls to SQL Azure.Tip

Cloaked in secrecy, Microsoft project aims to wed SQL, NoSQL databases

Microsoft technical fellow David DeWitt is secretly developing a data management system that can do the jobs of both SQL and NoSQL databases. Can he bring the two sides together?News | 01 Mar 2012

Meet compliance requirements with improved database security practices

Small but consistent changes are the trick to securing your SQL Server database and maintaining compliance with the latest industry rules and regulations.Tip

The fine line between not encrypting your databases and breach notification

Neglecting to encrypt personal information in your SQL Server database can leave your organization vulnerable to certain compliance issues. Get the facts to keep you and your company protected.Tip

Sarbanes-Oxley compliance checklist: IT security and SQL audits

If your SQL Server environment is not yet expected to meet Sarbanes-Oxley (SOX) Act compliance standards, it soon will be. In this tip, SQL Server expert Michelle Gutzait presents security practices, procedures and documentation that prepare you for complying with SOX -- along with checklists that SQL Server administrators and developers can use as a guide for inspecting their systems.Tip

Security testing for compliance -- just how much do you need?

Because of government demands, testing your databases and related SQL Server applications for security flaws is no longer simply on the IT wish list. But how much testing is really necessary? IT security specialist Kevin Beaver notes key systems to test, the "must-have" tools for protecting sensitive information and the best approach for database security testing.Tip

Diving into the Oracle-Microsoft cloud computing deal

Oracle's getting back to its roots, as SQL Azure bites its fingernails (or does it?) Find out why the Oracle-Microsoft deal matters.News | 24 Jun 2013

SQL Server virtualization: When it's just not a good idea

Virtualizing SQL Server is a good idea for many IT shops, but it's not for everyone. Robert Sheldon explains when it might not be a good choice.Tip

Understanding SQL Server virtualization

These days, virtual servers are often seen as time- and money-saving efforts for businesses. When deciding if going virtual is the right thing to do, it’s important to consider myriad of things, including the age of your physical servers, the amount of data to be migrated to the virtual server, the experience of your IT staff and the I/O benefits.E-Handbook

Legacy file systems, away: Dealing with an unsupported file system

When the City of Aurora, Colo. heard that its legacy file system would no longer be supported, it had to act fast.Feature

Why you should think twice about Windows Azure SQL Database

Expert Serdar Yegulalp explains why Windows Azure SQL Database may not be such a great fit for your IT shop after all. Learn what to watch out for.Feature

The pros and cons of virtualizing SQL Server environments

What are the pros and cons of virtualizing SQL Server environments? Basit Farooq takes you through the potential good, bad and the ugly.Tip

The pros of Windows Azure SQL Database

What are the pros of choosing Windows Azure SQL Database over more traditional infrastructure? Serdar Yegulalp shares his knowledge on the subject.Feature

Virtualizing SQL Server? What to keep in mind

Thinking about virtualizing SQL Server? Roman Rehak gives you a rundown about what you should keep in mind when planning your migration.Tip

SQL Server 2012

Microsoft SQL Server 2012 is a relational database management system (RDBMS) designed for the enterprise environment. Like its predecessors, SQL Server 2012 comprises a set of programming extensions to enhance the Structured Query Language (SQL), a standard interactive and programming language for getting information from and updating a database.Definition

database mirroring

Database mirroring is the maintenance of redundant copies of a database to ensure continuous data availability and minimize or avoid downtime that might otherwise result from data corruption or loss, or when the operation of a network is partially compromised.Definition

Adam Machanic talks SQL Saturday

We caught up with Adam Machanic, group leader of the New England SQL Server user group, at SQL Saturday Boston. Find out what he shared with us.Video

HIPAA compliance and SQL Server: Tricks and tools of the trade

Find out which tools help attain HIPAA compliance. Lena Weiner profiles HIPAA pro Brandon Leach, who explains the steps needed to secure SQL Server.Feature

Staying hip to HIPAA regulations: How one DBA stays compliant

How do DBAs who adhere to HIPAA regulations get their jobs done while staying compliant? We asked DBA Brandon Leach for some pointers.Feature

Denny Cherry's SQL Server career -- Is freelancing for you?

Denny Cherry has developed an enviable SQL Server career based on freelancing. Find out how he did it by reading this profile.Profile

SQL Server DBA training and resources for the reluctant DBA

As a reluctant DBA, you may not know where to look for SQL Server DBA resources. This tip by SQL Server expert Don Jones points you in the right direction.Tip

Ramp up your SMB's BI skills

The next frontier of BI skills is undoubtedly the SMB. Read this tip from expert Don Jones to start preparing now.Tip

SQL Server training benefits for non-DBAs

DBAs know the value of SQL Server training. But what are the benefits for non-DBAs? This tip by Serdar Yegulalp examines who should learn more about SQL Server.Tip

Jam session at Microsoft TechEd proves geeks can have fun too

Our associate editor, Lena J. Weiner, went to a jam session at Microsoft TechEd on a specific quest: to prove that geeks are the biggest party animals. Read this article to see what she discovered.News | 27 Jun 2012

TechEd 101: Scoring some ice cream

Knowing your way around the monstrous Microsoft show isn’t always easy, but three show veterans give their take on what works.News | 11 Jun 2012

SQL Kilt Day at PASS Summit 2011

A tradition emerging from the PASS Summit has men slipping into kilts to show solidarity with the Women in Technology interest group.Photo Story

Microsoft’s SQL Server 2012 has muscle, but database battle is fierce

One of the strongest versions Microsoft has put out in years, SQL Server 2012 first needs to accomplish a monumental task -- overcome database inertia, industry watchers say.News | 18 Apr 2012

SQL Server vs. MySQL: Syntax differences, similar GUIs

Discover syntax differences between SQL Server and MySQL, code for a timestamp automation workaround and why it's important to keep your version of MySQL current.Article | 02 Aug 2006

Dumping Microsoft SQL Server: MySQL, PostgreSQL attract big users

Using open source databases doesn't have to be an all-or-nothing decision. Most will work just fine alongside SQL Server.Article | 27 Jul 2006

SQL Server vs. MySQL

Reviewing costs, functionality and implementation techniques, contributor Serdar Yegulalp compares proprietary SQL Server to open source MySQL.Tip

Site offerings at a glance

Here is a quick look at our complete lineup of original content that we update regularly.Article | 01 Mar 2005

CA swings at Oracle, SQL Server with Ingres

Computer Associates is pitching the mature features and 64-bit support of its open sourced Ingres database at Oracle and Microsoft SQL Server customers.News | 23 Feb 2005

Former Oracle DBA falls for SQL Server

Meet Kevin Kline, a former Oracle DBA and a current SQL Server expert, and find out why Microsoft gets him all worked up.News | 23 Feb 2005

Oracle 10g priced to compete with SQL Server

The entry-level version of the new Oracle 10g database comes with a price reduction that could spark intense competition with Microsoft SQL Server.News | 23 Feb 2005

SQL Server pros aren't charmed by open source

Increased competition from open source hasn't affected SQL pros. DBMS shoppers put cost second to features and support --- two areas where some DBAs say open source is deficient.Article | 18 Oct 2004