Knowing what you want from SQL Server is probably the biggest step toward running it successfully in business applications, according to consultant Koen Verbeeck. It's not just about knowing how SQL ...

Cloud-based systems have become the IT infrastructure of choice for many organizations, in all industries and of all sizes. Users can now choose from a seemingly endless array of cloud platforms, ...

This template provides a baseline for evaluating enterprise DBA candidate’s skill set, ranging from application deployment support to database design.

I'm supposed to be a software developer/consultant. However, I'm also the guy people look at when the application isn't running "fast enough." With business applications, speeding up the application ...

There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version. For database admins working with older (maybe much older) SQL Server systems, here are four ...

Modern software development teams have adopted a continuous delivery approach based upon DevOps and agile development techniques. The small and frequent code changes that result from such ...

At Microsoft’s Ignite digital event this week, the company is announcing the private preview of SQL Server 2022, the next version of its three-decades-old relational database management system (RDBMS) ...

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in ...

New Tool Analyzes SQL Server Master Database File (MDF) and Index Fragmentation, Totally Automates End-to-End Defragmentation There is no other product in the industry that allows me to address Master ...

SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...