DBAs have many options for how to ensure high availability (HA) for SQL Server. Some of these options are available in the different versions and editions of SQL Server itself. Some are available in ...

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...

Join our daily and weekly newsletters for the latest updates and exclusive content on industry-leading AI coverage. Learn More At the PASS Data Community Summit in Seattle today, Microsoft announced ...

As SQL Server 2005 approaches its scheduled end of life, higher ed must decide what to do with existing SQL Server databases. Brien M. Posey is a freelance technical writer who has contributed to ...

The public cloud offers a myriad of options for providing high availability and disaster recovery protections for SQL Server database applications. Conversely, some of the options available in a ...

At the Ignite conference today, Microsoft made a series of announcements about Azure databases. It announced a brand-new Azure database called HorizonDB, which is a fully managed PostgreSQL database ...

We’re all familiar with the IT “war room” scenario. When there’s an issue, members of the IT team come together to troubleshoot and find a solution. For organizations with important applications, such ...

As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...

While the cloud continues to grow in popularity for many, if not most, enterprise applications, IT departments remain reluctant to trust public clouds, including the Google Cloud Platform, for ...