Editors' Picks
-
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
-
Q&A;: With SQL Azure, Microsoft eyes giant leap to the cloud
It was cloud, cloud, cloud at Microsoft TechEd 2011. Microsoft’s Mark Kromer discusses the SQL Azure, what’s new with the cloud database offering and what’s to come.07 Jun 2011
-
Microsoft System Center Virtual Machine Manager backup techniques
Learn how to back up Virtual Machine Manager in this tip, and how to perform a manual and a scripted backup.18 May 2011
-
Microsoft System Center Virtual Machine Manager backup techniques
Learn how to back up Virtual Machine Manager in this tip, and how to perform a manual and a scripted backup.18 May 2011
-
Securing SQL Server data in the cloud: a few pointers
Few concerns swirling around Microsoft cloud computing are more consuming than securing SQL data in the cloud. Can it be done? Certainly, but it’s not to be taken lightly.10 May 2011
-
Finally, development across platforms in Microsoft Visual Studio 2010
Microsoft says Project Juneau, its toolset for Microsoft Visual Studio 2010 expected to be rolled out with the upcoming SQL Server Denali, will break new ground in development.22 Apr 2011
-
Third-party tool for SQL Server outshines IntelliSense in SSMS
IntelliSense in SSMS is Microsoft’s answer to developer pleas. But there is competition from a third-party tool for SQL Server -- SQL Prompt.05 Apr 2011
-
How the SQL Server Utility can make solutions providers money
For customers hesitant to upgrade to SQL Server 2008 R2, the SQL Server Utility may be the remedy. Learn how to use the tool and explain to your customers how it can save them on management costs.01 Mar 2011