Chapter 1 of 6 These videos were developed for PowerShell version 1, but the material is still valid. All training video labs can be found here: https://www.sapien.com/books_training/Self-Paced-Training Learn how to use Windows PowerShell -- whether you are administering Windows, Exchange Server, or any other PowerShell-enabled product. PowerShell MVP and guru Don Jones, one of the world's most experienced PowerShell instructors, guides you through PowerShell's basics -- assuming no prior experience. You will learn about cmdlets, the pipeline, WMI and ADSI within Windows PowerShell, and much more. Don's conversational style, conceptual animations, extensive demonstrations, and real hands-on exercises help you learn quickly and effectively.
Views: 10327 SAPIEN Technologies
This part three of the series, How to install Oracle 12c in Windows 8.1 PC. In this video we will explore how to connect to the Oracle 12c database that was installed using the method described in the second video
Views: 34698 Sam Dhanasekaran
PowerShell & SQL Server | http://www.pluralsight-training.net/microsoft/courses/TableOfContents?courseName=powershell-and-sql-server No Uber-scripting language would be complete without the ability to store and retrieve data from a database. In this video excerpt from Robert Cain's new course PowerShell and SQL Server you'll see how to use the Invoke-SqlCmd commandlet to query a SQL Server database and how to inspect the data it returns. In the full course he also covers topics such as performing basic DBA tasks, developer-centric tasks, and real world topics. Visit us at: Facebook: https://www.facebook.com/pluralsight Twitter: https://twitter.com/pluralsight Google+: https://plus.google.com/+pluralsight LinkedIn: https://www.linkedin.com/company/pluralsight Instagram: http://instagram.com/pluralsight Blog: http://blog.pluralsight.com/ 3,500 courses unlimited and online. Start your 10-day FREE trial now: https://www.pluralsight.com/a/subscribe/step1?isTrial=True Invoke-Sqlcmd cmdlet in SQL Server with PowerShell | Pluralsight -~-~~-~~~-~~-~- Push your limits. Expand your potential. Smarter than yesterday- https://www.youtube.com/watch?v=k2s77i9zTek -~-~~-~~~-~~-~-
Views: 15501 Pluralsight
Presented on May 17, 2017 by Data Platform MVP Ben Miller Think of questions that you could ask about an environment that is database rich. How many databases do you have, across how many servers? How has the data grown and how much disk space will we need over the next 2 years? So many questions to be asked and there are not a lot if any views or functions that can tell you what happened a day ago or even last week. Do you know how many databases you had at the beginning of the year or at the end of the year without having to dig through logs or other places? This session will cover using PowerShell to get information quickly and putting it in a repository that you can use the answer these questions. Not only that, but you can use it proactively in your career as a DBA. PowerShell has some great tools and using SMO you can gather and store all that information. Join me in the quest to become a PowerShell DBA and have information at your fingertips to help you in your career.
Views: 1856 PowerShell Virtual Group
How to execute sql and Sqlplus commands from an external script
Views: 85310 jbleistein11
In watching this episode, you'll get a first look at how you can use operations management and security, the unified management of your Linux and Windows server environments at scale, with Microsoft Azure. You'll see configuration management in your hybrid environment, applications using resource manager templates and PowerShell DSC applying your IT policy with OMS. Also, a look at orchestrating operational tasks using PowerShell and graphical Runbooks.
Views: 21873 Microsoft Mechanics
In this how to video Josh Atwell walks through the installation of the SolidFire PowerShell Tools with the installer and listing the available cmdlets in the 1.0 release using the GetSFCommand cmdlet. Access the SolidFire PowerShell Tools at http://www.github.com/solidfire/powershell Join the discussion at http://developer.solidfire.com
Views: 114 NetApp SolidFire
Manage hosts outside your domain or workgroup devices using CredSSP. How to guide for enabling CredSSP on both host and management device. Connect to and manage Hyper-V with CredSSP. Resolve Kerberos authentication issues. http://techthoughts.info/managing-hyper-v-with-credssp
Views: 1377 TechThoughts
In this video, you will learn how to install and configure the PowerApps on premise data gateway. This will allow you to connect to your on prem SharePoint, SQL, and other data sources from PowerApps out in the cloud. PowerApps Gateway Docs https://docs.microsoft.com/en-us/powerapps/gateway-reference PowerApps High Availability Clusters https://docs.microsoft.com/en-us/power-bi/service-gateway-high-availability-clusters If you need PowerApps consulting check out https://www.BoldZebras.com
Views: 6251 Shane Young
Access your databases through command line, instead of user graphical user interface.
Views: 297714 ICT Trainer
Learn how to connect to Oracle Database Cloud Service using Oracle SQL Developer ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll and http://docs.oracle.com Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 7748 Oracle Learning Library
Please note that this is a recorded webinar. It was recorded during live presentation. In this webinar, Rob will show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed module dbatools. Afraid of PowerShell? Worried it’s too complicated? Don’t want to go through the learning curve? Rob will show you with plenty of demos how easy and straight forward it can be and he will save you time starting Monday Want to restore an entire server’s databases to the latest available point in time of the backups in just one line? Be useful to know the Last DBCC Check for your entire estate in only one line of code? Need to test your restores but its complicated? and many many more All this in a fast paced, fun session. Webinar resources including presentation, demo files, code snippets and more learning material is available on http://www.dataplatformgeeks.com/ (Join for free and access all the resources) As a DPG member, you have free access to all our learning resources like videos, Hands-On-Labs & past event resources. Suggest us topics that you wish to learn through our webinars: http://www.dataplatformgeeks.com/dpg-suggest-topics/ Connect with DataPlatformGeeks: http://www.dataplatformgeeks.com/ http://www.twitter.com/SQLServerGeeks https://www.facebook.com/SQLServerGeeks Email us: [email protected] Have technical questions? Join the largest SQL/Data group on FaceBook – https://www.facebook.com/groups/thesqlgeeks/ LinkedIn Group: https://www.linkedin.com/groups/6753546 DataPlatformGeeks (DPG) Community Join the fastest growing community of data & analytics professionals Why Join DPG? http://www.dataplatformgeeks.com/ -Attend all events hosted by DPG, including SQLMaestros Special Events -Get access to free videos, labs, magazines and host of learning resources -Download all events & conference material -Learn new skills. Sharpen existing skills -Be part of Asia’s Largest Data/Analytics Community -Opportunity to be a regional mentor & speaker at our events -Immense technical & professional development -http://www.dataplatformgeeks.com/ Do you know about Data Platform Summit (DPS)? Learn about the largest Data/Analytics Learning Event in Asia. http://www.DPS10.com | [email protected] A word from our sponsors SQLMaestros Hands-On-Labs Want to practice SQL, Azure & BI concepts, step-by-step with exercises, screenshots, instructions & explanations? Get access to 100+ labs covering the entire Microsoft Data Platform stack. Try SQLMaestros Hands-On-Labs – the new way of practical, self-paced learning. Anytime. Anywhere. http://hols.SQLMaestros.com Email [email protected] SQLMaestros Video Courses http://sqlmaestros.com/sql-server-videos-courses/ SQLMaestros Master Classes & Accelerators http://sqlmaestros.com/ SQL Health Check http://sqlmaestros.com/ Advanced SQL Training (On-site) Want your team to experience Amit Bansal's Advanced SQL Training? http://www.SQLMaestros.com Email [email protected] Corporate Training Looking for any other high-end technology training for your team? http://www.PeoplewareIndia.com Email [email protected] Connect with the founder of DataPlatformGeeks/SQLServerGeeks Follow on Twitter: https://twitter.com/A_Bansal Follow on FaceBook at http://www.facebook.com/amit.r.bansal Follow on LinkedIN: http://www.linkedin.com/in/amitbansal2010 Facebook Page: https://www.facebook.com/AmitRSBansal
Views: 666 DataPlatformGeeks & SQLServerGeeks
How to export data in CSV format from Oracle database using Python. Export CSV data from Oracle 12c release 1 using Python 3.4 in Windows platform. Source Code link : https://drive.google.com/file/d/0BznrW3lgX0ozSENyZ3JOWlBqbnM/view?usp=sharing Link to Oracle 12c client library : https://pypi.python.org/pypi/cx_Oracle/5.1.3. Just chose your version matching your installed python
Views: 4288 Subhroneel Ganguly
This Video describes the different types of Oracle Database Client installations that you can perform. Here is how to instal Oracle Client 184.108.40.206 on Windows 8 and connect remote oracle database. Oracle : Client Technology Lair : www.technologylair.org Subscribe : http://www.youtube.com/subscription_center?add_user=technologylair For More Videos : http://www.youtube.com/user/technologylair/videos For Video Tutorials :http://www.youtube.com/playlist?list=PLC71CFFF7A916DCAA For Android : http://www.youtube.com/playlist?list=PLUXK1VpPWQKHI1l-NvM5jvNKKnmNy9eHp For Linux : https://www.youtube.com/playlist?list=PLUXK1VpPWQKHV2xOmjQgUNj3Hrmcslj-H Kalam e Iqbal : http://www.youtube.com/playlist?list=PLF057785BD260F061 Like us on Facebook : https://www.facebook.com/technologylair Tweet us : http://twitter.com/technologylair Follow us : https://plus.google.com/u/0/118196883367288585963/posts Pin us : http://www.pinterest.com/technologylair/
Views: 86975 TechLair
steps to connect to oracle database through command prompt.....!!!!
Views: 69329 navingupta52
This video tutorial covers how to configure ODBC to access a Microsoft SQL Server database. More guides and tutorials: http://www.itgeared.com/.
Views: 290873 itgeared
If you have any question, leave it in comment section below. Download links (Yes, you will have to register.): MySQL server: http://dev.mysql.com/downloads/mysql/ (Download installer. Not zip file) MySQL Workbench: http://dev.mysql.com/downloads/tools/workbench/5.2.html MySQL JDBC driver: http://dev.mysql.com/downloads/connector/j/ Source code available here: https://github.com/BranislavLazic/JdbcTutorials
Views: 34444 Lazic B.
Learn more about Logical Read: http://slrwnds.com/LogicalRead_TasksPt2 In part 2, we dive into examples of performing common SQL Server management tasks with PowerShell. Connect with SolarWinds: THWACK IT Community: http://thwack.solarwinds.com/ Facebook: https://www.facebook.com/SolarWinds Twitter: https://twitter.com/solarwinds LinkedIn: http://www.linkedin.com/company/solarwinds Instagram: http://instagram.com/solarwindsinc/ Flickr: http://www.flickr.com/photos/solarwinds_inc/
Views: 1562 solarwindsinc
Wanna support me? Visit: https://www.patreon.com/nehaljwani
Views: 27919 Nehal J Wani
The speed of creating an Analysis or an Overview of the KPIs in a company is growing in significance. To make quality decisions, one needs both quality data and up-to-date data. Without accurate live data, it’s difficult to steer the ship. This session will look at today’s methods of live data streaming and in doing that we’re going to look at the famous IoT world. This session will incorporate samples using live key-strokes input, followed by more real-life samples. Excel, Visual Studio, Azure Data Streaming, PowerShell and Power BI will be shown. The session will require a camera to show Phone and Tablet Dashboard. Follow us on Twitter - https://twitter.com/mspowerbi More questions? Try asking the Power BI Community @ https://community.powerbi.com/
Views: 46317 Microsoft Power BI
Azure SQL Database and managed instances allow you build globally scalable applications with extremely low latency. Azure SQL Database is the best cloud database offering in market. In this session, we take a detailed look at the migration lifecycle and show you how we have made it easy to migrate SQL Server and Oracle instances to Microsoft Azure by using the Azure Database Migration Service and related tools. We also cover most commonly seen migration blocking scenarios and demonstrate how our service can unblock your migration to Azure SQL Databases. We also deep dive into how to perform scale migrations using our CLI components.
Views: 758 Microsoft Ignite
In this video I am going to show you two workarounds for the latest Remote Desktop CredSSP Encryption Oracle Remediation error. Please be advised this is temporary and must be removed once all the servers have been patched with the latest security updates. Full information about the CredSSP vulnerability and security update: https://support.microsoft.com/en-us/help/4093492/credssp-updates-for-cve-2018-0886-march-13-2018
Views: 49176 NLB Solutions
Here you will learn how you can fetch list of running sessions/processes in BluePrism using Powershell and SQL. Tips are provided at multiple points to make video useful.
Views: 975 Practical Matter
Oracle SQL Tutorial 1:How to connect to oracle database through command prompt
Views: 72603 Math Cube
PowerShell Summit videos are recorded on a "best effort" basis. We use a room mic to capture as much room audio as possible, with an emphasis on capturing the speaker. Our recordings are made in a way that minimizes overhead for our speakers and interruptions to our live audience. These recordings are meant to preserve the presentations' information for posterity, and are not intended to be a substitute for attending the Summit in person. These recordings are not intended as professional video training products. We hope you find these videos useful - the equipment used to record these was purchased using generous donations from members of the PowerShell community.
Views: 1465 PowerShell.org
Views: 995 Trevor Sullivan
Note: This was the second run, the first run having more upfront discussion but lots of broken demos (https://youtu.be/97is2JLEoM8). Third time's a charm? Sample code and slides here (but for modules you should really use Install-Module): https://www.codykonior.com/files/2017/03/2017-03-01%20Operational%20Validation.zip Are you accountable for databases or database servers? Do you fix problems only to see them pop up again months or years later in slightly different scenarios? Have you been called at 2am and asked to “health check” hundreds of servers for an issue that nobody in the world has ever documented before and wished there was an easy mode to do that or even avoid the problem in the first place? If so then Operational Validation can help you. In this session you’re going to get: * A mindset on how to handle your day to day duties in a way that keeps you efficient, honest to yourself and to others, while covering your posterior. * Free tools to fix things and make sure they stay fixed over time. Really free. As in you couldn’t pay for them even if you wanted to. If you work with one instance you’re going to learn how to manage five hundred instances. And if you work with five hundred instances you’re going to learn how to have fun doing it. We’re going to learn: * Jenkins, a cool web application you can install on your workstation to provide orchestration and reports. * How to integrate PowerShell with Jenkins and multi-thread efficiently in the background with PoshRSJob using ready-to-go templates so you don’t need to worry about how it works. * Then we’re going to write some tests. They’re not going to be beautiful tests. We’re going to be testing some of the scummiest, most crapulent edge cases SQL Server has to offer. Please bring tissues because there will be tears. If you’ve ever said, “I don’t know what to test”, I’ll make you regret it. I’ll also discuss a few other PowerShell modules like CimSession and DbData and why you might want to use them for reliable and scalable tests. By the end of the session you should be bouncing off the wall and reconsidering your life. I want you to start screaming about Operational Validation from the rooftops, and have the tools and know-how to quickly start on your own.
Views: 489 Cody Konior
This video shows how you can use AutoSQL (https://www.autosql.net) to schedule a SQL query and send the results by mail. In the example a SQL server is used to run a query of overdue invoices. If there are any, a mail is send with an Excel attachment containing the results.
Views: 11772 AutoSQL
https://www.quest.com/products/toad-devops-toolkit/ Learn how to use Unit Test in Toad DevOps Toolkit, the solution from Quest that makes it easy to execute key database development functions within your DevOps workflow —without compromising quality, performance or reliability.
Views: 146 Quest
Mete Atamel (@meteatamel) shows how to manage Google Cloud Client resources using PowerShell Documentation: https://googlecloudplatform.github.io/google-cloud-powershell GitHub: https://github.com/GoogleCloudPlatform/gcloud-powershell Issues: https://github.com/GoogleCloudPlatform/gcloud-powershell/issues Stackoverflow: http://stackoverflow.com/questions/tagged/gcloud-powershell
Views: 2231 Google Cloud Platform
How To Rename A Windows Server 2016 Domain Controller Hostname Using PowerShell Please visit out blog: https://www.ntweekly.com
Views: 2969 WWWNTWEEKLYCOM
https://www.quest.com/products/toad-devops-toolkit/ Learn how to use Script Execution in Toad DevOps Toolkit, the solution from Quest that makes it easy to execute key database development functions within your DevOps workflow —without compromising quality, performance or reliability.
Views: 184 Quest
Christina Compy joins Scott Hanselman to talk about the recently relaunched App Service Hybrid Connections. This feature enables your apps in the App Service to reach resources on other networks. Those other networks can be in Azure, on-premises or networks in other cloud providers. Azure App Service Hybrid Connections: https://docs.microsoft.com/en-us/azure/app-service/app-service-hybrid-connections
Views: 4454 Microsoft Azure
An excerpt from Chrissy LeMaire's "PowerShell and SQL Server: My Journey to 200,000 Rows a Second" session at #PSConfEU 2016. For more ways to speed up your SQL Server management, check out her new site, dbatools.io! Full session video coming soon!
Views: 494 Amanda Debler
Make sure you close the PowerShell ISE session window and start again in new for changes to take effect else you will continue to receive these errors Exception calling "Fill" with "1" argument(s): "Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64-bit mode with the 32 bit Oracle client components installed." At .ps1:216 char:2 + [void]$da.Fill($ds) + ~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) , MethodInvocationException + FullyQualifiedErrorId : InvalidOperationException
Views: 2820 Maruti AIR Tech
Create powerful web database applications quickly. This tutorial explains how to connect to external databases, Active Directory and LDAP servers from Aware IM.
Views: 3137 awareim1