Video duration: 594 seconds
Global video hits: 39682
http://idealprogramm er.com presents SQL Server 2005 Video Tutorial Series. In this first 10-minute video, you will learn how to install SQL Server 2005 Express and the SQL Server Management Studio.
Video duration: 110 seconds
Global video hits: 60730
Hacking demonstration using SQL injection
get the original file here:
http://rapidshare .com/files/16310360/ inj.avi
This hack makes on the news:
http://www.radioi owa.com/gestalt/go.c fm?objectid=C62EC2FD -D6CA-6148-ECA10EFC2 15AB72D
Video duration: 634 seconds
Global video hits: 679
SQL Server 2008 includes GROUPING SETS:
Grouping Sets is an extension to the GROUP BY clause that lets users define multiple groupings in the same query. Grouping Sets produces a single result set that is equivalent to a UNION ALL of differently grouped rows, making aggregation querying and reporting easier and faster.
Video duration: 485 seconds
Global video hits: 573
The Data Collector is a system that can collect data from any TSQL query like DMVs, Windows Performance Counters, and the SQL Trace. It bundles any selection of these items into a Collection Set. This data is then stored in a relational database known as the management data warehouse. Microsoft provides three bundled collectors, however you can create custom data collectors via T-SQL and API.