Одну секунду
Что-то сучилось. Попробуйте еще раз.
Sql server query logs смотреть последние обновления за сегодня на .
Hi Mate, Welcome to my channel Tech & Art. STAY HEALTHY AND KEEP LEARNING* *ALWAYS HAPPY AND CONNECTED * N/B: Visit channel playlist "SQL SERVER DBA" for more live scenarios based discussion. QUERY:- Get the path for your audit files declare 🤍log_dir nvarchar(260); set 🤍log_dir = (select log_file_path+'*.sqlaudit' from sys.server_file_audits where name = '{NameOfYourAudit}'); Read all the audit data you are interested in SELECT * FROM sys.fn_get_audit_file(🤍log_dir, default, default) You can use a filter if requred where statement like '%{MyStatement}%' Show the most recent records first order by event_time desc; In this session we are going to discuss about how to enable sql server database audit. #sqlserveraudit Stay tuned by clicking the subscribe button and clicking on bell icon for future notifications. Thanks 🙏 * Best Book For SQL DBA Microsoft SQL Server 2019 🤍 SQL Server 2019 🤍 SQL Server 2019 Wait Statistics 🤍 SQL Server Query Performance Tuning 🤍 SQL the One: Microsoft SQL Server Interview Guide 🤍 * SQL ARCHITECTURE:- 🤍 SQL SELECT STATEMENT:- 🤍 SQL DML STATEMENTS PROCESSING:- 🤍 SQL AAG 🤍 Linked server 🤍 SQL MIRRORING 🤍 SQL REPLICATION 🤍 SQL LOGSHIPING 🤍 🤍 🤍 🤍 ORACLE INSTANCE AND DATABASE:- 🤍 ORACLE INSTANCE STARTUP SEQUENCE 🤍 ORACLE INSTANCE SHUTDOWN SEQUENCE:- 🤍 SQL SERVER BACKUP/RESTORE:- 🤍 🤍 SQL, SQL DATABASE, SQL BACKUP, RESTORE, RECOVERY, USERS, LOGINS, AGENT, SQL JOBS, SQL ARCHITECTURE, SQL INSTANCE, SQL UPGRADE, SQL PATCHING, SQL PERFORMANCE, SQL MANITINEMANC, SQL SLOWNESS, SQL HARDWARE, SQL LIFE CYCLE, SQL DR, SQL MIRRORING, SQL REPLICATION SQL ALWAYS ON, SQL LOGSHIPING, SQL CLUSTERING, SQL INSTALLATION, SQL MIGRATION, SQL TO AZURE,CLOUDE,AZURE,AMAZON,GOOGLE, SQL TO AWS,AWS,SQL MIGRATION TO CLOUDE,AZURE FUNDAMENTAL, AZURE CERTIFICATION, AZURE ARCHITECTURE, SQL ON LINUX, SQL LINIX INSTALLATION, SQL PERFORMANCE QUERY, SQL BLOCKING,SQL DEADLOCK,SQL DATABASE CRASHED, SQL DATABASE DOWN,SQL SERVICES , SQL SERVICES STOP, SQL INSTALLATION FAILED, SQL UPGRADE FAILED, sql server,sql database,azure sql server database tutorial,azure sql database vs sql server,azure sql database,sql,audit,microsoft sql server (software),sql server 2014,azure sql server,sql server tutorial,azure sql database managed instance,azure sql database administration training,sql server tutorial for beginners,server,sql server 2014 dba,sql server audit,sql server 2012,sql server 2008,audit in sql server,sql server dba tutorial for beginners,microsoft sql server #sqlserver #sqlserverdba #techandart
2 ways to resolve a SQL Server log file full error, with mildly amusing commentary :) If you are getting this, you may have other issues...ping me More stuff for new and accidental DBAs: 🤍 Need an on-call DBA? 🤍 Start learning SQL Server administration: 🤍
Description: This video is about Troubleshooting Database Slowness and Blocking with sp_who, sp_who2 and sp_WhoIsActive [HD]. You can refer complete Text Tutorial on my website: 🤍SQLServerLog.com You can join me on social networks: Facebook: 🤍 Linkedin: 🤍 Google+: 🤍 Twitter: 🤍
This video shows how to use the Activity Monitor to monitor performance on an SQL Server.
An easy way to find the ErrorLog location without having to click around and poke into every drive on the server.
This video shows How to use SQL Profiler
This easy video tutorial shows you step by step method to shrink SQL Server database transaction log. For more details visit: 🤍
Welcome back to the ".NET on Azure for Beginners" series! 🚀 In this exciting episode, Matt Soucoup takes you on a journey to deploy your .NET applications seamlessly in Azure. Here's what you'll discover: ✅ Setting up an Azure App Service and Azure SQL database. ✅ Step-by-step guidance on deploying a .NET app to these Azure services. ✅ Pro tips and best practices for a smooth deployment process. Whether you're a seasoned developer or just starting your Azure journey, this episode is packed with valuable insights to boost your skills. Stay tuned for the rest of the series, where we'll cover everything from resource group naming conventions to Managed Identity and GitHub Actions. Don't forget to like, subscribe, and hit the notification bell to stay updated on our Azure adventures. Let's elevate your .NET applications in the cloud together! 💻☁️ #Azure #dotNET #AppDeployment #AzureSQL #WebDevelopment #CloudComputing #BeginnersGuide
In this video, I take you through the task of creating a stored procedure in Sql Server 2008 using the Adventureworks database, We create a stored procedure that archives thousands of rows dynamically from one table to another via insert and delete statements. try/catch blocks, error functions, environment variables, calling other stored procedures, and the RaiseError function are covered in this series of videos. Later videos will drive this from Asp.Net and Sql Server Agent as a scheduled job.
Get a Free System Design PDF with 158 pages by subscribing to our weekly newsletter: 🤍 Animation tools: Adobe Illustrator and After Effects. Checkout our bestselling System Design Interview books: Volume 1: 🤍 Volume 2: 🤍 The digital version of System Design Interview books: 🤍 ABOUT US: Covering topics and trends in large-scale system design, from the authors of the best-selling System Design Interview series.
sql server 2008 ddl trigger audit sql server table changes tracking In this video we will discuss, how to audit table changes in SQL Server using a DDL trigger. Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help. 🤍 Table to store the audit data Create table TableChanges ( DatabaseName nvarchar(250), TableName nvarchar(250), EventType nvarchar(250), LoginName nvarchar(250), SQLCommand nvarchar(2500), AuditDateTime datetime ) Go The following trigger audits all table changes in all databases on a SQL Server. CREATE TRIGGER tr_AuditTableChanges ON ALL SERVER FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE AS BEGIN DECLARE 🤍EventData XML SELECT 🤍EventData = EVENTDATA() INSERT INTO SampleDB.dbo.TableChanges (DatabaseName, TableName, EventType, LoginName, SQLCommand, AuditDateTime) VALUES ( 🤍EventData.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'varchar(250)'), 🤍EventData.value('(/EVENT_INSTANCE/ObjectName)[1]', 'varchar(250)'), 🤍EventData.value('(/EVENT_INSTANCE/EventType)[1]', 'nvarchar(250)'), 🤍EventData.value('(/EVENT_INSTANCE/LoginName)[1]', 'varchar(250)'), 🤍EventData.value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'nvarchar(2500)'), GetDate() ) END In the above example we are using EventData() function which returns event data in XML format. Text version of the video 🤍 Slides 🤍 All SQL Server Text Articles 🤍 All SQL Server Slides 🤍 Full SQL Server Course 🤍 All Dot Net and SQL Server Tutorials in English 🤍 All Dot Net and SQL Server Tutorials in Arabic 🤍
This Video explains the Steps to shrink the log file of the Database from Microsoft Sql Server Management Studio
Description: This video is about SQL Server Wait Types – Trace and Tune Database Performance Issues [HD]. You can refer complete Text Tutorial on my website: 🤍SQLServerLog.com You can join me on social networks: Facebook: 🤍 Linkedin: 🤍 Google+: 🤍 Twitter: 🤍
How to check if there is a blocking in SQL Server Download the file\script used in the Video from below link 🤍 SQL Server: 🤍 SQL Server Developer Interview questions: 🤍 How to check if there is a blocking in SQL Server How do I stop SQL blocking? How do I view a blocked session? What is blocking query in SQL Server? How do I monitor SQL Server locks? Happy Learning. If you have any questions or suggestions please comment on the video or write to me at “aqil33🤍gmail.com”
SQL Server Profiler is an interface to create and manage traces and analyze and replay trace results. Events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when diagnosing a problem. Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine. You can capture and save data about each event to a file or table to analyze later. 🤍 Create trace 🤍
In this video, you will learn about how to clear data in SQL Server Log file and How to Shrink SQL Server Log File using SQL Server Management Studio. Please make sure you have backup your file if any problem happened, you restore it.
In this video you will learn how to check SQL Server Error Log size using following methods: 1- How to check SQL Server Error Log using File system 2- How to check SQL Server Error log using Extended Store procedure 3- What are the limitations of Undocumented Extended store procedure Blog post link for the video with script 🤍 Complete Step by Step List for DBA Tutorial Videos: 🤍
In today's Advanced SQL lesson we walk through how to use Stored Procedures. Link to SQL Code: 🤍 SUBSCRIBE! Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! RESOURCES: Coursera Courses: Google Data Analyst Certification: 🤍 Data Analysis with Python - 🤍 IBM Data Analysis Specialization - 🤍 Tableau Data Visualization - 🤍 Udemy Courses: Python for Data Analysis and Visualization- 🤍 Statistics for Data Science - 🤍 SQL for Data Analysts (SSMS) - 🤍 Tableau A-Z - 🤍 *Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!* SUPPORT MY CHANNEL - PATREON/MERCH Patreon Page - 🤍 Alex The Analyst Shop - teespring.com/stores/alex-the-analyst-shop Websites: GitHub: 🤍 *All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*
SQL Server Performance issues || SQL Server Long Running Query || SQL Server Query Running Slow Query:- SELECT s.session_id ,r.STATUS ,r.blocking_session_id 'blocked by' ,r.wait_type ,wait_resource ,r.wait_time / (1000.0) 'Wait Time (in Sec)' ,r.cpu_time ,r.logical_reads ,r.reads ,r.writes ,r.total_elapsed_time / (1000.0) 'Elapsed Time (in Sec)' ,Substring(st.TEXT, (r.statement_start_offset / 2) + 1, ( ( CASE r.statement_end_offset WHEN - 1 THEN Datalength(st.TEXT) ELSE r.statement_end_offset END - r.statement_start_offset ) / 2 ) + 1) AS statement_text ,Coalesce(Quotename(Db_name(st.dbid)) + N'.' + Quotename(Object_schema_name(st.objectid, st.dbid)) + N'.' + Quotename(Object_name(st.objectid, st.dbid)), '') AS command_text ,r.command ,s.login_name ,s.host_name ,s.program_name ,s.host_process_id ,s.last_request_end_time ,s.login_time ,r.open_transaction_count FROM sys.dm_exec_sessions AS s INNER JOIN sys.dm_exec_requests AS r ON r.session_id = s.session_id CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS st WHERE r.session_id != 🤍🤍SPID ORDER BY r.cpu_time DESC ,r.STATUS ,r.blocking_session_id ,s.session_id * SQL, SQL DATABASE, SQL BACKUP, RESTORE, RECOVERY, USERS, LOGINS, AGENT, SQL JOBS, SQL ARCHITECTURE, SQL INSTANCE, SQL UPGRADE, SQL PATCHING, SQL PERFORMANCE, SQL MANITINEMANC, SQL SLOWNESS, SQL HARDWARE, SQL LIFE CYCLE, SQL DR, SQL MIRRORING, SQL REPLICATION SQL ALWAYS ON, SQL LOGSHIPING, SQL CLUSTERING, SQL INSTALLATION, SQL MIGRATION, SQL TO AZURE,CLOUDE,AZURE,AMAZON,GOOGLE, SQL TO AWS,AWS,SQL MIGRATION TO CLOUDE,AZURE FUNDAMENTAL, AZURE CERTIFICATION, AZURE ARCHITECTURE, SQL ON LINUX, SQL LINIX INSTALLATION, SQL PERFORMANCE QUERY, SQL BLOCKING,SQL DEADLOCK,SQL DATABASE CRASHED, SQL DATABASE DOWN,SQL SERVICES , SQL SERVICES STOP, SQL INSTALLATION FAILED, SQL UPGRADE FAILED, #sqlserver #sqlserverdba #techandart
for more info visit 🤍 download SQL Server Express 🤍
In this video you will learn how to answer this SQL Server DBA interview Question "The tran log of a database has grown huge, how would you shrink the log file". You will also learn How to shrink log file in SQL Server Step by Step how to shrink database log file in SQL Server How to find open Transactions in SQL Server Complete list of SQL Server DBA Interview Questions by Tech Brothers 🤍
SQL server Performance || SQL Server Execution Plan || Query Execution Plan || SQL Server Blocking QUERY:- SELECT SPID,ER.percent_complete, /* This piece of code has been taken from article. Nice code to get time criteria's 🤍 */ CAST(((DATEDIFF(s,start_time,GetDate()))/3600) as varchar) + ' hour(s), ' + CAST((DATEDIFF(s,start_time,GetDate())%3600)/60 as varchar) + 'min, ' + CAST((DATEDIFF(s,start_time,GetDate())%60) as varchar) + ' sec' as running_time, CAST((estimated_completion_time/3600000) as varchar) + ' hour(s), ' + CAST((estimated_completion_time %3600000)/60000 as varchar) + 'min, ' + CAST((estimated_completion_time %60000)/1000 as varchar) + ' sec' as est_time_to_go, DATEADD(second,estimated_completion_time/1000, getdate()) as est_completion_time, /* End of Article Code */ ER.command,ER.blocking_session_id, SP.DBID,LASTWAITTYPE, DB_NAME(SP.DBID) AS DBNAME, SUBSTRING(est.text, (ER.statement_start_offset/2)+1, ((CASE ER.statement_end_offset WHEN -1 THEN DATALENGTH(est.text) ELSE ER.statement_end_offset END - ER.statement_start_offset)/2) + 1) AS QueryText, DEQP.QUERY_PLAN, TEXT,CPU,HOSTNAME,LOGIN_TIME,LOGINAME, SP.status,PROGRAM_NAME,NT_DOMAIN, NT_USERNAME FROM SYSPROCESSES SP INNER JOIN sys.dm_exec_requests ER ON sp.spid = ER.session_id CROSS APPLY SYS.DM_EXEC_SQL_TEXT(er.sql_handle) EST CROSS APPLY SYS.DM_EXEC_QUERY_PLAN(er.PLAN_HANDLE) DEQP ORDER BY running_time DESC END SQL, SQL DATABASE, SQL BACKUP, RESTORE, RECOVERY, USERS, LOGINS, AGENT, SQL JOBS, SQL ARCHITECTURE, SQL INSTANCE, SQL UPGRADE, SQL PATCHING, SQL PERFORMANCE, SQL MANITINEMANC, SQL SLOWNESS, SQL HARDWARE, SQL LIFE CYCLE, SQL DR, SQL MIRRORING, SQL REPLICATION SQL ALWAYS ON, SQL LOGSHIPING, SQL CLUSTERING, SQL INSTALLATION, SQL MIGRATION, SQL TO AZURE,CLOUDE,AZURE,AMAZON,GOOGLE, SQL TO AWS,AWS,SQL MIGRATION TO CLOUDE,AZURE FUNDAMENTAL, AZURE CERTIFICATION, AZURE ARCHITECTURE, SQL ON LINUX, SQL LINIX INSTALLATION, SQL PERFORMANCE QUERY, SQL BLOCKING,SQL DEADLOCK,SQL DATABASE CRASHED, SQL DATABASE DOWN,SQL SERVICES , SQL SERVICES STOP, SQL INSTALLATION FAILED, SQL UPGRADE FAILED, #sqlserver #sqlserverdba #techandart
To analyse SQL Server performance at given time. SQL Server standard reports provide quick peek, but still to get complete over view we have to traverse through different reports sequentially. Also for DBA who are new to performance tuning it’s difficult to make sense of different reports all together. Solution: SQL performance dashboard report provide you great and quick in site on things happening in or to SQL Server also information makes much more sense as it is provided with proper formatting. 🤍
If anyone is looking for Sql DBA training, Job Support, Interview Support, Videos, Notes Please Whatsapp me 🤍 9902590140 Thank You Queries used in this video dbcc sqlperf(logspace) select name,log_reuse_wait_desc from sys.databases Backup log DBName to disk ='nul' replace DBName with your respective database name
How to approach more complicated SELECT statements in Structured Query Language.
Follow this easy step by step tutorial to learn how to use Truncate Table query in SQL and see how data can be removed from the table. Don't forget to check out our site 🤍 for more free how-to videos! 🤍 - our feed 🤍 - join us on facebook 🤍 - our group in Google+ Truncate Table command allows us to delete all the data in the table without deleting the table itself. This command does not delete the entire table, but it only deletes the records inside the table. In this tutorial we will learn to truncate a table in SQL. Step 1- Viewing Table Data First of all let us view the records from any table, let it be dummy in our case. For that write: Select * from dummy and execute it by pressing F5. Step 2- Executing Command Now write the Truncate Table command along with the required table name. The query would be: Truncate table dummy and execute it . Step 3- Data Removed Now view the records of dummy table again, you will observe that the table would be empty with no records present. That is what the Truncate Table query does. And that is how we can truncate a table in SQL.
#SQLForensics #SQLServerLogRecovery #RecoverSQLServer Learn How to View SQL Server Transaction Log File using SysTools Log Analyzer Tool. More: 🤍 The software is a standalone tool to view the SQL transaction log. Now you can open, read & analyze SQL server transactions. And also the tool repair SQL transaction log file easily. SQL Server Log file analyzer promotes the forensic analysis of Log files for the examination of SQL Server activities. The tool works on offline SQL database only and MDF File is required to analyze the database. Product Page: 🤍 How-the-Software-Works: 🤍 Purchase Software (Full Version): 🤍 SysTools® and its logos are trademarks or registered trademarks of SysTools Software. Any other trademarks appearing in this Video are the property of their respective owners.
trace sql server deadlock sql server deadlock log how to log deadlocks in sql server sql server deadlock log file sql logging deadlocks trace deadlocks in sql server 2008 sp_readerrorlog Text version of the video 🤍 Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help. 🤍 Slides 🤍 All SQL Server Text Articles 🤍 All SQL Server Slides 🤍 All Dot Net and SQL Server Tutorials in English 🤍 All Dot Net and SQL Server Tutorials in Arabic 🤍 In this video we will discuss how to write the deadlock information to the SQL Server error log When deadlocks occur, SQL Server chooses one of the transactions as the deadlock victim and rolls it back. There are several ways in SQL Server to track down the queries that are causing deadlocks. One of the options is to use SQL Server trace flag 1222 to write the deadlock information to the SQL Server error log. Enable Trace flag : To enable trace flags use DBCC command. -1 parameter indicates that the trace flag must be set at the global level. If you omit -1 parameter the trace flag will be set only at the session level. DBCC Traceon(1222, -1) To check the status of the trace flag DBCC TraceStatus(1222, -1) To turn off the trace flag DBCC Traceoff(1222, -1) To read the error log execute sp_readerrorlog
This session will help you understand the following : 1.) What is Batch File? 2.) How to create batch file. 3.) How to execute sql scripts using batch file in one click, in one go. 4.) Important batch file commands #batch #sql #sqlserver #sqltraining #sqlqueries #sqlite #training #howto #tutorial Thanks for Watching ! By SQL Training Session BY SQL
In this video you will learn the answer of SQL Server DBA Interview "How would you find currently running queries on SQL Server Instance?" You can also query the dmv to get the list of queries running on SQL Server. You have to convert the sql_handler to query by using DMF. sys.dm_exec_requests Complete list of SQL Server DBA Interview Questions by Tech Brothers 🤍
Faça parte da #comunidadeBD Canal vip no telegram 🤍 Para dicas rápidas me acompanhe nas outras redes: 🤍 🤍 🤍
Best methods to fallow the Purging & Archiving & Partitioning in SQL Server
Description: This video is about How to Display Line Numbers in SQL Server Query Editor Window [HD]. You can refer complete Text Tutorial on my website: 🤍SQLServerLog.com You can join me on social networks: Facebook: 🤍 Linkedin: 🤍 Google+: 🤍 Twitter: 🤍 Display Line Numbers in SQL Server Query Editor Window [HD]
In this video, I'll walk through a very exciting service called Log Analytics Google Cloud has just announced. It is designed to replace endless creation and management of log sinks by using a unified log bucket. With the ability to use SQL directly in the Logging interface as well as exposing all logs via a single view to BigQuery without duplicating data, this is going to make developer's life so much easier on creating powerful visualisations to monitor system operations. - Slide: 🤍 - Code Repo: 🤍 - Log Analytics blog: 🤍 - BigQuery Search blog: 🤍
Implement Logging to SQL Server in SSIS | ssis logging | ssis logging best practices Download the file\script used in the Video from below link 🤍 SSIS Tutorials: 🤍 SSIS real time scenarios examples: 🤍 SSIS Interview questions and answers: 🤍 Implement Logging to SQL Server in SSIS ssis logging ssis logging best practices How do you implement logging in SSIS? How do I view SQL Server SSIS logs? What are the different types of logging present in SSIS? What is SSIS custom logging? Happy Learning. If you have any questions or suggestions please comment on the video or write to me at “aqil33🤍gmail.com”
This video demonstrates how to detach a database in Microsoft SQL Server Management Studio, locate the database files on the computer, and re-attach the database back in Microsoft SQL Server Management Studio. Occasionally if you see an error detaching the database then just close Management Studio and re-open would solve the problem, if not try to restart your SQL Server through Configuration Manager or reboot the computer.
.svg){kind=small}
![Display Line Numbers in SQL Server Query Editor Window [HD]](https://i.ytimg.com/vi/SAp_mEa18HA/mqdefault.jpg "Display Line Numbers in SQL Server Query Editor Window [HD]")
