SQL Server Data Quality Services (DQS) is a Knowledge-Driven Data Quality product aimed at the data stewards and IT professionals who seek to improve the quality of their business data. In this session,we describe the concept and main principles behind Data Quality Services from Microsoft,and demo the main capabilities of …
This video discusses the key improvements in SQL Server 2012, most importantly, from a developers perspective. Microsoft also goes over the company’s overall platform strategy.
A trigger is a type of a stored procedure that is executed when a certain event occurs on a database table. This tutorial provides a short introduction on how triggers work in SQL Server.
Schemaless NoSQL database are a joy to use because they make it easy to iterate on your app, especially early on. And to be honest, the relational model isn’t always the best fit for real-world evolving and messy data. On the other hand, relational databases are proven, robust, and powerful. …
This video demonstrates the basics of table creation and inserting data into database tables using the SQL language. You will learn how to create table(s), set primary key(s), add constraints, add foreign keys, insert data and read data from the table.
Learn how to run PostgreSQL in a virtualized environment like vSphere 4.1. This presentation covers what is different when the database is running in a Virtual Machine and its specific challenges.
