Tips

Tips

• Q&A: Getting the lowdown on Master Data Services for SQL Server

  With Master Data Services, Microsoft says it’s answered the call for a focused way of taking on Master Data Management. A company expert explains how and why it’s done that.  Continue Reading

• Top 5 things you must do to SQL Server

  Want to make your SQL Server installations safer and better-performing? Do these easy things right away.  Continue Reading

• Are we there yet? The slow road to SQL Azure

  SQL Azure offers full-blown SQL Server functionality in the cloud and could ease management and development. But whether it’s ready to fully replace SQL Server remains to be seen.  Continue Reading

• Do you need to harden SQL Server 2008 R2?

  Some say systems like R2 come so secure out of the box that traditional hardening need not apply. But when it comes to security, there’s still plenty to do beyond the defaults.  Continue Reading

• BI for SMBs: What's good for the big boys might be bad for you

  Microsoft’s business intelligence stack is just one of the options available for midsized companies looking to implement a customized (and cost-effective) BI strategy.  Continue Reading

• Exploring T-SQL metadata functions in SQL Server 2008

  Metadata functions in T-SQL can help uncover information about database names, objects and more. Learn the basics of metadata functions and how to apply them here.  Continue Reading

• Uncovering database file information with T-SQL metadata functions

  Admins can use metadata functions to reveal detailed information about SQL Server files and filegroups, including file names, IDs and file properties.  Continue Reading

• 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

• 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

• 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