A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

The PowerShell community is a treasure trove of amazing modules and scripts that you can find online and use in your day-to-day operations. It doesn't matter the platform or the purpose, there is ...

SQL Server 2008 Installation Strategies and Best Practices Part 2 of 5 Greetings, last week I initiated this blog series which focuses on best practices and installation strategies when deploying SQL ...

One of the nice things about the Windows Server Manager is that Microsoft has chosen to integrate the Best Practices Analyzer. The Best Practices Analyzer is a tool that is designed to scan a Windows ...

Windows Server 2008 R2 goes further and contains something called the “Best Practices Analyzer,” which is not exactly one thing but a combination of things built around something called the BPA ...

Microsoft at its Tech Ed conference in San Diego on Tuesday will tout plans to add data encryption to its SQL Server database and seek federal government security certification for the platform as ...

The only constant is change – this goes for your data too. There is a critical need to cleanse and validate data when it’s received and on a regular basis. But how can you leverage the SQL Server tool ...

SQL Server 2012 reached End of Support in 2022 after being a mainstay for many SMBs over the past decade. Continuing to run this SQL Server version, especially on mission-critical production systems, ...

First, the QA’s overall usability has been enhanced. It’s easier to use, partly because more information is now readily available. For example, you no longer need to query for the current connection’s ...