Evaluate

Microsoft SQL Server Performance Monitoring and Tuning

• Pros and cons of using SQL Server audit triggers for DBAs

  Using triggers to capture audit information in SQL Server can be instrumental in keeping track of database use and changes. But they aren't a perfect fit for all cases. Continue Reading

• A quick tutorial on SQL Server maintenance plans

  SQL Server maintenance plans get a bad rap, but for DBAs who need a simple way to maintain databases, Microsoft's built-in tools are a good place to start. Continue Reading

• Four free SQL Server tools every DBA can use

  Various performance issues can arise in the day-to-day grind of managing databases. We've rounded up four free SQL Server tools that can help make DBAs lives a little bit easier. Continue Reading

• SQL Server SSD technology becoming a solid storage choice

  With recent improvements in solid-state drive technology, it's time to consider SSD devices for SQL Server storage uses. SSDs can address I/O performance problems, but wear is a worry. Continue Reading

• Comparing memory-optimized tables and disk-based tables

  In all tests performed by expert Basit Farooq, memory-optimized tables outperformed disk-based tables by running faster and generating less disk I/O. Continue Reading

• Enbridge Inc. to virtualize all its servers

  Energy company Enbridge Inc. is in the process of virtualizing all of its servers to increase flexibility and cut costs. Not everyone is happy with this new direction.Continue Reading

• Mavis Tire goes SANless with SIOS DataKeeper

  With DBAs rewarded for server performance and SAN specialists rewarded for server capacity, there can be a tug of war. Mavis Tire goes SANless with SIOS DataKeeper. SIOS Technology releases a survey about high availability and SAN.Continue Reading

• The dark side of Microsoft SQL Server Express

  Don Jones explains why Microsoft SQL Server Express can be more dangerous than you'd think and why it might be worth it to invest in the paid edition.Continue Reading

• What to consider when deploying In-memory OLTP in SQL Server 2014

  In this expert answer, Michael Steineke from Edgenet talks about what to consider when deploying In-memory OLTP in SQL Server 2014.Continue Reading

• SQL Server 2012 ‘virtually’ out, Microsoft talks features, licensing

  With SQL Server 2012 released in a “virtual launch” this month, Microsoft data platform specialist Mark Kromer tells us what his favorite features of the new release are.Continue Reading

• Q&A: New Microsoft products focus on configuration, virtualization

  There’s been a slew of new Microsoft products lately, including an upgrade for Project Atlanta. A company expert discusses this development, third-party tools and more.Continue Reading

• 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.Continue Reading

• Three third-party tools for SQL Server you need to have

  SQL Server is packaged with an array of management tools, but it’s not complete. Several third-party tools for SQL Server can help with monitoring, backup and capacity management.Continue Reading

• A guide to advanced new features in SQL Server Management Studio 2008, part 2

  SQL Server Management Studio 2008 has several new features, including the T-SQL Debugger for easier debugging and a new Object Explorer Details window that's easier to use.Continue Reading

• Top 10 SQL Server Tips of 2008

  Here are the top 10 SQL Server tips of 2008. From stored procedures that determine table and log file size to the basics of DATETIME and SMALLDATETIME in SQL Server 2005 and date/time value data conversions, these are the most viewed ...Continue Reading