Arnaud Degraeve – Teradata / SQL Server / Google BigQuery
Database Administration – Development – Optimization
Menu
Skip to content
Home
Welcome
Resume
Book
Downloads
Contact
Articles
Back to the basics
Keys and constraints
Working with surrogate Keys
Backups
POC about crossed backups
Development
Working with Table type
Install
SQL Server 2008R2 Stand Alone Installation / Silent Mode
SQL Server 2008R2 Service packs Stand Alone Installation / Silent Mode
Merge Replication
Dealing with deadlocks in Merge Replication
Scripts
Operation
Reducing a Log file on a Published Database
Adding a Log file
Instance databases backup
Adding a fulltext index
Set the max server memory
Orphan users
Development
Getting the last insert
Resetting identity columns
Tips
Getting the number of cores
Backup space estimate
TroubleShooting
System
Services timeout
Services do not start
Replication
Login failed for user(‘null’)
Deleting a previously published database
Distribution clean up: distribution failed
Drop Distribution database
Downloads
You can click here to download my
Resume
in PDF format