Create Report in Seconds by Fetching Data from SQL Server using Excel VBA
If your manager needs the report very frequently then you need to do the same task again and again.
Frankly speaking, I faced this kind of situation in my previous company and I prepared the report using VBA and handed over the file to my manager.
Now, whenever he will click the button he will get the report of the LIVE DATA from SQL to Excel.
You can read our blog to go through instructions as well as download working and code files, Click here:
http://yodalearning.com/tutorials/export-data-from-sql-to-excel-spreadsheet-using-vba/
You can enroll in our Excel VBA course: http://courses.yodalearning.com/p/excel-vba-tutorials
CHECK SOME OF THE FREE COURSES WE OFFER
http://courses.yodalearning.com/p/free-office-2016-tips
Keep yourself updated. Follow us now!
http://www.facebook.com/yodalearning
http://www.twitter.com/yodalearning

Learn more about connecting to databases with R: https://www.datacamp.com/courses/importing-data-in-r-part-2
Welcome to part two of importing data in R! The previous course dealt with accessing data stored in flat files or excel files. In a professional setting, you'll also encounter data stored in relational databases. In this video, I'll briefly talk about what a relational database is and then I'll explain how you can connect to it. In the next video, I'll explain how you can import data from it!
So, what's a relational database? There's no better way to show this than with an example. Take this database, called company. It contains three tables, employees, products and sales.
Like a flat file, information is displayed in a table format. The employees table has 5 records and three fields, namely id, name and started_at. The id here serves as a unique key for each row or record. Next, the products table contains the details on four products. We're dealing with data from a telecom company that's selling both with and without a contract. Also here, each product has an identifier. Finally, there's the sales table. It lists what products were sold by who, when and for what price. Notice here that the ids in employee_id and product_id correspond to the ids that you can find in the employees and products table respectively. The third sale for example, was done by the employee with id 6, so Julie. She sold the product with id 9, so the Biz Unlimited contract. These relations make this database very powerful. You only store all necessary information once in nicely separated tables, but can connect the dots between different records to model what's happening.
How the data in a relational database is stored and shuffled around when you make adaptations, depends on the so-called database management system, or DBMS you're using. Open-source implementations such as MySQL, postgreSQL and SQLite are very popular, but there are also proprietary implementations such as Oracle Database and Microsoft SQL server. Practically all of these implementations use SQL, or sequel, as the language for querying and maintaining the database. SQL stands for Structured Query Language.
Depending on the type of database you want to connect to, you'll have to use different packages. Suppose the company database I introduced before is a MySQL database. This means you'll need the RMySQL package. For postgreSQL you'll need RpostgreSQL, for Oracle, you'll use ROracle and so on. How you interact with the database, so which R functions you use to access and manipulate the database, is specified in another R package called DBI. In more technical terms, DBI is an interface, and RMySQL is the implementation. Let's install the RMySQL package, which automatically installs the DBI package as well. Loading only the DBI package will be enough to get started.
The first step is creating a connection to the remote MySQL database. You do this with dbConnect(), as follows.
The first argument specifies the driver that you will use to connect to the MySQL database. It sure looks a bit strange, but the MySQL() function from the RMySQL package simply constructs a driver for us that dbConnect can use. Next, you have to specify the database name, where the database is hosted, through which port you want to connect, and finally the credentials to authenticate yourself. This is an actual database that we're hosting, so you can try these commands yourself!
The result of the dbConnect call, con, is a DBI connection object. You'll need to pass this object to whatever function you're using to interact with the database. Before we do that, let's get familiar with this connection object in the exercises!

Graph extensions in SQL Server 2017 will facilitate users in linking different pieces of connected data to help gather powerful insights and increase operational agility. Graphs are well suited for applications where relationships are important, such as fraud detection, risk management, social networks, recommendation engines, predictive analysis, dependence analysis, and IoT applications. In this session we will demonstrate how you can use SQL Graph extensions to build your application using graph data. Download SQL Server 2017: Now on Windows, Linux, and Docker https://www.microsoft.com/en-us/sql-server/sql-server-vnext-including-Linux.

This tutorial will explain how to use Microsoft Access to create a working stock control database with some basic features. Follow along with our free download of the basic stock database we created in this video: http://www.software-matters.co.uk/free-access-stock-control-database.asp
All you need to get started is a copy of Access and a beginner's knowledge of how it works.
Get more help and advice on Excel, Access or VBA projects:
http://www.software-matters.co.uk/youtube_links.html
If you want to find out whether a bespoke database would be right for you, get in contact:
http://www.software-matters.co.uk/contact.asp
Learn more about our work:
http://www.software-matters.co.uk/projects-blog.html
Music by Kevin MacLeod
http://incompetech.com/music/royalty-free/
We have now uploaded a no music version of this video:
https://www.youtube.com/watch?v=049IlFNcrl0
---------------------------------------------
If you found this video helpful, please consider giving it a Like, leaving a comment or sharing it.
More from the Software-Matters channel:
https://www.youtube.com/channel/UCk-MVP61VQHMdfETVNQEFww
Visit the Software-Matters website:
http://www.software-matters.co.uk
Software-Matters is based in Gillingham, Dorset, in the south-west of the United Kingdom (UK), near Somerset, Wiltshire and Hampshire and the cities of Bournemouth, Poole, Southampton, Bristol, Bath and Salisbury.
----------------------------------------------
MORE INFORMATION:
To follow this tutorial you will need a full copy of Microsoft Access. The video was made using Access 2010, however the process is very similar in Access 2007 and Access 2013.
We'll be going as far as setting up the database tables, which traditionally would be stored in a so-called 'back end' database file, while forms, queries and report, which are not covered in any details by this tutorial, would be stored in a separate 'front end' database file. The tables from the back end are then 'linked' to the front end, so that it behaved as if all the objects were in one file.
In some places we have made the design deliberately simple in order to keep our relationships clean and the number of tables low. This helps those new to Access to get their heads around how to create the database, but for actual use, might cause problems. We recommend that you learn more about database design from other sources before beginning your project if you intend to use it for a real business.
Key topics to consider are: database normalisation theory; Inner, Left, Right and Outer Joins; Basic SQL (structured query language) use; Software Development Methodologies; UX (user experience) enhancement techniques; and of course, the very specific needs of your business, project or client.
All together, a broad knowledge of these topics will allow you to design your tables with enough foresight to make the setting up of the queries, forms and reports you'll need later as easy as possible. Plus it should make the system easy to use and less likely to be corrupted or crash.
Keep in mind that even if your stock database needs don't fit very well with our example parts database, or if you need an entirely different kind of system like an accounts database or CRM database, the lessons in this tutorial can still apply.

Video 2 in multi-part series that will help you become more familiar with QlikView. This video covers connecting to a Microsoft SQL Server database and accessing its tables and columns to get data needed for analysis.
Video 1 (Download and Install) can be found here: https://www.youtube.com/watch?v=aKQMhtQnaz0 and video 3 can be found here: http://www.youtube.com/watch?v=xwHNM18D9fE

Hello everyone, Welcome to the 61st episode of Microsoft hour of code brought to you by millionlights. Millionlights is a TV channel dedicated to improving skills of people and their employability.
Now, let me tell you more about Microsoft hour of code. Microsoft hour of code is a series of lectures, courses and talks by experts, who are going to discuss the latest Microsoft technologies, topics related to programming and industry forecasts that are all focused on employability.
Today we are going to learn developing Microsoft SQL Server Databases. This course is basically for people pursuing computer science. This content has been created by our partner Microsoft and today we have Graeme Malcom and Christian Bolton from Microsoft with us.
Our experts will take you through tables, indexes, stored procedures, and other database objects. Learn about techniques for designing indexes, managing transactions, and optimizing performance and concurrency. And get best tips and practices.
These courses can help you earn at least 4 lacks a year and for those who are already working, experience strongly influence pay in this job. So, you can definitely get an increment in your salary.
Now, let’s move towards the course, developing Microsoft SQL server databases.
The topics we will cover in this course are:-
Implementing tables and views
Implementing indexes
Implementing stored procedures and functions
Managing transactions
Implementing in-memory objects
Optimizing and troubleshooting queries.
So, let’s get started with implementing tables and views, in which we will find out how to implement disk-based tables, based on appropriate data types and constraints and how to implement table objects using variables, temporary tables, and common table expressions. How to implement views as a way of providing a de-normalized abstraction layer over the database schema for client applications.
That's all in this episode. I hope this tutorial was helpful. In the next episode, we will cover the remaining part of this topics and will see demo on table variables and temporary tables.
Is your mind ringing with questions, queries or doubts? Do you wish to learn more? Then, Visit our website www.millionlights.org and post your questions on our forums. We will be really happy to clear all your doubts. If you missed anything and want to re-watch it, you can download it from our website or can watch online as well. You can also participate in our webinars, discussions with the subject experts as well as get Microsoft certification on various courses, through our website. You can also find us on Facebook by the name millionlights and also on twitter.
For more such interesting tutorials on coding, app development, programming and building rich UI's, keep watching Microsoft hour of code brought to you by millionlights.
Thank you.
-~-~~-~~~-~~-~-
Please watch: "Live Lecture on HTML 5 and CSS 3"
https://www.youtube.com/watch?v=gLShU7uu4Dg
-~-~~-~~~-~~-~-

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
You can buy our Introduction to Excel VBA book here https://www.lulu.com/shop/andrew-gould/introduction-to-excel-vba/paperback/product-23301058.html
By Andrew Gould
https://www.wiseowl.co.uk - Connecting to databases in VBA sounds like it should be complicated, but using the ActiveX Data Objects, or ADO, Object Library makes life an awful lot easier! This video teaches you how to reference the library and how to create a connection to almost any type of database by providing the correct connection string (this video covers Microsoft Access and Microsoft SQL Server). We'll also show you how to grab a set of data from a database using recordset objects and even how to write SQL queries in your VBA procedures. The final part of the video talks about how you can take user input to modify the query to allow you to create a simply querying tool in VBA.
You can download the Access Movies database here:
https://www.wiseowl.co.uk/files/execise-question-files/qf-1103.zip
You can download the script to create the SQL Server Movies database used in this video at the following link:
https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

Recently I was invited to talk about beginning SMO on the SQL Undercover podcast. So I put together a tutorial to teach SMO in PowerShell from the very beginning.
This isn't a PowerShell tutorial; it's an SMO tutorial. So if you need to know how to use SMO to manage SQL Server, here's a 2hr beginning.
You can download the demo code either here http://www.midnightdba.com/beginning-sql-server-smo/ or https://sqlundercover.com/.

For more videos on technology, visit http://www.Techytube.com
By [email protected]
SQL server is a powerful database platform, this means that it can also be complex to understand and work with. However the major users of the data in the database are still a non-technical business user. A key problem that most business users face when it comes to working with SQL Server is the dependency on an IT professional to query and return the data in a CSV format or Excel sheet. With the ability of MS Excel to be able to connect to SQL Server via the ODBC Drivers allows users to work with SQL tables within the familiar Excel User interface. This approach allows users to be productive with SQL Server without having to know Transact SQL. The feature set provided with MS Excel and newer versions of SQL allow business users to do much more than just query the database. These include the ability to query and view data in pivot format for large data sets using power pivot. Perform ad hoc calculations to underlying data and create models that are specific to their business case using the powerful DAX language. Embedding reports in SharePoint services using PowerPivot.
Working with Excel is one of the most powerful ways that end users can work with MS SQL Server to deliver results faster and improve productivity.

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
By Andy Brown
https://www.wiseowl.co.uk - Learn how to create your first project and package in Microsoft's flagship ETL package, to import a table from SQL Server into an Excel workbook.
You can download the script to create the Movies database used in this video at the following link:
https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip
If you like the video but think there's no substitute for classroom training, go to https://www.wiseowl.co.uk/integration-services/ to book onto our two-day introduction to Integration Services course.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Integration Services, Visual Studio, ASP.NET, VB, C# and more!

For more insight, go to The Microsoft Press Store and buy the book
Training Kit (Exam 70-463) Implementing a Data Warehouse with Microsoft SQL Server 2012 (MCSA)
https://www.microsoftpressstore.com/store/training-kit-exam-70-463-implementing-a-data-warehouse-9780735666092
Note: This video expresses only my own independent views and opinions.

GenesisOne Unscrambler is the first in the industry to provide dataflow visualization for SQL Server. http://www.genesisonesolutions.com What we will show you on the user demo, is the unique code documentation capabilities, that automatically generates full legacy code documentation for large databases with complicated objects - you will also see how the Unscrambler is the ideal component to the highest quality metadata tools already available.
1. Dataflow Visualization for SQL Server
2. Partnered with IBM and Red Gate
3. GSA Contract Holder
4. Fortune 500 Companies
5. Automatic Source Code Documentation
6. Ideal Component for Metadata
We have partnered up with top organization such as IBM, and are a current federal GSA Schedule Contract holder. The GenesisOne technology is also being used by fortune 500 companies.
How will this help me?
Facilitates inventory taking of information systems for CIO’s.
Dramatically reduce time and cost necessary to document your databases.
Eliminate continuous document updates and synchronization after database changes.
Get new hires up to speed in less than half the time.
Increase your customer satisfaction by providing comprehensive, professional looking database documentation.
Fully standardize your SQL documentation with no effort.
Meet your audit/SOX requirements easily by keeping up-to-date documentation.
Product Overview
GenesisOne™ provides software development tools for the professional software developer. With our ever-expanding suite of code analysis tools, both developers and management gain thorough insight and understanding of their code. Starting with SQL Server, our tool suite (COTS products) shows all data flow within the code.
The GenesisOne™ T-SQL Source Code Unscrambler™ automatically scans all SQL Server objects and documents the code in detail, which has never been done before and is a breakthrough product for the software industry. The resulting documentation provides comprehensive graphical, tabular or verbal explanation of the structure and data flow of all scanned objects. This documentation can be printed to PDF, PNG or SVG as desired.
- See more at: http://www.genesisonesolutions.com/#sthash.DeLGA9zw.dpuf
Product Features
GenesisOne™ T-SQL Code Unscrambler
Automatically generates full legacy code documentation for large databases with complicated objects.
"By being able to 'unwind' dozens of legacy processes, quickly presenting the entire 'picture', both graphically and verbally, the user can more quickly grasp the complexity of a problem domain, or in other words, getting the "big picture". And therefore save time and money that can better be invested in actually solving the pressing business problem. UnScrambler is a tool that solves the problem of understanding hidden complexity."
GenesisOne™ SQL Server documentation (Microsoft SQL Server 2008/ 2008R2/ 2012) in PDF, PNG and SVG format; enables documenting all of the major SQL Server components. New documents can be regenerated at the touch of a button.
UnScrambler saved me hours, and in some cases, even days of manually printing out and tracing code, in order to understand what some of the old legacy procedures were doing -BEFORE we could even start working on the new requirements.
A Business Process owner can easily follow the UnScrambler Data Flow chart to help guide Developers when upgrading old procedures.
The T-SQL Code UnScrambler makes it easy for a Project Manager to visualize the extent of testing that will be necessary after we make changes to legacy procedures. The Dependency Diagram clearly shows every table, view, procedure, function –and even trigger, that may be impacted by code changes.
The UnScrambler Dependency Diagram makes it easy for me to get the ‘big picture’ of how all the parts fit together before I start digging into the actual code. I can click on any dependent object to quickly jump into its’ code.
Ability to standardize code documentation with zero effort.
The Unscrambler technology understands your security concerns and only uses selected permissions, so you can be assured no changes or havoc will effect your system.
GenesisOne™ application download includes Microsoft SQL Server Analysis Objects, Microsoft SQL Server Management Objects, Microsoft SQL Server Native Client and SQL Server CLR Types.
GenesisOne™ enables your ability to browse database structures. The structures shown depends on the database, the minimum level of detail includes Stored Procedures, tables, indexes and constraints as well as displaying information such as column names, column data types, column lengths, column null ability, and primary and foreign key information.
Description editor for tables (table, columns, indexes, foreign keys), Stored Procedures (stored procedure, parameters), defaults, rules. Description data is saved using SQL Server extended properties.
Please visit http://www.genesisonesolutions.com for more details.

How to Connect to SQL Server or How to Connect to SQL Server 2104
How to download and install ms SQL 2014: https://www.youtube.com/watch?v=FpZdzcCWRPg
Here I will explain following three points:
1) How to connect to SQL server using SQL server management studio.
2) What is SQL server management studio?
3) Different authentication methods used to connect SQL server
Before understanding this MS SQL sequel must be installed on your system.
So I request you please watch my previous video understand that how you can download and install SQL server on your system.
So friends to open the SQL server go to Start menu and select SQL server 2014 management studio.
You can also make a shortcut on your desktop.
I want to tell an important point that SQL server management studio and SQL database are two different things.
Here you can see that there are 3 combo boxes:
1) Server type
2) Server name
3) Authentication
Let's explain one by one
1) First one is server type: There are four options:
a) Database engine
b) Analysis services: It is also called SSAS
c) Reporting services: It is also called SSRS
d) Integration services: It is also called SSIS
We want to connect to database server, so we will select database engine
2) Second one is server name:
We need to specify server name here you have to give the name. Here sql server management studio and SQL server both of my machine so I have to give the server name or I have to give the IP address of my system.
It is good to give name because IP address can we change when you move from one location to another location
You can also use dot(.) or local here. So for this box you have 4 options
a) Server name
b) IP address of your system
c) .(dot)
d) local
Here we will select the server Name.
3) Third one is authentication: here we have two options:
a) Windows authentication
b) SQL server authentication
a) If we choose window authentication then you don't have to fill the username and password because Windows authentication basically uses the windows login that you used when you open the system means you are already authenticated.
b) When you Choose SQL server authentication means you are installing SQL server again, so you have to fill the username and password to authenticate yourself.
Information click on connect button. When you click on connect then it should connect to SQL server.
Window on the left hand side is called object Explorer window.
So if you want to write a query then click on new query button, a new query editor window will open where we will write the queries.
All the database like master, model, msdb are automatically installed on your system because these are mandatory for functionality of SQL server
-~-~~-~~~-~~-~-
Please watch: "Test Cases for Mobile"
https://www.youtube.com/watch?v=9f_rJdjzomE
-~-~~-~~~-~~-~-

Hello Friends...!!!
Welcome to TechtabInfo my name is Madhu this youtube channel for Technical and it security
Download link SQL
https://www.microsoft.com/en-ie/sql-server/sql-server-downloads
Download Link SSMS
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017
#sqlserver #sqlupgrade #sqldatabase
You can upgrade instances of SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 (11.x), SQL Server 2014 (12.x), or SQL Server 2016 (13.x), to SQL Server 2017. Before running SQL Server Setup to upgrade to SQL Server 2017, review the following articles about the upgrade process and the release notes.
Before upgrading from one edition of SQL Server 2016 (13.x) to another, verify that the functionality you are currently using is supported in the edition to which you are moving.
Before upgrading SQL Server, enable Windows Authentication for SQL Server Agent and verify the default configuration: that the SQL Server Agent service account is a member of the SQL Server sysadmin group.
To upgrade to SQL Server 2016 (13.x), you must be running a supported operating system. For more information, see Hardware and Software Requirements for Installing SQL Server 2016.
Upgrade will be blocked if there is a pending restart.
Upgrade will be blocked if the Windows Installer service is not running.
Unsupported Scenarios
Cross-version instances of SQL Server 2016 (13.x) are not supported. Version numbers of the Database Engine, Analysis Services, and Reporting Services components must be the same in an instance of SQL Server 2016 (13.x).
SQL Server 2016 (13.x) is only available for 64-bit platforms. Cross-platform upgrade is not supported. You cannot upgrade a 32-bit instance of SQL Server to native 64-bit using SQL Server Setup. However, you can back up or detach databases from a 32-bit instance of SQL Server, and then restore or attach them to a new instance of SQL Server (64-bit) if the databases are not published in replication. You must re-create any logins and other user objects in master, msdb, and model system databases.
You cannot add new features during the upgrade of your existing instance of SQL Server. After you upgrade an instance of SQL Server to SQL Server 2016 (13.x), you can add features by using the SQL Server 2016 (13.x) Setup. For more information, see Add Features to an Instance of SQL Server 2016 (Setup).
Failover Clusters are not supported in WOW mode.
Upgrade from an Evaluation edition of a previous SQL Server version is not supported.
When upgrading from RC1 or previous versions of SQL Server 2016 to RC3 or later versions, PolyBase must be uninstalled before the upgrade and reinstalled after the upgrade.
Website: https://techtabinfo.com
blogs: https://techtabinfo.blogspot.com
Facebook: https://www.facebook.com/Techtabinfo-495437450937576
Instagram: https://www.instagram.com/techtabinfo
Twitter: https://twitter.com/techtabinfo

-------------
If you have any question please feel free to ask and Please Don't forget to SUBSCRIBE our channel and get watch our latest videos.
-------------
In this video i'm going to help you "SQL Server Error 26 ".
-------------
Keywords :
SQL Server All versions
How To
Error
Fix
Drake In My Feelings Dance Challenge😍Compilation😍Best Ones
kiki
keke
KiKi Do You Love Me Challenge Dance Compilation
hoi an
Low
dh1.85
dh19.31
the hoxton
dh2.00
dh14.32
howo
dh2.19
dh8.17
geek
1K – 10K
dh0.19
dh7.17
meditation
dh0.09
dh3.87
to
dh0.11
dh1.62
study skills
100 – 1K
dh0.12
dh0.38
h to
wikipedia page
a hoe
how to iphone
how to for
to com
to do it
how wiki
howtogeek
how is going
wiki how to
wikihow
the how
hot do
ht to
how to wikihow
wiki ho
howtowiki
to hoe
how to https
wonder how to
hmhome

http://learningcomputer.com/
In this video tutorial we walk you through step by step process of installing SQL Server 2008 version on Windows Vista. We talk about the Hardware and Software requirements for MS SQL 2008 version; next we show you the SQL 2008 download location on Microsoft's website. In the beginning, it installs the .NET framework and updated windows installer. After the reboot, we continue onto an Install wizard screen with additional resources and tools for MS SQL 2008. We go over the Installation Center, Setup Support Rules, SQL Server New Feature selection. On the feature dialog box, one can select different MS SQL 2008 services to install. We recommend using Best Practice settings for service accounts; data file and log file locations related to installation of SQL Server 2005.

http://www.sqlserver2014tutorial.com/
In this SQL Server 2014 Tutorial for beginner, we cover SQL Server management studio. This is also known as SSMS.
We start the video training on MS SQL 2014 by showing you how to launch Management Studio. We cover how to use SQL Server Registered Servers. Next we move on to the Object Explorer, the heart of SSMS. We demonstrate all the various tabs including Database, Server objects, Security, Management and SQL 2014 Agent. We finish the SQL Tutorial by using Query Window, important tools including SQL Profiler and Database Engine Tuning Advisor. Finally we go over Template Browser which gives you sample SQL scripts that you can run to manage your database enterprise.

In this video, we discuss the new Analysis Services features in SQL Server 2017. We will cover Power Query connectivity, modeling enhancements such as Detail Rows allowing users to easily see transactional records, and improved support for ragged hierarchies. Download SQL Server 2017: Now on Windows, Linux, and Docker: https://aka.ms/sqlserver17linuxyt

In this video, you will understand the basics of SQL Server Statistics. How are they created and how are they updated.
Video 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)
Connect With The Speaker (Amit Bansal)
-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/
Connect with SQLMaestros: http://sqlmaestros.com/
-http://www.twitter.com/SQLMaestros
-https://www.facebook.com/SQLMaestros
-Email us: [email protected]
Have technical questions?
Join the largest SQL group on FB
www.facebook.com/groups/theSQLGeeks
Our 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
Do you know about Data Platform Summit? http://www.DPS10.com

Today we are going to learn how to install and use SQL server management studio (SSMS).
SQL Server Management Studio (SSMS) is a software application first launched with Microsoft SQL Server 2005 that is used for
configuring, managing, and administering all components within Microsoft SQL Server.
It includes both script editors and graphical tools which work with objects and features of the server.
Unlike previous versions of SQL server, management studio is not a part of SQL server installer any more.
we need to download latest version of SSMS from Microsoft website.
Installation process is very simple and easy. It needs very few clicks and 10-20 minutes.
As I said earlier SQL server management studio is used for managing all services of SQL server like database engine, reporting service,
analysis service etc..
now we are going to learn how to create a new database and table, so we need to connect database engine.
now we are connected with database engine....
Left side area is object explorer. various database objects are listed here.
The first folder is for database. A database is an organized collection of data. It is the collection of schemas, tables, queries, reports,
views and other objects.
To create new database, right click on database folder in object explorer and select new database.
Type the name of the database.. for example 'test_db'
SQL server database requires minimum two files. one database it self and another is log file. you can add more files if necessary.
for this tutorial we will go for default. but gradually we will learn all...
Finally click OK to create the database. After few seconds.... a new database called 'Test_db' will appear in object explorer.
Today we have learned how to create database using SQL server management studio. In next tutorial we will learn about 'Table'.
SQL SERVER 2017 TUTORIAL : PART 02 (Use SQL Server Management Studio)

Financial Data Mining, Part 1 -- Portfolio Management in Microsoft SQL, Data mining with Excel
Keith Siilats, 2/4/2012 CS246 Mining of Massive Datasets
1. Download Microsoft VHD for Mac/Windows/Unix
http://www.microsoft.com/download/en/details.aspx?id=26113
2. Download VirtualBox and configure it for HyperV
http://dynamicsnavax.blogspot.com/2011/04/how-to-run-ax2012-hyperv-on-virtualbox.html
3. Start your VHD and log in with Username Administrator Password [email protected]
4. Install Guest additions from VirtualBox Menu
5. Install shared folders
6. When the 10 day trial period finishes you can rearm up to 4 times
a. Click Start, and then click Command Prompt.
b. To reset the activation period, type slmgr.vbs --rearm, and then press ENTER.
7. Install Office http://technet.microsoft.com/en-us/evalcenter/ee390818
8. Get some stock data. Key is to get both sector and market cap info, sp500 is the largest 500 companies
a. http://www.stockmarketsreview.com/companies_sp500/
b. http://www.cboe.com/products/snp500.aspx
9. Sign up with www.tdameritrade.com It will take you 3 days to sign up and you will get $500. You will see in the video how to export sector data from tdameritrade, it's easier than using the links above.
10. Get an excel macro to download latest prices. You need excel to clean up all the junk prices. Going through text files is no fun. Hoping that machine learning algorithms know how to deal with rubbish data is optimistic. http://code.google.com/p/finance-data-to-excel/
11. Install Analysis Server samples http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20SQL%20Server%202008R2%20Databases See how Microsoft does basket analysis, recommendations and all the other algorithms we have covered in class (hint, it's a lot of point and click and very little code).
12. Watch the video on how to create a VBA script to generate data and export it to SQL server (this is the Map step). In practice you will have multiple pricing servers running complex derivative pricing monte carlos and clustered sql server over several machines with hot backup. If you would like to build a machine like this instructions are http://www.tpc.org/tpcc/results/tpcc_price_perf_results.asp Microsoft Analysis server will work with any SQL source including Oracle.
13. In class we will create a custom portfolio management cube. This is the Reduce step, but its kind of a universal reduce. Once you have the cube you connect to it from Excel Pivot Table and can create any Reduce real time. Tutorial on PivotTables http://www.timeatlas.com/5_minute_tips/chunkers/learn_to_use_pivot_tables_in_excel_2007_to_organize_data
14. Here is a tutorial connecting excel to sql server http://newtech.about.com/od/tutorials/ss/How-To-Configure-Excel-2010-Pivot-Table-For-Business-Intelligence.htm
15. Here is a tutorial how to connect Excel to the Analysis Server http://blogs.office.com/b/microsoft-excel/archive/2008/08/28/using-excel-excel-services-with-sql-server-analysis-services-2008.aspx
16. In the second part I will show you how to create cubes on tick data (trades and quotes) and do high frequency trading.

In this video, you will understand the concept of selectivity.
Video 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)
Connect With The Speaker (Amit Bansal)
-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/
Connect with SQLMaestros: http://sqlmaestros.com/
-http://www.twitter.com/SQLMaestros
-https://www.facebook.com/SQLMaestros
-Email us: [email protected]
SQLMaestros Master Classes
Wish to Attend Full-Day, Deep-Dive Training? SQLMaestros Master Classes are announced. Classes on SQL Server, SSRS, Power BI, SSIS, DevOps, Machine Learning, R, Python & Artificial Intelligence. http://www.sqlmaestros.com/
SQLMaestros Video Courses
Amit Bansal’s popular SQL Performance Tuning course is now going live in video format. http://sqlmaestros.com/sql-server-videos-courses/
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 Learning Kits
The kit comprises of PowerPoint presentations, lab manuals, workbook & instructor demos & notes. The kit is based on Amit Bansal’s Performance Tuning Master Class. https://sqlmaestros.com/sql-server-courseware/
SQL Server Health Check
If your SQL Server deployments are not performing good or if you have seen early signs of performance degradation, SQLMaestros can help you with a thorough health check. https://sqlmaestros.com/sql-server-health-check/
Have technical questions?
Join the largest SQL group on FB
www.facebook.com/groups/theSQLGeeks
Our LinkedIn group
https://www.linkedin.com/groups/6753546
Our Telegram group on mobile
http://www.dataplatformgeeks.com/dpg-mobile/
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
If you wish to speak at DataPlatformGeeks events, fill out this form: http://www.dataplatformgeeks.com/call-speakers-dpg-events/
If you wish to become a Regional Mentor with DataPlatformGeeks, fill out this form: http://www.dataplatformgeeks.com/become-regional-mentor/
Watch all recorded DPG webinars here: www.youtube.com/SQLServerGeeks
Data Platform Summit 2019 Pre-Registration is now Open
DPS 2019 will be officially launched in January 2019. However, you can pre-register yourself right now. This will indicate that you are interested in DPS 2019 and it will entitle you to the pre-launch discount code which will give you the lowest pricing for DPS 2019. The pre-launch code will only be shared with pre-registered individuals. Pre-registration does not cost you anything. Click Here to learn more: https://www.dataplatformgeeks.com/dps2019
Check out Data Platform Summit 2018 success - https://www.dataplatformgeeks.com/dps2018/

http://www.sqltrainingonline.com/free-training-excel-to-sql-server/
Excel to SQL Part #5 talks about turning your BCP command into a BAT script and scheduling it so that you can automate your movement of data from CSV to SQL Server.
To view all 5 free online videos in this training series and to download all of the training materials including the Microsoft Excel File, Tab Delimited File, CSV File, SQL files and Bat script, visit: http://www.sqltrainingonline.com/free-training-excel-to-sql-server/

In this Super SQL Tip Redgater Jamie Wallis explains how you can get suggestions to improve as you type with new code analysis rules in SQL Prompt.
SQL Prompt is a code completion, code formatting, and refactoring tool for SQL Server. It’ll plug into SQL Server Management Studio or Visual Studio. You’ll find you can work more quickly and accurately with SQL queries, as well as standardize across your team by sharing formatting styles and commonly used SQL snippets. Try it free for 28 days at https://www.red-gate.com/sqlprompt
For more tips for writing SQL effortlessly check out the #SuperSQLTips playlist: https://www.youtube.com/playlist?list=PLhFdCK734P8A_q6XHDXi4CQzys3R0Jw3X
Transcript:
Hi, it’s Jamie Wallis from Redgate software here and I’d like to show you how code analysis works in SQL Prompt.
I’m going to use SSMS here, but code analysis is also available Visual Studio.
First I’m going to use SQL Prompt tab history to open a query I’ve been working on.
As you can see there a now green underlines beneath parts of my code.
This indicates that there could be issues that need addressing.
When I hover over I can see quick tip about the issue, and when I click the part of the code I am checking is highlighted in green.
There is also a new lightbulb icon to the left of my query now, which opens the Issue Details panel when I click on it.
Here I can see further information about the issue and how I could fix it.
There is also a link to our online documentation which contains further reading about the rules.
Finally in this panel I can choose to disable the rule, which stops it displaying in my code.
To bring it back I simply click “Enable rule” again.
But there is another way to manage your code analysis rules.
In the SQL Prompt menu at the top here you can find “Manage code analysis rules”.
This opens the code analysis options menu, which gives you the full list or rules available, grouped together into related section.
To disable any I just uncheck the box next to the rule, and then press save when I’m done.
So there you have it, code analysis in SQL Prompt.
You can try it out now by downloading your free-trial from our website.
This is Jamie Wallis from Redgate Software.
Thank you for watching.

Download the completed Power BI Desktop file and data used in the video here: https://www.myonlinetraininghub.com/workbook-downloads
In this video you will learn how to create two interactive Power BI dashboards using the free Power BI tools available to everyone.
Get Power BI Desktop here: https://powerbi.microsoft.com/en-us/desktop/
Learn Power BI here: https://www.MyOnlineTrainingHub.com/power-bi-course
Subscribe to my free newsletter and get my 100 Tips & Tricks eBook here: https://www.myonlinetraininghub.com/sign-up-for-100-excel-tips-and-tricks

SQL Server Integration Services) This tool is used for the integration like duping the data from one database to another like from Oracle to SQL Server or from Excel to SQL Server etc. This tool is also used for bulk transactions in the database like inserting lac’s of records at once. We can create the integration services modules which will do the job for us.
SSIS TRAINING is the new data transformation standard for SQL Server 2005 & has replaced old SQL Server Data Transformation Services. Integration of services has been literally re-written from the scratch, so it is nothing same as Data transformation services (DTS) for SQL Server 2000 & earlier. Available as free 180day trail download or developer edition ($50)
SSIS TRAINING ONLINE COURSE CONTENT
SSIS USING SSMS
The Import and Export Wizard
Importing and Exporting Data
Working with Packages
Database Maintenance Plans
Creating Database Maintenance Plans using SSMS
SQL SERVER DATA TOOLS
Launching Data Tools
Project templates
The package designer
The Toolbox
Solution Explorer
The Properties window
The Variables window
The SSIS menu
INTRODUCTION TO CONTROL FLOW
Control Flow Overview
Precedence Constraints
The Execute SQL Task
The Bulk Insert Task
The File System Task
The FTP Task
The Send Mail Task and other Control Flow Items.
Case Study on Usage of Control Flow items.
ADVANCED CONTROL FLOW
Containers – grouping and looping
The Analysis Services tasks
The Execute Process Task
The Execute Package Task
Case Study on Usage of Execute Package Tasks for Zipping and Unzipping Files.
The Data Mining Query Transformation
The Data Mining Model Training Destination
The Slowly Changing Dimension Transformation.
Demo of Adv. Dataflow Items.
EXTENDING SSIS THROUGH CUSTOM CODE
Introduction to SSIS scripting
The SSIS script editor
The SSIS object model
Script in Control flow: The Script Task
Script in Data flow: The Script Component
Introduction to SSIS component development
Case Study on Creation of Master and Child Packages using Execute Package Task.
INTRODUCTION TO DATA FLOW
Data Flow Overview
Data Sources
Data Destinations
Data Transformations overview
Commonly Used Transformations.
Case Study for usage of Transformations and Other Dataflow components.

SQL Prompt is a code completion, code formatting, and refactoring tool for SQL Server. It’ll plug into SQL Server Management Studio or Visual Studio. You’ll find you can work more quickly and accurately with SQL queries, as well as standardize across your team by sharing formatting styles and commonly used SQL snippets. Try it free for 28 days at www.red-gate.com/sqlprompt
In this tip Data Platform MVP Ike Ellis explains how to use SQL Prompt to find invalid objects, so you can catch problems earlier in development and resolve issues quickly.
For more tips for writing SQL effortlessly check out the #SuperSQLTips playlist: https://www.youtube.com/playlist?list=PLhFdCK734P8A_q6XHDXi4CQzys3R0Jw3X
Transcript:
Hi I'm Ike Ellis and I’m going to show you a cool feature of SQL Prompt. One of the issues with T-SQL is that doesn't really tell you when you have dependencies with your objects by default. So if I create a table right here like the customers table and then I create a stored procedure that's dependent on the customers table and then later on at some point I delete the customers table like I drop table customers, there's no warning here telling me that I've got a procedure using that table.
Software development teams have struggled with this for a very long time. Often what they'll do is at one step in the release pipeline they'll drop and recreate all the stored procedures, or all their views or all their functions and then it will warn them to tell them that they have a dependency in the drop and recreation.
But the problem with that is you have to remember to do it - you have to do it manually or automatically - and you actually have to do it at the last step of your release pipeline, well after you've made any schema changes or else you really didn't do anything useful. But one thing you can do with Redgate SQL Prompt is you can right-click on your database and you can say ‘find invalid objects’ and it will warn you, it will say “hey this store procedure is dependent on a table that's no longer here”.
And if you get used to doing this you can do it way earlier in the development process. You can do it every day or at the end of every day or before you check in a source control, and then you can catch your problem before any other developer on your team finds the problem. We know that when a developer finds his own problem or her own problem that it's far cheaper, way easier to resolve, all good things.
So thanks, hope you enjoyed this tip and you find out for yourself by downloading the latest SQL Prompt. Thanks have a great day.

Original high quality video: http://www.dotnetcodecentral.com/Post/129/microsoft-sql-server-quick-learn-how-to/How-to-create-a-view-using-SQL-Server-Management-Studio
All high quality videos on SQL Server (FREE to download): http://www.dotnetcodecentral.com/Technology/microsoft-sql-server-quick-learn-how-to
Demonstrates the following:
Creating a view in database from the scratch using SQL Server Management Studio
Adding a couple of tables to view (join based view)
Selecting columns to be available in view
Testing a view (executing the SELECT which forms the view)
Saving and issuing a SELECT against the view created.

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
By Andrew Gould
https://www.wiseowl.co.uk - Triggers are special stored procedures that you can attach to various events within a database. This video covers DDL, or Data Definition Language triggers, which you can use to handle events associated with changing the objects in a datatbase. This video concentrates on creating triggers to handle the CREATE, ALTER and DROP events and will show you how to scope a trigger to a single database or to an entire server. You'll also see how to disable and enable triggers, as well as how to change the order in which your triggers fire.
You can see a written version of this tutorial at:
https://www.wiseowl.co.uk/blog/s388/sql-triggers.htm
You can download the script to create the Movies database used in this video at the following link:
https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip
You can see the range of resources and courses we offer in SQL Server here:
https://www.wiseowl.co.uk/sql/
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

RPA blueprism complete resume attached here.
SOFTWARE PROFICIENCY:
Languages: ASP.NET, C#.NET,VB.NET
Skills: RPA- ,Blueprism and .Net with Jquery
RDBMS: MS - SQL Server 2008.
Source Control Systems: Team Foundation Server and SVN
Operating Systems: Windows 2003, XP, Windows 7
PROJECTS:
Name of Project: Romania
Client: The Cears
Tools/Environment : RPA, Blue Prism V-5.0, V-4.2, .NET, VBA, HTML, XML, CSS, JavaScript, Bootstrap, SQL Server 2014, Visual Studio 2015, Git, JIRA
Duration: Jan ’15 – To Till Date
Domain: Health Care
Project Description:
This project has been developed by blueprism Tool with 5.2 version .
The main objective to use Blueprism is security for healthcare Domain.Patients details related documents to be safe and secure way spying using Blueprism tool.
We are using WorkQueue concept for this Process for continuous patient details update and hospital records management process .
And for this process we are using LoginAgent for auto login system . So bot can login automatically even when system has idle and locked condition .
And For Email configurations and Email setting we are using BP SMTP configurations and mapiex software.
My Role for this Project:
1. To create Environment variables and Global Timeouts for all the Process .So I Can achieve Timeouts and Variables Globally according the entire process .
2. To Configure the Webservice through Blueprism Expose Webservice object .
3. To Configure the Login Agent /Credential Manager to Entire Process .So I can validate userid/password through System manager .
4. To Tag the patient details and IF patient details are updated /Validated I can mark as completed/Manual intervention/ Exception status .So process analyst can easily identify the status of the current record and whether manual intervention is required for the process bot.
5. We were configured Emails/SMTP/PORT through MAPIEX component of blueprism.
So mail commununication to process owner sent through MAPIEX configs .
6. Bots were Configured through Control room and easily scheduled /Managed through System Manager .All the published process will be covered through our Blueprism System Manager-.
7. Blueprism Bot has been released through the .bprelease file with all the dependency files/Folders.
So deployed version of my bot is .bprelease file for this process .
8.For this process ,We are using Blueprism MSExcel VBO for business related data validations/data process .So I can easily manage objects through Application Modeller components .
9.For Database we are connecting through Connect DBO objects and Sql connectivity tool.So we are easily retrieving patient data through Sql BP DBO.
10. Involved in each phase of Software Development Life Cycle throughout the process like Process studio – Creation and publishing /Object studio and Application Modeller Component selection matrix and bprelease and export and import of the entire process for the scheduling and queueing and montoring through system manager .
11. Interacted with Windows-based application and Mainframe based application like Mainframe emulator and Blurprism connectivity through Application Modeller object configurations .
Name of Project: The Enumers
Client: Yen bank
Tools/Environment : RPA, Blue Prism V-5.0, V-4.2, .NET, VBA, HTML, XML, CSS, JavaScript, Bootstrap, SQL Server 2014, Visual Studio 2015, Git, JIRA
Duration: Jan ’15 – To Till Date
Domain: Banking Domain
Description:
Yen Bank is one of the premier financial service organizations in china.
In this project, I was involved in developing RPA's. In business perspective, using CBA (Cost Benefit Analysis) these are a huge financial save to the Client.
We build these RPA using the tool called Blue Prism. To support the tool, we also use VBA and SQL to regulate the process flow.
Migrating current robots into Blue Prism Objects.
Key Responsibilities:
Created Functional Requirements Documents (FRDs) for a Robotic Process Automation project,
And Involved in all phases of Software Development Life Cycle including design, development and creating test cases.
Solid design, coding, testing and maintaining the RPA's (Robot's).
Identifying and debugging the errors using Error Handlers.
Interacted with window application and created an object and interacted all the objects in process studio and created work queue and ran the process.
Interacted with window based application, called the process into the queues and interacted with mainframe based application.
Created and documented test procedures and scenarios for the pre-UAT phases. And supported operational teams during the UAT and rollout phases.

Some of the examples that we'll be looking at in this course will benefit from having a database available with a lot of tables and data already present. Microsoft provides an example database for exactly these sorts of reasons and it's used in a variety of examples and tutorials and it's also referred to throughout many of the technical documentation resources that you'll find online. The database follows a fictitious company called Wide World Importers and you can download it from the Microsoft GitHub page at this URL. There are several different versions of the database available and you need to match the one that you download to the version of SQL Server that you're using.
For me, I'm on SQL Server 2016 and I know that I already have Service Pack 1 installed. So I'm going to ahead and grab the full backup from the very top of the list here, the WideWorldImporters-Full.bak file. Clicking on the link will start the download process. If you're on an older version of SQL Server or working in Azure, then there are different downloads for you to consider. The Standard and Express edition users will have to scroll down to the very bottom and find the links underneath the legacy section. When the backup database finishes downloading we need to move it into SQL Server's backup folder.
To do that, we'll come in to our Downloads folder and we'll find the backup that we just downloaded. I'll right-click on it and choose Cut. and then we'll go out to the C drive. Inside of there, we'll go to the Program Files folder then inside of Microsoft SQL Server and then we'll need to find the folder that corresponds to the server instance that we're working with. In my case, it's a folder called MSSQL13.SQL_2016. There are a couple of similarly named folders in the same location. We have MSRS13 and there's MSAS13 folder as well.
These stand for analysis services and reporting services and are not the folders that I want to go into. So let's make sure we go into the one labeled MSSQL. Then we'll go into the other MSSQL folder and then finally into the backup folder. At this point, you might see a popup dialogue box saying that you don't have permission to enter this folder. Simply press the OK button and you'll be granted that permission. Then we can right-click and choose Paste to paste in that backup file. Now we just need to install it inside of SQL Server Management Studio. To restore the database from a backup, we'll come over to the Databases folder in the Object Explorer pane, right-click and choose Restore Database.
The source for our restoration is going to be a device, so I'll choose this radio button here and then press the ellipses button on the far right in order to choose a backup device. The backup media will be coming from a file not a URL, and then we'll press Add to add in the new backup media. That should drop us right back into the backup folder that we were just at. I'll choose the WidwWorldImporters-Full.bak file and press OK. That gets added into the backup media list here. I'll press OK again. And then OK one more time. Then I'll go ahead and start the restore process.
When it's done, you'll see this message that the database restore was successful. Go ahead and press OK and then we can go ahead and see the database here inside of the Databases folder and there's the WideWorldImporters database. We'll use this database and some additional temporary databases to explore the concepts in this course.

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
By Andrew Gould
https://www.wiseowl.co.uk - The most annoying part of creating a pivot table in Microsoft SQL Server is listing out the column headings for the table. This video explains how to use dynamic SQL so that you no longer have to repeat this laborious task. The video includes a quick recap of basic pivot tables, how to use the QuoteName function to generate a list of column headings, how to build an SQL statement and store it as a string of text and, finally, how to execute the dynamic SQL string.
You can download the script to create the Movies database used in this video at the following link:
https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip
You can view a written version of this tutorial at:
https://www.wiseowl.co.uk/blog/s417/pivoting-sql-data.htm
You can see the range of resources and courses we offer in SQL Server here:
https://www.wiseowl.co.uk/sql/
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

http://sqlserver2014tutorial.com/
Today we are going to cover Basic SQL queries which will help you understand what is SQL? For today's demo we are going to be using Microsoft SQL server 2014 edition and Northwind database. Really we are interested in the top 10 most commonly used SQL statements in MS SQL 2014 Server.
These are as follows:
-Select query
-Where clause
-Create objects query
-Delete objects query
-Backup database command
-Insert SQL command
-Update SQL syntax
-Delete SQL query
-Join statement including inner and outer joins
-Aggregate queries including MIN, MAX, average and SUM command

You can now download VSQL Premium software for free from Softpaz - https://www.softpaz.com/software/download-vsql-premium-windows-170339.htm from any country as we have no country blocking! Enjoy the best software and games without breaking a sweat!
Directions to download and install can be found at the link! VSQL++ Premium is an all-in-one database management software unrivaled for ensuring the greatest possible productivity in development and administration of Oracle, MySQL, PostgreSQL, Firebird, SQLite databases.VSQL++ Premium provides the most convenient and efficient workflow, simplify database management to improve the efficiency and accuracy of the work. With VSQL++ Premium, you can quickly and easily create, organize, access and analysis Oracle, MySQL, PostgreSQL, Firebird, SQLite databases in easy way. Oracle Objects Management. MySQL Objects Management. PostgreSQL Objects Management. Firebird Objects Management. SQLite Objects Management. Connection Management and Navigation. Data Viewer and Editor. Data Import/Export. SQL Processing. Server Security and Maintenance. Whats new in this version: Fixed a design bug.

Another video brought to you by BeardedDev, bringing you tutorials on Business Intelligence, SQL Programming and Data Analysis.
You can now support me on patreon - https://www.patreon.com/beardeddev
In this video we take a look at a login error when trying to connect to SQL Server Management Studio (SSMS) - No process is on the other end of the pipe. I have seen recommendations on forums that when you see this error SQL Server must be reinstalled but that is a last resort.
No process is on the other end of the pipe is not very descriptive and it means that we are unable to access SQL Server using SQL Server Authentication. In this video we talk about how we can resolve this issue.
We login as sysadmin and look at the properties of the server under the security page, we notice that the server is set up for Windows Authentication even though we have the option of selecting SQL Server Authentication when connecting. We change this setting and restart the services and have resolved the problem.
It is worth mentioning that I believe that the authentication method is set to Windows Authentication when installing SQL Server so be careful if you will be setting up SQL Server users.
Let me know if this resolved the issue.

For more ...http://goo.gl/9z1fg
This video introduces SQL Server Management Studio 2012 (SSMS), which is a very user friendly graphical user interface providing a variety of functions for accessing, configuring, managing, administering and developing all components of SQL Server.
It plays a key role in making your life easy while using SQL Server.
If you remember the installation process, every SQL Server feature that was installed runs as a separate Windows process. If you open the Task Manager and go to the Processes tab (Details tab in Windows 8), among the other processes you can see sqlserver.exe, which is nothing but SQL Server service. It runs in its own process space and is isolated from other processes on the machine. Since SQL Server runs as a service, it has no interface and this is where SSMS comes into picture. SSMS acts as the GUI through which users can interact with SQL Server to pass commands and functions from a user through to the SQL Server service, which then passes them through to the underlying database.
A single instance of SSMS can be used to develop and work with multiple instances of SQL Server which can be on the same or on many systems connected through LAN, WAN or even the Internet.

Coding With Python :: Learn API Basics to Grab Data with Python
This is a basic introduction to using APIs. APIs are the "glue" that keep a lot of web applications running and thriving. Without APIs much of the internet services you love might not even exist!
APIs are easy way to connect with other websites & web services to use their data to make your site or application even better. This simple tutorial gives you the basics of how you can access this data and use it. If you want to know if a website has an api, just search "Facebook API" or "Twitter API" or "Foursquare API" on google. Some APIs are easy to use (like Locu's API which we use in this video) some are more complicated (Facebook's API is more complicated than Locu's). More about APIs: http://en.wikipedia.org/wiki/Api
Code from the video: http://pastebin.com/tFeFvbXp
If you want to learn more about using APIs with Django, learn at http://CodingForEntrepreneurs.com for just $25/month. We apply what we learn here into a Django web application in the GeoLocator project.
The Try Django Tutorial Series is designed to help you get used to using Django in building a basic landing page (also known as splash page or MVP landing page) so you can collect data from potential users. Collecting this data will prove as verification (or validation) that your project is worth building. Furthermore, we also show you how to implement a Paypal Button so you can also accept payments.
Django is awesome and very simple to get started. Step-by-step tutorials are to help you understand the workflow, get you started doing something real, then it is our goal to have you asking questions... "Why did I do X?" or "How would I do Y?" These are questions you wouldn't know to ask otherwise. Questions, after all, lead to answers.
View all my videos: http://bit.ly/1a4Ienh
Get Free Stuff with our Newsletter: http://eepurl.com/NmMcr
The Coding For Entrepreneurs newsletter and get free deals on premium Django tutorial classes, coding for entrepreneurs courses, web hosting, marketing, and more. Oh yeah, it's free:
A few ways to learn:
Coding For Entrepreneurs: https://codingforentrepreneurs.com (includes free projects and free setup guides. All premium content is just $25/mo). Includes implementing Twitter Bootstrap 3, Stripe.com, django south, pip, django registration, virtual environments, deployment, basic jquery, ajax, and much more.
On Udemy:
Bestselling Udemy Coding for Entrepreneurs Course:
https://www.udemy.com/coding-for-entrepreneurs/?couponCode=youtubecfe49 (reg $99, this link $49)
MatchMaker and Geolocator Course:
https://www.udemy.com/coding-for-entrepreneurs-matchmaker-geolocator/?couponCode=youtubecfe39 (advanced course, reg $75, this link: $39)
Marketplace & Dail Deals Course:
https://www.udemy.com/coding-for-entrepreneurs-marketplace-daily-deals/?couponCode=youtubecfe39 (advanced course, reg $75, this link: $39)
Free Udemy Course (40k+ students):
https://www.udemy.com/coding-for-entrepreneurs-basic/
Fun Fact! This Course was Funded on Kickstarter: http://www.kickstarter.com/projects/jmitchel3/coding-for-entrepreneurs

Almost every modern application relies on or interacts with a database in one form or another, making databases a critical component of the modern application development lifecycle. Visual Studio 2013 provides a comprehensive set of tools for development of databases in both SQL Server and Windows Azure SQL Database. See how these database development tools integrate into the application development lifecycle and deployment workflows in Visual Studio 2013, and how they improve your productivity and efficiency when working with databases.