Editors' Picks
-
SQL Server 2014 all about big data, in-memory analytics and cloud
In this issue of SQL in Five, Mark Kromer lists usual features of the upcoming SQL Server 2014, but also highlights a different one: Data Explorer.21 Jun 2013
-
Microsoft SQL Server security best practices checklist
Authentication, complex passwords and limiting permissions are three of the top bullet points on this SQL Server security best practices checklist.20 Jun 2013
-
SQL Server 2014 'keeps up with the Joneses,' says analyst
Ovum analyst Tony Baer says that most database platforms are moving toward in-memory features, and SQL Server 2014 is no different.12 Jun 2013
-
SQL Server high availability: Natural enemy of virtualization?
Do SQL Server high availability and virtualization go together or not? Find out if virtualization is a good option for you in this tip by Bob Sheldon.05 Jun 2013
-
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.03 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.30 May 2013
-
Database index design and optimization: Some guidelines
What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more.21 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 Roman Rehak shares his favorite SQL Server 2012 features you might not yet know. Read this tip to learn more.25 Apr 2013
-
Intel boosts Moore's Law with SQL 2012 business intelligence
Intel is keeping Moore's Law on track with the self-service BI features of SQL 2012 business intelligence.25 Apr 2013
-
Microsoft unveils GeoFlow 3-D SQL Server mapping tool
Microsoft GeoFlow gives premium Excel users the ability to do 3-D mapping with SQL Server on the back end.15 Apr 2013
-
Solving SQL VSS writer problems during backup
Backup expert Brien Posey explains how to solve common SQL VSS writer problems users can face during SQL database backups.05 Apr 2013
-
SQL Server big data technologies should be a major DBA focus
Microsoft platform architect Mark Kromer says in this Q&A; that DBAs need to start focusing on SQL Server big data technologies to stay up-to-date.25 Mar 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
-
Preparing for your SQL Server scale-out
It's never too early to prepare for a SQL Server scale-out. Read this tip from Roman Rehak to learn three popular ways to scale out SQL Server.22 Jan 2013
-
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.09 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
-
SQL Server DBAs must get ready to take on 'big data' and more roles
Leaders of the Professional Association for SQL Server say today's DBAs have to handle 'big data' and more types of tasks than ever before.14 Nov 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