Overview of the Azure SQL Architecture:
SQL SERVER DBA and Azure
by
3w ago
 Azure SQL Database is a fully managed relational database service provided by Microsoft Azure. Its architecture is designed to provide scalability, high availability, and security for hosting relational databases in the cloud.  Azure Data Centers: Azure SQL Database runs on Microsoft's global network of data centers, which are distributed across multiple regions worldwide. These data centers provide the physical infrastructure for hosting Azure SQL Database instances and ensure high availability and fault tolerance. SQL Database Engine: At the core of Azure SQL Database is the SQL ..read more
Visit website
PN Rao
SQL SERVER DBA and Azure
by
3M ago
PN Rao..? www.sqldbanow.com ..read more
Visit website
Migrate a database from one server to another using log shipping in SQL Server
SQL SERVER DBA and Azure
by
3M ago
Migrate a database from one server to another using log shipping  in SQL Server.                                                                                                              ..read more
Visit website
Migrating a database from one server to another using the attach and detach method
SQL SERVER DBA and Azure
by
3M ago
 Migrating a database from one server to another using the attach and detach method.                                                                                                            &nb ..read more
Visit website
Side-by-side migration in the context of SQL Server using Backup and restore
SQL SERVER DBA and Azure
by
3M ago
 Side-by-side migration in the context of SQL Server using Backup and restore                                                                                                              Dow ..read more
Visit website
Capture all SQL and Stored Proc calls using Extended Events in SQL Server
SQL SERVER DBA and Azure
by
3M ago
-- Capture all SQL and Stored Proc calls -- Part of the SQL Server DBA Toolbox at https://github.com/DavidSchanzer/Sql-Server-DBA-Toolbox -- This script creates an Extended Events session called "CaptureAllSQLAndStoredProcCalls" that includes the following events: -- error_reported (for severity 20 and above, as well as certain error numbers) -- existing_connection -- login -- logout -- rpc_completed -- sql_batch_completed CREATE EVENT SESSION [CaptureAllSQLAndStoredProcCalls] ON SERVER     ADD EVENT sqlserver.error_reported     (ACTION      (     ..read more
Visit website
Here are key points about the buffer cache in SQL Server:
SQL SERVER DBA and Azure
by
3M ago
    The buffer cache in SQL Server is a part of the SQL Server memory architecture that is responsible for caching database pages in memory. When SQL Server reads data from a disk, it stores a copy of that data in the buffer cache. Subsequent queries that need the same data can then be served from the in-memory buffer rather than reading from disk, which is significantly faster. Here are key points about the buffer cache in SQL Server: Buffer Pool: The buffer cache is often referred to as the "buffer pool" or "data cache." It is a region in the SQL Server memory space dedicated ..read more
Visit website
Here are common SQL Server performance issues and potential solutions:
SQL SERVER DBA and Azure
by
3M ago
 SQL Server performance issues can arise for various reasons, and resolving them often involves identifying bottlenecks, optimizing queries, and configuring the server appropriately. Here are common SQL Server performance issues and potential solutions: High CPU Usage: Issue: Excessive CPU utilization. Solutions: Identify and optimize poorly performing queries. Consider adding indexes to improve query performance. Scale up resources (CPU, memory). Review and adjust the SQL Server configuration for parallelism. Memory Pressure: Issue: Insufficient available memory for SQL Server. Solutions ..read more
Visit website
Version control in SQL Server
SQL SERVER DBA and Azure
by
3M ago
 Version control in SQL Server refers to the practice of managing and tracking changes to database objects, such as tables, views, stored procedures, and functions, over time. Using version control helps in maintaining a history of changes, collaborating with multiple developers, and rolling back to previous states if needed. Here are common approaches and tools for version control in SQL Server: Scripting and Source Control Systems: Manual Scripting: Developers manually create and maintain SQL scripts for database objects. These scripts are then stored in a version control system ..read more
Visit website
Common SQL Server wait types
SQL SERVER DBA and Azure
by
3M ago
In SQL Server, wait types are events or conditions that cause a task (such as a query or a process) to wait for a specific resource or event to be available before it can continue processing. Monitoring and analyzing wait types can help identify performance bottlenecks and optimize the database system. Here are some common SQL Server wait types: PAGEIOLATCH_XX: Description: Indicates that a process is waiting for a data page to be read from disk into memory. Possible Causes: Slow I/O subsystem, high disk latency. CXPACKET: Description: Related to parallel query execution. Ind ..read more
Visit website

Follow SQL SERVER DBA and Azure on FeedSpot

Continue with Google
Continue with Apple
OR