Resources
The page is dedicated to presentations, scripts, and other resources that are available for download.
Presentations:

SQL Server Audit - Evidence Never Lies - PowerPoint slide deck

SQL Saturday #692 - Atlanta, GA - Jul 15, 2017
SQL Saturday #610 - Richmond, VA - Mar 18, 2017
SQL Saturday #592 - Raleigh, NC - Mar 11, 2017
Policy Based Management - Beyond the Basics Read More →

Free SQL Server video tutorial

Connecting to SQL Server
Working with databases
Creating and working with tables
Default Constraint
Cascading referential integrity
Check Constraint
Identity Column
Retrieving identity column value
Unique key constraint
All about select statement
Group By
Basic Joins
Advanced Joins
Self join
Different ways to replace NULL
Coalesce function
Union and Union All
Stored Procedures
Stored Procedures with output parameters
Difference between output Read More →

Cardinality
Minimum No. of tables

1:1 cardinality with partial participation of both entities
2

1:1 cardinality with total participation of atleast 1 entity
1

1:n cardinality
2

m:n cardinality
3

 
Note: This is a general observation. Special cases need to be taken care. We may need extra table if attribute of a relationship can’t be moved to any entity side.
 
Keys of a relation: There are Read More →

What are advantages of DBMS over traditional file based systems?
Ans: Database management systems were developed to handle the following dif?culties of typical ?le-processing systems supported by conventional operating systems.
1. Data redundancy and inconsistency
2. Dif?culty in accessing data
3. Data isolation – multiple ?les and formats
4. Integrity problems
5. Atomicity of updates
6. Concurrent access by multiple users
7. Security Read More →

Beginning back with SQL Server® 2005, Microsoft® integrated the .NET runtime into the database engine. This runtime engine is called the SQL Server Common Language Runtime (CLR), and is commonly referred to as SQLCLR. SQL Server CLR enables you to extend the capabilities of the SQL Server database engine with the rich programming environment of Read More →

http://www.sqldts.com/272.aspx

These are custom tasks and tools.

Transfer Packages Sample Application 3 Sep 2002
SQLDTS.com Article: Transferring DTS Packages

41795 Hits

DTS ActiveX Helper 26 Apr 2005
A simple COM component which wraps the GetExecutionErrorInfo method using variant types for returning data, compatible with ActiveX Script Tasks. Full source code included (VB6).

11196 Hits

SQLDTS FTP Read More →

Use this Stored Procedur for create script from all job in one database :
And for all DataBase in SQL Server use this Stored Procedure
Maintain files of sql for each table then use cygwin to run a shell script that cats them together then run it on the server.
Code source of this article : https://stackoverflow.com/questions/3361163/automatically-create-scripts-for-all-sql-server-jobs

Cet article décrit les éléments suivants concernant cette version du correctif :

Les problèmes qui sont résolus par le package de correctifs
Les conditions préalables à l’installation du package de correctifs
Si vous devez redémarrer l’ordinateur après avoir installé le package de correctifs
Si le package de correctifs est remplacé par un autre package de correctif logiciel
Si vous devez modifier Read More →

 

Table of Contents

Introduction

Background
Prerequisites
Recommendations
Disclaimer

FAQs

Help! I’m lost!
But I don’t want to use the Brian Keller VM!
I already have MS RM set-up. What’s the minimal work I need to do to add a DB to my system?

System Overview
Exercise 1 – Source Controlling your Database

Linking a Database to source-control

Exercise 2 – Getting your Database into the Continuous Integration Process

Part Read More →

Simple Way To Use Pivot In SQL Query
This post intends to help T-SQL developers get started with PIVOT queries. Most business applications will need some sort of PIVOT queries and I am sure many of you must have come across pivoting requirements several times in the past.
Let us have a table name Invoice which has Read More →