Joey on SQL Server An Easy Way To Modernize Your SQL Server Environment There used to be few good options for a DBA with a bunch of systems stuck on SQL Server 2008. But thanks to one easy trick ...

Maintaining a SQL Server environment is a potentially complex endeavor. Here are 10 tips for ways you can minimize complexity and reduce stress. Based on my SQL Server consulting practice, here ...

In preparing for the Microsoft 70-764 SQL Server 2016 Certification Exam, you'll learn all about administering a Microsoft SQL Server 2016 with backup strategies and methods of encryption.

SQL Server 2016 will provide a migration wizard that helps administrators select and configure database instances in Microsoft Azure and then move system objects and SQL Server settings along with ...

The SQL Server MP helps monitor your application by monitoring database activity. The management pack provides proactive and reactive monitoring of your SQL Server environment.

For SQL Server instances requiring a high level of availability, there are several options. The traditional choice in a Windows environment is to deploy a SQL Server failover cluster instance (FCI).

For these companies, help is on the way! SQL Server 2008 has a new feature called Policy-Based Management (PBM). PBM is a way to set behavioral policies for groups of servers and then manage the SQL ...

With these various goals and caveats in mind, I’ll give you a few basic pointers for locking down your SQL Server environment. Some tips will help protect you from breaches, while others will ...

The strategic migration and consolidation of SQL server farms to the cloud, supported by automation technology, can result in benefits and pave the way for continued innovation, data utilization ...