Editors' Picks
-
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 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
-
Microsoft releases SQL Server 2014 CTP 2
This is the last Community Technology Preview (CTP) for SQL Server until it becomes generally available in the first half of next year.17 Oct 2013
-
SQL Server views: Creating indexes and adding base data
SQL Server views allow you to give information to users without compromising security. Find out how to create indexes on them and add base data.25 Oct 2013
-
Set database constraints using SQL Server Management Studio Table Designer
In addition to creating tables and adding columns, SQL Server Management Studio Table Designer can also set constraints.17 Oct 2013
-
Manage your SQL Server databases with SQL DMVs
SQL DMVs (dynamic management views) can help simplify administration of SQL Server databases. Find out how with detailed examples.11 Sep 2013
-
Guide to SQL Server data management and data quality
This Essential Guide offers expert advice for improving enterprise data management and quality with SQL Server tools and services.07 Oct 2013