MS SQL SERVER DBA

Exploring the Landscape of AI in the Market. Artificial Intelligence (AI) has swiftly transformed from a futuristic concept to a critical component of various industries. As organizations seek to harness the power of AI, a diverse range of AI technologies and platforms have emerged in the market. From machine learning to natural language processing, AI is driving innovation and reshaping the way businesses operate. In this article, we will explore some of the different AI technologies and platforms that are currently making waves in the market. 1. Machine Learning Platforms: Machine learning is a subset of AI that focuses on enabling systems to learn from data and improve their performance over time. Numerous machine learning platforms are available, catering to different skill levels and business needs. Leading platforms include: TensorFlow: Developed by Google, TensorFlow is an open-source machine learning framework known for its flexibility and scalability. It supports a wide range

SQL Server 2022 Features in Detail. 1. Data Virtualization: Data virtualization in SQL Server 2022 enables you to access and query data from various sources as if they were part of a single database. This eliminates the need for complex data integration processes and allows for seamless querying of distributed data. 2. Machine Learning Services Enhancements: SQL Server 2022 offers enhanced integration with machine learning frameworks like TensorFlow and PyTorch. This enables you to train and deploy machine learning models directly within the database, bringing AI-driven insights closer to the data. 3. Improved Security: The Data Discovery and Classification capabilities in SQL Server 2022 help identify sensitive data and apply appropriate security measures. Always Encrypted technology ensures that sensitive data remains encrypted in various scenarios. 4. Big Data Clusters: Big data clusters allow you to manage and query large datasets across SQL Server, Hadoop, and Spark clusters. This

Features of SQL Server 2022.   SQL Server 2022, the latest iteration of Microsoft's popular relational database management system, brings a slew of exciting new features and enhancements that cater to the needs of modern data-driven applications. With a focus on performance, security, scalability, and advanced analytics capabilities, SQL Server 2022 is poised to empower developers, database administrators, and data analysts with powerful tools to manage and extract insights from their data. Let's delve into some of the standout features that SQL Server 2022 has to offer. 1. Data Virtualization: SQL Server 2022 introduces data virtualization, which allows you to query data from multiple sources as if they were part of a single database. This feature facilitates easier access to distributed data and helps eliminate the need for complex ETL processes to combine data from various sources. Data virtualization enables seamless querying of data residing in other databases, data lakes,

Earn Passive Income Online in 2023. In today's digital age, earning money online has become an increasingly popular option for individuals seeking financial independence and flexibility. With the right strategies and dedication, anyone can tap into the vast opportunities available on the internet. This article presents ten proven strategies that can help you start earning money online and potentially turn it into a sustainable source of income. Freelancing: Explore the world of freelancing by offering your skills and services online. Platforms like Upwork, Freelancer, and Fiverr connect freelancers with clients seeking various services, including writing, graphic design, programming, and virtual assistance. Online Tutoring: Leverage your expertise in a particular subject by becoming an online tutor. Platforms such as Tutor.com, VIPKid, and Chegg Tutors offer opportunities to teach students worldwide through virtual classrooms. Affiliate Marketing: Join affiliate programs and earn c

SQL Server 2016 Windows Server 2016 Firewall Rule Step-By-Step. Opening Firewall in SQL Server 2016. Once the SQL Server is installed on the machine. We must enable the incoming traffic i.e., from the application to the SQL Server Database. For this purpose, we must create rule for SQL Server ports so that the application can connect to database & perform the CRUD operations on the tables. Now Let’s start Step-by-Step to enable it. 1.   Start System and Login (As Administrator); 2.   Open Control Panel. Click on Windows Firewall; 3. Now click on Advanced Settings; 4. Windows Firewall console open. If you click on Properties (right side) – you can disable firewall for all networks. We going to Inbound Rules (left side) for our rule creation; After Clicking on the Inbound rules. We will see the below screen.  Click on New

YouTube Video's Links of SQL Server. Monitoring of Database Objects for Space Issues https://youtu.be/ywfEeHnr8sw Please Like, Subscribe, share the videos of my channel...!!! Increase in the Growth of the Log File | SQL Server https://youtu.be/eWvfwqPB6to Please Like, Subscribe, share the videos of my channel...!!! To find the Active Running Transactions on SQL Server. https://youtu.be/6jPl1jKRfvU Please Like, Subscribe, share the videos of my channel...!!! Shrinking a Log File of a Database in Always on Availability. https://youtu.be/VKlbiz-HNbQ Please Like, Subscribe, share the videos of my channel...!!! Self Introduction and Responsibilities of DBA. https://youtu.be/Td-8nQ6cRe4 Please Like, Subscribe, share the videos of my channel...!!! Re-Indexing of Database. https://youtu.be/0Dd2ylJBjG8 Please Like, Subscribe, share the videos of my channel...!!! Shrinking of LDF and MDF Files on Drives https://youtu.be/LtbSaiHu6Ho Please Like, Subscribe, share t

Shrinking a SQL Server Log File with Database in Always ON Availability.                    Once we had a situation in our production server that the database which is in Always ON Availability group has been grown to the maximum size.  Many of them say that we can't shrink the log file as the database is in Always ON and we should take the downtime to perform the operation. But we shrink-ed the database log file to 5 GB from 180 GB. Steps are as below: --To Check the Number of pages allocated by the LogFile. DBCC LOGINFO --To check the file sixe sp_helpdb [SQLPantry] --To check the Log file Size DBCC SQLPERF(LOGSPACE) The above statement will show the logspace of all db at present situation. --To check the Log_reuse_wait description of a log file. select log_reuse_wait_desc,* from sys.databases The above statement will show the status of the log whether it has to be backuped i.e., LogBackup, Nothing, Active Transaction.  When ever there is status as Activ

There are many reasons which cause the SQL Server Log file to grow to unbelievable size i.e., the space available in the Disk. 1. whenever we have not scheduled a Log_backup on the server the log file size grows bigger and occupies the disk on the specific drive. 2. If we have any repplication setup. Then we will be have log file growth. 3. Due to long running transaction also that causes the Log file grows. All the transactions that are performed on the SQL are done at the log files, after a commit transaction i.e.., from code or the SQL Server check point the data is updated to the Data file of the database. To Check the Growth of the Database Log files. DBCC SQLPERF(LOGSPACE) The Log Size (MB) column shows the size of the log files The Log Space Used(%) column shows how much of the log space is used by the SQL Server Log Files. Example: In some environment we will be able to see the below Log Size (MB): 43562.19 Log Space Used: 1000.45 When ever we take

SELECT DISTINCT TOP 10 t.TEXT QueryName, s.execution_count AS ExecutionCount, s.max_elapsed_time AS MaxElapsedTime, ISNULL(s.total_elapsed_time / s.execution_count, 0) AS AvgElapsedTime, s.creation_time AS LogCreatedOn, ISNULL(s.execution_count / DATEDIFF(s, s.creation_time, GETDATE()), 0) AS FrequencyPerSec FROM sys.dm_exec_query_stats s CROSS APPLY sys.dm_exec_sql_text( s.sql_handle ) t ORDER BY s.max_elapsed_time DESC GO To find the Active Running Transactions on SQL Server. https://youtu.be/6jPl1jKRfvU Please Like, Subscribe, share the video for more videos...!!!

The below query shows the output of the transactions that are actively running on the Server. SELECT sqltext.TEXT, dm.session_id, dm.status, dm.command, dm.cpu_time, dm.total_elapsed_time FROM sys.dm_exec_requests dm CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext   When we run the above query it shows the output what are the transactions that are running on the server. And it varies from time to time. As we refresh the query we will find the new query's executing on the server. This can be experienced when we run the query on the Production environment.  The same can be implemented on the stand-alone system i..e., personal computer where we schedule some jobs with SQL Script that inserts some information and some query's to retrieved the data.

Report layout can be boiled down to a few, simple design patterns. These simple styles also can be combined with others to form composite reports and more advanced layout to visualize data. This section offers a quick review of the report layout types, followed by some examples.     Tabular Reports   Tabular reports have been around for thousands of years. Well, they may not have been reports in the modern sense, but when you think about it, some common reports are really little more than  “ lists of stuff ”  organized into rows and columns. Ever since early merchants began trading seashells or precious gems for beaver pelts or goat cheese, someone was recording the transaction in some kind of list, be it on papyrus, stone tablets, or a tablet PC.   Ever since VisiCalc, the predecessor to Lotus 123 and Microsoft Excel, was released in 1981, the tabular spreadsheet format has become the way many computer users are accustomed to viewing business data. For decades, the only