Home
Search results “Service broker in msdb”
Why Don't You Teach Service Broker? (Dear SQL DBA Episode 61)
 
23:17
I've gotten a few questions about whether I recommend learning Service Broker, and recently I was asked if I'm planning to make any courses on Service Broker. In this episode, I talk about why I personally haven't become an expert with Broker, the factors that I believe play into Service Broker adoption, and other resources online for learning Service Broker in SQL Server.
SQL Server Service Broker Interview Questions
 
01:10
Interview Questions for SQL Server Service Broker.What makes your comforts about an SQL Server Service Broker position?What strategic plan did you have as an SQL Server Service Broker?Tell me about how you worked effectively under pressure.Example when you went above and beyond the call of duty.Do you prefer to work independently or on a team?
Views: 118 Interview Questions
Como activar la entrega de mensajes de Service Broker en las bases de datos
 
03:57
De forma predeterminada, la entrega de mensajes de Service Broker está activa en una base de datos cuando ésta se crea. Si la entrega de mensajes no está activa, los mensajes permanecen en la cola de transmisión. Para determinar si Service Broker está activo para una base de datos, compruebe la columna is_broker_enabled de la vista de catálogo sys.databases La activación de Service Broker permite entregar los mensajes a la base de datos. Se debe crear un extremo de Service Broker para enviar y recibir mensajes desde fuera de la instancia. Para activar Service Broker en una base de datos • Modifique la base de datos para establecer la opción ENABLE_BROKER
Views: 1652 sabinadicto
How to move the system database files in SQL Server
 
13:37
Sometimes installation defaults are missed, or storage is added, and you need to move the system database files to a new location. In this video, watch Microsoft Certified IT Professional Jon Seigel show you how to perform this procedure, including how to set the security permissions on the target folder. Blog post for this video: http://voluntarydba.com/post/2012/09/06/Moving-the-System-Databases.aspx Visit my channel for more database administration videos: https://www.youtube.com/voluntarydba Subscribe to get notified about my latest videos: https://www.youtube.com/voluntarydba?sub_confirmation=1 Read additional content on my blog: http://voluntarydba.com Follow on Twitter: https://twitter.com/voluntarydba Like on Facebook: https://facebook.com/voluntarydba
Views: 37041 Voluntary DBA
Configure Database Mail, Operator and Notifications in SQL Server
 
13:18
https://www.youtube.com/user/masterkeshav There has been a lot of queries asking me to post a something on how we can setup a system to detect issues when, my replication fails or SQL Job fails or there is an alert fired. To be able to fix these issues its really important to get notified in time as timely notification can only lead to timely resolution. I have demonstrated the same in this video session. You will learn to setup 1.) SQL Server Database Mail system 2.) Setup Operator 3.) Use it to get notified wherever there is a glitch in any SQL Job or replication.
Views: 50358 Keshav Singh
SQL Server DBA Tutorial 126-Send Email to Multiple Email accounts From SQL Server Agent if Job Fails
 
10:18
In this video you will learn how to send email to multiple recipients (email addresses) if SQL Server Agent Job fails. It demonstrates using couple of methods. 1- Send email to multiple accounts (recipients) using sp_send_dbmail store procedure 2- Send email to multiple accounts (recipients) using configured Operator (SQL Server Agent Operator) Blog post link for the video with script http://sqlage.blogspot.com/2015/04/how-to-send-email-to-multiple-email.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 8592 TechBrothersIT
How to configure tempdb in SQL Server
 
07:51
The tempdb system database comes out-of-the-box with settings that don't perform well for many production workloads. In this video, Microsoft Certified IT Professional Jon Seigel explains three important considerations to configure tempdb for optimal performance, including an in-depth discussion about how to choose the number of data files to create. Blog post: http://voluntarydba.com/post/2013/12/10/Standard-configuration-of-tempdb.aspx How to enable Instant File Initialization: http://www.youtube.com/watch?v=XW-O_a8mZgs Read more about sys.dm_os_waiting_tasks: http://technet.microsoft.com/en-us/library/ms188743.aspx Read more about sys.dm_os_wait_stats: http://technet.microsoft.com/en-us/library/ms179984.aspx Read more about DBCC SQLPERF: http://technet.microsoft.com/en-us/library/ms189768.aspx sys.dm_os_waiting_tasks query to find PAGELATCH_* waits: http://jsstatic.net/Content/SqlScripts/Show%20waiting%20tasks.sql Visit my channel for more database administration videos: https://www.youtube.com/voluntarydba Subscribe to get notified about my latest videos: https://www.youtube.com/voluntarydba?sub_confirmation=1 Read additional content on my blog: http://voluntarydba.com Follow on Twitter: https://twitter.com/voluntarydba Like on Facebook: https://facebook.com/voluntarydba
Views: 19078 Voluntary DBA
SQL Server DBA Tutorial 106-How to Create Resource Pool in Resource Governor of SQL Server
 
06:57
In this video you will learn how to create Resource Pool in Resource Governor of SQL Server using SQL Server Management studio as well as using T-SQL script. It demonstrates application of Resource Pool best practices, when to create resource pool, step by step process of creating resource pools for different application, configuring Physical resources of SQL Server such as CPU, Memory and Physical IO. link to blog post for this video with scripts: http://sqlage.blogspot.com/2015/03/how-to-create-resource-pool-in-resource.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 6232 TechBrothersIT
SQL Server DBA Tutorial 111-How to Stop and Start Database Mirroring Endpoints in SQL Server
 
03:56
In this video you will learn how to Stop and Start Mirroring endpoints in SQL Server, it shows step by step resolution to mirroring issue " Database stuck in recovery state in Mirroring" It illustrates how to check the status of Mirroring, how to stop Mirroring endpoint using T-SQL Script, checking status of mirroring after stopping the endpoints, how to start the Mirroring endpoints and checking the status of Mirroring after starting Mirroring endpoints. Blog post link for the video: http://sqlage.blogspot.com/2015/03/how-to-stop-and-start-database.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 9320 TechBrothersIT
SQL Server 2012 tutorial: Permissions applied to securables | lynda.com
 
05:51
SQL Server permits the assignment of permissions to securables, for the purpose of controlling user actions. This tutorial takes a look at the different permissions that can be applied to securables, both at the server and the database level. Watch more at http://www.lynda.com/SQL-Server-tutorials/Securing-SQL-Server-2012/137884-2.html?utm_campaign=sH6eFJ6SyEg&utm_medium=viral&utm_source=youtube. This tutorial is a single movie from the Securing SQL Server 2012 course presented by lynda.com author Gerry O'Brien. The complete course is 1 hour and 36 minutes and shows how to make sure your network's SQL Servers are secure, using best practices for physical, instance, network, and file system security. Introduction 1. Security Best Practices for SQL Server 2. SQL Server Security Basics 3. Understanding and Using SQL Server Permissions 4. Creating and Assigning Logins and Roles 5. Securing SQL on the Network Conclusion
Views: 31092 LinkedIn Learning
How to enable Instant File Initialization in SQL Server
 
02:53
SQL Server normally writes zeros to new portions of data files. Enabling Instant File Initialization bypasses this process, allowing for faster recovery, restore, and response. In this video, Microsoft Certified IT Professional Jon Seigel shows you how to enable this feature, and verify that it's been enabled correctly. Blog post for this video: http://voluntarydba.com/post/2012/09/11/Enable-Instant-Data-File-Initialization.aspx Visit my channel for more database administration videos: https://www.youtube.com/voluntarydba Subscribe to get notified about my latest videos: https://www.youtube.com/voluntarydba?sub_confirmation=1 Read additional content on my blog: http://voluntarydba.com Follow on Twitter: https://twitter.com/voluntarydba Like on Facebook: https://facebook.com/voluntarydba
Views: 2834 Voluntary DBA
How to Send Email from MS SQL Server
 
05:24
A short video tutorial showing you how to set up SQL Server Database Profile and Account for your Outlook Email Account Outlook Mail Server Info: Port ID: 587 Server Name: smtp-mail.outlook.com Please subscribe as I'll be posting more videos weekly! https://www.youtube.com/channel/UCvVZ... For any question, please email me at [email protected]
Views: 6329 Jie Jenn
Microsoft SQL Server
 
49:15
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users. Its primary query languages are T-SQL and ANSI SQL. This video is targeted to blind users. Attribution: Article text available under CC-BY-SA Creative Commons image source in video
Views: 124 Audiopedia
How to call native SQL queries with JPA and Hibernate
 
13:32
Join the free Member Library and download your ebook about native queries: https://goo.gl/dfqr6n More information about SqlResultSetMappings: https://goo.gl/onPhOy JPQL is the most common way to query data from a database with JPA and Hibernate. But it supports only a small subset of the SQL standard, and it also provides no support for database specific features. So what shall you do, if you need to use a database-specific query feature or your DBA gives you a highly optimized query that you can’t transform into JPQL? Just ignore it and do all the work in the Java code? Or get a JDBC connection to execute the query? Of course not! JPA has its own query language, but it also supports native SQL. You can create these queries in a very similar way as JPQL queries, and they can even return managed entities if you want. Read the accompanying post: https://thoughts-on-java.org/jpa-native-queries/ If you like this video, please give me your thumbs up and share it with your friends and co-workers. Like my channel? Subscribe! ➜ http://bit.ly/2cUsid8 Want to connect with me? Blog: http://www.thoughts-on-java.org/ Twitter: https://twitter.com/thjanssen123 Facebook: https://www.facebook.com/thoughtsonjava
Views: 14231 Thoughts On Java
Creating a Master Data Solution with SQL Server Master Data Services (MDS) | Microsoft on edX
 
01:57
Learn how to manage Master Data Management (MDM) solutions with SQL Server 2016 Master Data Services (MDS) to deliver authoritative, standardized, and validated versions of your data. In this computer science course, we will discuss the discipline of Master Data Management (MDM) and how to deliver and manage MDM solutions with SQL Server 2016 Master Data Services (MDS). The course has been written specifically for data professionals. You will learn about common MDM scenarios, and how MDS solutions can be designed, developed, secured and managed. What you'll learn The benefits of Master Data Management (MDM) SQL Server 2016 Master Data Services (MDS) capabilities and features Developing MDS Models Managing Master Data Managing Model Versioning Integrating Master Data Administering MDS Securing MDS
Views: 4840 edX