To Check the mail service status EXEC msdb.dbo.sysmail_help_status_sp; To Stop and Restart Mail Queue/ Service EXEC msdb.dbo.sysmail_stop_sp;EXEC msdb.dbo.sysmail_start_sp; To Check Sent and Unsent Email SELECT * FROM msdb.dbo.sysmail_sentitems;SELECT * FROM msdb.dbo.sysmail_unsentitems; To manually send a test email EXEC msdb.dbo.sp_send_dbmail @profile_name...
Read more
Hey Everyone 👋 ! Having trouble with Infinite Limits Problems? Want to become faster at Infinite Limits? Then this is the perfect article for you. Video Worksheet Solutions
Hello everyone! Today we posted our first Youtube Video! In this video, we gave an introduction to limits and covered the following topics: Limits Limits by Estimation Right-Sided Limits Left Sided Limits Comment below if you want me to cover Read more…
Partial Fraction Decomposition is a great way to solve seemingly complex integrals. While it may look complicated, it is actually a very straightforward and easy concept to learn. Accordingly, we have created the following PDF to help you master this Read more…
Defined by and named after Leonhard Euler, Euler’s Formula not only changed the way mathematicians analyze functions, polar coordinates, and cartesian coordinates, but it also paved the way for arguably, mathematic’s most beautiful equation: Euler’s Identity. Euler’s Identity Termed by Read more…
SELECT CONVERT(VARCHAR(10), getdate(), 101); Outputs in mm/dd/yyyy SELECT CAST(getdate() AS date); To get the current date time: SELECT getdate(); SELECT CURRENT_TIMESTAMP; Other related functions: ELECT CONVERT (time, SYSDATETIME()) ,CONVERT (time, SYSDATETIMEOFFSET()) ,CONVERT (time, SYSUTCDATETIME()) ,CONVERT (time, CURRENT_TIMESTAMP) ,CONVERT (time, GETDATE()) Read more…
SQL Server Developers are responsible to perform following activities: Designing databases and ensuring their stability, reliability, and performance. Design, create, and implement database systems based on the end user’s requirements. Impove application’s performances. Prepare documentations for database applications. Memory management Read more…
Public Function WriteToEventLog(ByVal Entry As String) Dim appName As String = “Your Application” Dim eventType As EventLogEntryType = EventLogEntryType.Error Dim logName = “Application” Dim objEventLog As New EventLog() Try If Not EventLog.SourceExists(appName) Then EventLog.CreateEventSource(appName, logName) End If objEventLog.Source = appName Read more…
