Editors' Picks
-
Six SQL Server management tools you can't live without
Expert Ashish Kumar Mehta lists six important SQL Server management tools, including BIDS, SSMS and SSDT.22 Aug 2013
-
How to start and set up SQL Server Audit
Get an overview of the SQL Server Audit process, and check out the details for defining a target, setting up specifications and reading logged events.09 Jul 2013
-
The lowdown on SQL Server auditing tools
Learn about the various components of SQL Server auditing tools such as server and database audit specifications as well as action groups.08 Jul 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
-
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
-
SQL Server 2012 security: Changes for the newest version
SQL Server 2012 is here, and many DBAs wonder what kinds of changes to expect in SQL Server security. Basit Farooq explains what we can anticipate.06 Dec 2012
-
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
-
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
-
Further SSIS tips: Parameters and undoing operations
Learn more new tips and tricks for SSIS from expert Robert Sheldon. Check out the last of a three-part series on changes to this important tool.04 Sep 2012
-
Different ways to audit SQL Server security
Strong SQL Server security has become a more important part of a robust defense. But what are your options for security auditing?17 Aug 2012
-
SharePoint performance sinks, swims with SQL Server throughput
To help ensure that SharePoint performance doesn’t get bogged down, organizations need to build and maintain a scalable back-end database system that can eliminate SQL Server disk I/O issues.11 Jul 2012
-
Dispersed organizations test mettle of SharePoint 2010 infrastructure
Combine basic SharePoint 2010 infrastructure management with end-user monitoring and third-party tools to effectively manage SharePoint for a dispersed organization, says consultant Shawn Shell.20 Jun 2012
-
SQL Server log shipping offers path to SharePoint disaster recovery
Brien M. Posey describes how to enable disaster recovery for SharePoint 2010 using SQL Server log shipping. It’s one way to back up data to a secondary SharePoint farm to prepare for the worst.04 Jun 2012
-
Plan ahead for a smooth SQL Server migration
The thought of a SQL Server migration makes many organizations nervous, but they don’t have to be, writes consultant Don Jones. Get tips on making the switch simple.20 Feb 2012
-
New to SQL Server PDW? First, tinker with client tools
Stepping into the SQL Server PDW environment means learning a whole new set of client tools. Learn about each as you take on Microsoft’s Parallel Data Warehouse.02 Nov 2011