Kathleen Long, Author at Virtual-DBA Remote DBA Services & Support - Certified Database Experts Remote Database Administration Thu, 01 Aug 2024 07:03:24 +0000 en-US hourly 1 https://wordpress.org/?v=6.9.4 https://virtual-dba.com/wp-content/uploads/cropped-VirtualDBA-favicon-32x32.png Kathleen Long, Author at Virtual-DBA Remote DBA Services & Support - Certified Database Experts 32 32 Understanding SQL Server 2022 Authentication Methods https://virtual-dba.com/blog/understanding-sql-server-authentication-methods/ https://virtual-dba.com/blog/understanding-sql-server-authentication-methods/#respond Tue, 16 Jul 2024 21:05:39 +0000 https://virtual-dba.com/?p=242354 SQL Server Authentication Methods Demystified SQL Server authentication methods are crucial for ensuring secure and efficient access to your database. In this blog, we will explore various authentication options, detailing their benefits and disadvantages to help you choose the best method for your organization. Understanding these methods can significantly enhance your database security and streamline […]

The post Understanding SQL Server 2022 Authentication Methods appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/understanding-sql-server-authentication-methods/feed/ 0 Why Migrate to SQL Server 2022 https://virtual-dba.com/blog/why-migrate-to-sql-server-2022/ https://virtual-dba.com/blog/why-migrate-to-sql-server-2022/#respond Thu, 11 Jul 2024 21:39:53 +0000 https://virtual-dba.com/?p=242343 Introduction Businesses rely on robust database systems to manage critical information in today’s data-driven world. SQL Server, a stalwart in the database landscape, has evolved over the years, and SQL Server 2022 brings a host of compelling features that make migration a strategic move. Let’s explore why upgrading to SQL Server 2022 is not just […]

The post Why Migrate to SQL Server 2022 appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/why-migrate-to-sql-server-2022/feed/ 0 The Vital Role of DBAs in Cloud Alert Management https://virtual-dba.com/blog/vital-role-of-dbas-in-cloud-alert-management/ https://virtual-dba.com/blog/vital-role-of-dbas-in-cloud-alert-management/#respond Thu, 30 May 2024 22:56:41 +0000 https://virtual-dba.com/?p=242282 In the era of cloud computing, where data is the new currency, databases are the backbone of modern businesses. They store, manage, and retrieve critical information for decision-making and operations. However, ensuring cloud databases’ seamless functioning requires constant vigilance and proactive measures. This is where Database Administrators (DBAs) come in, serving as the guardians of […]

The post The Vital Role of DBAs in Cloud Alert Management appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/vital-role-of-dbas-in-cloud-alert-management/feed/ 0 SQL Server 2016 End of Mainstream Support and How It Affects Your Business https://virtual-dba.com/blog/sql-server-2016-end-of-mainstream-support/ https://virtual-dba.com/blog/sql-server-2016-end-of-mainstream-support/#respond Thu, 17 Jun 2021 17:54:12 +0000 https://virtual-dba.com/?p=238412 July 13th, 2021 is quickly approaching. This is the date Microsoft has announced as the end of Mainstream Support for SQL Server 2016. What does this mean for the large number of Servers and applications using SQL Server 2016? You feel like you just completed your last migration project, do you have to start all […]

The post SQL Server 2016 End of Mainstream Support and How It Affects Your Business appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/sql-server-2016-end-of-mainstream-support/feed/ 0 SQL Server Instance, Login, Database, Schema, User https://virtual-dba.com/blog/sql-server-instance-login-database-schema-user/ https://virtual-dba.com/blog/sql-server-instance-login-database-schema-user/#respond Thu, 28 Feb 2019 17:48:31 +0000 https://virtual-dba.com/?p=35566 What’s in a name? When it comes to different Relational Database Management systems (RDMS) it can be confusing. The same words have different meaning depending on the software. SQL Server Database Engine has Instances, Logins, Databases, Schema, and User. When a DBA is used to a different database platform the terms can cause some confusion. […]

The post SQL Server Instance, Login, Database, Schema, User appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/sql-server-instance-login-database-schema-user/feed/ 0 Firewalls at the database Level for Azure SQL https://virtual-dba.com/blog/firewalls-database-level-azure-sql/ https://virtual-dba.com/blog/firewalls-database-level-azure-sql/#respond Thu, 21 Jun 2018 16:34:40 +0000 https://virtual-dba.com/?p=34946 Azure SQL has introduced the ability to set firewall rules at the database level. A database firewall is different than the server firewall which can be configured via the Azure Portal. The database firewall gives you the ability to not only limit connections at the Azure SQL Server level but also at the database level. […]

The post Firewalls at the database Level for Azure SQL appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/firewalls-database-level-azure-sql/feed/ 0 Different High Availability Offerings in SQL Server 2016 https://virtual-dba.com/blog/high-availability-offerings-sql-server/ https://virtual-dba.com/blog/high-availability-offerings-sql-server/#respond Wed, 02 Aug 2017 16:10:04 +0000 https://virtual-dba.com/?p=33761 This is a high-level description of the different High Availability Offerings in SQL Server 2016, meant to give a general idea of what is offered and the limitations for each offering. AlwaysOn High Availability Groups When most people use the terms AlwaysOn they are referring to AlwaysOn Availability Groups. This is a hybrid of the […]

The post Different High Availability Offerings in SQL Server 2016 appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/high-availability-offerings-sql-server/feed/ 0 SQL Server 2016 Database Engine: New Features and Enhancements https://virtual-dba.com/blog/sql-server-2016-new-features-enhancements/ https://virtual-dba.com/blog/sql-server-2016-new-features-enhancements/#respond Tue, 07 Feb 2017 15:00:55 +0000 https://virtual-dba.com/?p=29227 XTIVIA is highlighting new features in SQL Server 2016! We can set you up with all the exciting new features available in SQL Server 2016. Here’s how implementing new features will benefit your SQL Server environment. Stretch Database Stretch Database allows you to keep your most recent production data local to your location but migrate […]

The post SQL Server 2016 Database Engine: New Features and Enhancements appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/sql-server-2016-new-features-enhancements/feed/ 0 Differences Between Windows and SQL Server Authentication https://virtual-dba.com/blog/differences-windows-sql-server-authentication/ https://virtual-dba.com/blog/differences-windows-sql-server-authentication/#respond Fri, 16 Dec 2016 17:42:31 +0000 https://virtual-dba.com/?p=28627 A common question asked from super users of applications is, “What is the difference between Windows Authentication and SQL Server Authentication?” While there are many details under the covers of SQL Server and Windows Authentication, the differences can be summed up as follows. Windows Authentication Windows authentication means the account resides in Active Directory for […]

The post Differences Between Windows and SQL Server Authentication appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/differences-windows-sql-server-authentication/feed/ 0 Improving Foreign Key Performance with Indexing https://virtual-dba.com/blog/improving-foreign-key-performance-indexing/ https://virtual-dba.com/blog/improving-foreign-key-performance-indexing/#respond Fri, 02 Dec 2016 16:51:38 +0000 https://virtual-dba.com/?p=28445 A Foreign Key is a constraint. Due to this definition, it only places a limitation on what data can be inserted into a column(s) and does not address the indexes needed to help performance when joining tables Take the following design. If you wanted to join the 2 table to return the person’s name and […]

The post Improving Foreign Key Performance with Indexing appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/improving-foreign-key-performance-indexing/feed/ 0