For the most part, you're probably accustomed to using Microsoft Excel for tasks such as preparing reports, forecasts, and budgets. However, Excel is much more powerful than that. It can be used to ...

Small databases of a few rows, to a few thousand rows, can often be created more quickly and easily in Microsoft Excel, than by using a dedicated database system. Excel is available as a stand-alone ...

The daily routine of an IT professional remains largely reactive. A lot of time and budget is spent responding to tickets, limiting the time that we spend creating systems that drive growth and ...

SQL Server 2022: Here’s what you need to know Your email has been sent Three decades on, SQL Server is still a database workhorse that powers both an internal line of business applications and ...

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

Microsoft introduced a new service into its "intelligent edge" portfolio at the recent Build conference. Here's how Azure SQL Database Edge will fit into the company's broader vision for a more ...