Evaluate
Weigh the pros and cons of technologies, products and projects you are considering.
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