Microsoft SQL links

This David Papkin page has useful links on Microsoft SQL

SQL Collation

SQL Server Utilities Statements – GO

Using GO and Semi-Colon in SQL Server 2012

GO Statement in Sql Server

Join Fundamentals

SQL Joins explained

SQL Joins exercise (w3schools)

Query fundamentals

Set Operators – EXCEPT and INTERSECT

SQL Intersect

SQL Union

SQL – UNIONS CLAUSE

Connect to a MySQL Data Source (SQL Server Import and Export Wizard)

SQL SERVER – Difference Between GRANT and WITH GRANT

Create a Server Role

Auditing

SQL Server – An introduction to the Common Criteria

Common Criteria for Information Technology Security Evaluation (ISO 15408)

ISO/IEC 15408-1:2005 Information technology — Security techniques — Evaluation criteria for IT security — Part 1: Introduction and general model

SQL Server Audit Action Groups and Actions

How to Audit Successful Logins for certain logins only?

Backup

Determine How Much Data Has Changed Since Your Last Full Backup on SQL Server

Tail-Log Backups (SQL Server)

Restore the master Database (Transact-SQL)

Create a Database Snapshot (Transact-SQL)

Encryption

Transparent Data Encryption (TDE)

Dynamic Data Masking

Master DB

Master DB

System Views in SQL

Schema

Importance of Database Schemas in SQL Server

Views

System Views in SQL

sql info

 

 

 

 

 

 

End of David Papkin Microsoft SQL page.

 

http://davidpapkin.org/

David Papkin favorite movies

Robert Deniro in Taxi Driver

Ava Gardner in Singapore (Flim Noir)

Clarke Gable in China Seas