Tips

Tips

• Inspecting property settings with T-SQL metadata functions

  There are plenty of other uses for SQL Server 2008 metadata functions beyond just the basics. This includes the ability to view object properties, such as columns and data types.  Continue Reading

• Using file_guid as a unique identifier for SQL Server instances

  DBAs can use the file_guid property to create a globally unique identifier for one or all of their SQL Servers by following a few simple steps.  Continue Reading

• Top seven things you don’t know about SQL Server 2008 R2

  By now, everyone knows about PowerPivot and MDS. But while high-profile features like those have gotten most of the press, other changes to R2 have fallen under the radar.  Continue Reading

• Top five things you’re doing wrong with SQL Server

  Are you hindering SQL Server without even knowing it? Check out the top mistakes DBAs often make with some quick fixes for better performance.  Continue Reading

• Getting started with Microsoft SQL Azure Database

  Get a taste of Microsoft’s SQL Azure service for the cloud, and learn how it does (and doesn’t) compare to on-premise SQL Server functionality.  Continue Reading

• SQL Server index tuning for peak performance

  Without the correct table indexes, SQL Server performance will quickly suffer. Here are a few tricks every DBA should know.  Continue Reading

• An introductory look at T-SQL system functions

  Get the basics on working with various system functions in T-SQL to help assess the finer details of your data.  Continue Reading

• Digging deeper with T-SQL system functions and language tools

  Learn how system functions can be used in T-SQL to view general session and system information along with other types of data in Microsoft SQL Server.  Continue Reading

• Three strategies for launching business intelligence in your company

  Small companies looking to get started with BI can ensure a successful implementation by following a few important tips.  Continue Reading

• Sysprep utility speeds up SQL Server 2008 R2 deployments

  A Windows staple for years, the Sysprep tool has finally made its way over to the SQL Server world with the release of R2.  Continue Reading

• The basics of SMO scripting for database objects

  The use of SQL Server Management Objects streamlines the process of scripting database objects, allowing DBAs and developers to customize code using basic SMO scripting know-how.  Continue Reading

• Dissecting the SELECT query syntax in T-SQL

  With so many possible options and extensions, translating complex SELECT statements can be a challenge. DBAs can clear the air by breaking them down piece by piece.  Continue Reading

• Q&A: SQL Server business intelligence meets the cloud

  Microsoft’s Mark Kromer offers his thoughts on the current state of cloud-based BI and what technologies like SQL Azure and PowerPivot can do for organizations.  Continue Reading

• SQL Server tool alleviates documentation headaches

  Many database pros dread the hassle of SQL documentation. Fortunately, the right tool can speed up and simplify the process considerably.  Continue Reading

• Weighing the performance impact of SQL Server indexes

  While the right indexes can boost readability, the wrong ones can really slow down write operations. DBAs need to strike the proper balance to ensure peak performance.  Continue Reading