|
|
SQL Server 2008 Data Capture
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 provide
Tags : Data Capture SQL Server 2008 Magenic database
Visto : 994
video subido por Vendoran .
|
|
|
|
Did you know? SQL Server 2008 includes Cache
SQL Server 2008 includes Cache Transform
The Cache Transform transformation writes data from a connected data source in the data flow to a Cache connection manager The cache can be populated from text files, XML files, Excel files, etc; you are not limited to only populating the cache from an OLE
Tags : SQL DYN Screencast SSIS Magenic
Visto : 2315
video subido por denglishbi .
|
|
|
|
Did you know? SQL Server 2008 includes GROUPI
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
Tags : SQL DYN TSQL Screencast Magenic
Visto : 888
video subido por denglishbi .
|
|
|
|
SQL Server 2008 Resource Governor
Resource Governor enables you to manage SQL Server workload and resources by specifying limits on resource consumption by incoming requests
In an environment where multiple distinct workloads are present on the same server, Resource Governor enables you to differentiate these workloads and allocate
Tags : SQL Server 2008 Resource Governor Magenic
Visto : 1568
video subido por Vendoran .
|
|
|
|
SQL Server 2008 MERGE
Common data scenarios require developers to write and maintain logic to determine whether to insert, update or delete information (sometimes called upsert) such as
IF FOUND
THEN UPDATE
ELSE
INSERT
SQL Server 2008 provides the new MERGE statement within the SQL language to enable developers to
Tags : database databases merge sql server 2008 tsql tsql magenic
Visto : 700
video subido por Vendoran .
|
|
|
|
Did you know? SQL Server 2008 includes Intell
SQL Server 2008 includes T-SQL IntelliSense
Transact-SQL IntelliSense provides intelligent aids for Transact SQL scripting that make language references easily accessible for database developers When coding, you do not need to leave the Database Query Editor to perform searches on T-SQL language el
Tags : SQL DYN Screencast Magenic
Visto : 770
video subido por denglishbi .
|
|
|
|
Did you know? SQL Server 2008 includes Backup
SQL Server 2008 includes database backup compression
Keeping disk-based backups online is expensive and time-consuming With SQL Server 2008 backup compression, less storage is required to keep backups online, and backups run significantly faster since less disk I/O is required
By default, backup c
Tags : Magenic DYN SQL Screencast
Visto : 356
video subido por denglishbi .
|
|
|
|
Hacking SQL Server
In this presentation at the Jacksonville SQL Server Users Group, Bayer White playS the part of a developer protecting his application and Brian Knight attempts to hack his application using SQL Injection and cross-site scripting Then, Bayer will show you how to protect yourself from the hacker and t
Tags : injection hacking css sql server crosssite scripting xss
Visto : 41843
video subido por dbaguyjax .
|
|
|
|
|
