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
-
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
-
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
-
BI for the SMB: Don't give away business intelligence
With the various challenges SMBs face, securing their business intelligence efforts may seem unimportant. Not so, says expert Don Jones. Find out why.04 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
-
SQL Server management trick: Connecting when admins are locked out
How do you connect to SQL Server when all admins have been locked out? Read this tip from Ashish Mehta and learn a new SQL Server management trick.24 Aug 2012
-
Great new SSIS features for BI developers
SQL Server 2012 has many features, but a few make SSIS much easier for BI developers. Check out this tip by expert Robert Sheldon to learn more.21 Aug 2012
-
SQL Server DBA training and resources for the reluctant DBA
As a reluctant DBA, you may not know where to look for SQL Server DBA resources. This tip by SQL Server expert Don Jones points you in the right direction.17 Aug 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
-
T-SQL tricks for SQL Server 2012: T-SQL statements
In the final part of Robert Sheldon's series on features and tricks in T-SQL, learn about important T-SQL statements like LAG, LEAD and more.10 Aug 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
-
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