Editors' Picks
-
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
-
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
-
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
-
Making sense of SQL Server 2012 virtual environment licensing
SQL Server 2012 licensing is complicated enough. Now add in SQL Server virtual environments and try not to let your head spin.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
-
T-SQL analytic functions in SQL Server can help solve problems quickly
With the help of T-SQL analytic functions, we can quickly solve complex analytical tasks. Learn more from SQL Server expert Basit Farooq.20 Sep 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