Microsoft SQL SERVER DBA

 CLOUD COMPUTING  Cloud computing has revolutionized the way businesses and individuals approach technology infrastructure and services. In today's digital age, where data storage, processing power, and software applications play a critical role in our daily lives, cloud computing offers a flexible and scalable solution. By leveraging remote servers and networks accessed through the internet, cloud computing enables users to store, manage, and access data and applications seamlessly from anywhere in the world. In this blog post, we will explore the fundamental concepts of cloud computing, its benefits, and its impact on various industries, as well as address common misconceptions to help you understand why cloud computing has become an essential component of modern-day technology strategies. "

Some SQL scripts commonly used by DBAs in production server environments : Script to Monitor Blocking Queries: SELECT     r.session_id,     r.blocking_session_id,     t.text AS [SQL Text] FROM     sys.dm_exec_requests r     CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) t WHERE     r.blocking_session_id <> 0; Script to Monitor Server Performance: SELECT     [object_name],     [counter_name],     [cntr_value] FROM     sys.dm_os_performance_counters WHERE     [object_name] LIKE '%:SQLServer%'     AND [counter_name] IN ('Batch Requests/sec', 'Transactions/sec', 'User Connections') ORDER BY     [object_name], [counter_name]; Script to Identify Index Fragmentation : SELECT     dbschemas.[name] + '.' + dbtables.[name] AS [Table Nam...

COVID-19 has negatively impacted almost all careers, and software engineering is no exception. However, a survey conducted by  Career Explorer  suggests that software engineers are faring better than other professionals. Among surveyed professionals across all industries and job titles, 20% of respondents have reported losing a job due to COVID-19. Among the survey respondents, software engineers experienced a 5% job loss. Also, 48% of all the surveyed professionals showed concern about job security. On the other hand, only 31% of software engineers highlighted the issue of job security. It is important to highlight here that the above software engineering job respondent data is taken from across the industrial spectrum. Engineers and developers working in different sectors may likely face contrasting situations. For instance, software engineers and developers working in the hospitality industry have to experience pay cuts and layoffs. On the other hand, engineers and develope...

Each version introduced its own set of new features and enhancements. Here are some notable new features introduced in SQL Server 2012 and SQL Server 2014:   ------SQL Server 2012------ AlwaysOn Availability Groups: This feature provides high availability and disaster recovery solutions by allowing multiple databases to be grouped together and failover as a single unit. Columnstore Indexes: SQL Server 2012 introduced columnstore indexes, which significantly improve query performance for data warehousing and analytics workloads by storing data in a columnar format. SQL Server Data Tools (SSDT): SSDT provides an integrated development environment for database developers, offering enhanced database design, testing, and deployment capabilities. SQL Server Analysis Services (SSAS) Tabular Model: In addition to the traditional multidimensional model, SQL Server 2012 introduced the tabular model for SSAS, which provides a simpler, in-memory approach for building analytical solutions. ...

select * from sys.dm_db_session_space_usage:   This query can be used to monitor the space usage of each session in the database, helping you identify any sessions that are consuming excessive space. dbcc sqlperf(logspace):   By executing this command, you can obtain information about the transaction log space usage for each database. It helps you identify if any transaction logs are growing too large and may require management. xp_fixeddrives:  This query provides information about the fixed drives (hard drives) on the SQL Server machine. As a DBA, you can use this to ensure sufficient disk space is available for the database files and logs. dbcc showcontig :  Use this command to analyze the fragmentation level of tables and indexes. It helps you identify fragmented objects that might impact performance and allows you to plan for defragmentation or index maintenance. select * from sys.dm_db_index_physical_stats:  This query returns detailed physical statistics ...

  Upgrade to SQL Server 2016 Using the Installation Wizard (Setup) Reasons for Upgradation         --New features of SQL Server version         --MS stop support         --When the application or front-end part was updated         --When integrating with other RDBMS products...   Upgradation Types         --In-Place         --Side-by-Side   In-Place Upgradation Restrictions 1. Patching is required on existing instance                            2012       2014        2005              SP4   ...