Editors' Picks
-
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.23 Jan 2013
-
Why SQL Server security matters: A case study
With a DBA's multiple responsibilities, it's easy to neglect SQL Server security. This case study by Basit Farooq explains why this is so dangerous.28 Nov 2012
-
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.19 Nov 2012
-
Introduction to SQL Server 2012 Express LocalDB
SQL Server 2012 Express LocalDB is a good way for developers to be able to play around with SQL Server 2012. Learn how to install and get started with it.24 Oct 2012
-
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.23 Oct 2012
-
Coding for seamless SQL Server database mirroring
SQL Server database mirroring can provide high availability to your database. Expert Roman Rehak shares his favorite pieces of code for flawless mirroring.22 Oct 2012
-
SQL Server stored procedures vs. CLR stored procedures: Time to migrate?
Should you use SQL Server stored procedures or CLR stored procedures? Expert Serdar Yegulalp helps you decide which is more appropriate for you.22 Oct 2012
-
Managing linked server security in SQL Server
What do you need to know to effectively manage your linked server? Find out in this tip from SQL Server expert Roman Rehak.02 Oct 2012
-
Best practices for preventing a SQL injection attack
One of the sneakiest ways for a hacker to invade your system is via a SQL injection attack. Expert Robert Sheldon explains how to keep hackers out.17 Sep 2012
-
SQL Server security: The implications of user-defined roles
SQL Server security is a topic on many DBAs' minds. But what are the implications of user-defined roles? Expert Serdar Yegulalp explains.11 Sep 2012
-
More new features for SSIS 2012: Connection managers and more
In the second part of this series on new features, by Robert Sheldon, learn more ways the latest version of SSIS will make BI development simpler.24 Aug 2012
-
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.18 Apr 2012
More Like This
-
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.23 Jan 2013
-
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.14 Feb 2013
-
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.30 Jan 2013
-
Introduction to SQL Server 2012 Express LocalDB
SQL Server 2012 Express LocalDB is a good way for developers to be able to play around with SQL Server 2012. Learn how to install and get started with it.24 Oct 2012
-
SQL Server meets database application security
Make sure your SQL Server is secure by studying these general guidelines for secure database applications from SQL Server expert Roman Rehak.08 May 2013
-
Understanding Microsoft SQL Server business intelligence options
Microsoft has made a great effort to turn SQL Server into a viable enterprise database platform, and part of that has been boosting its business intelligence capabilities. In this handbook, read ab...07 May 2013
-
xVelocity Columnstore Indexes in SQL Server 2012
Curious about how xVelocity can help with your columnstore indexes? Check out this tip from Basit Farooq to find out.29 Apr 2013
-
Useful SQL Server 2012 features to become familiar with
SQL Server expert Basit Farooq shares his favorite SQL Server 2012 features you might not yet know. Read this tip to learn more.25 Apr 2013