-
09May
Another reason for gaps in IDENTITY
The clever lazy way When creating indexes in SQL Server you can use option IGNORE_DUP_KEY. It seems very handy, for…
-
05Apr
Minimum GRANTs for performing mysqldump
Recent World Backup Day is a good excuse to talk about MySQL database backups. Usually it is a matter of…
0 comments Read more -
07Mar
Executing queries on all Azure databases with PowerShell
Some time ago I found that some test databases were deployed from a dump that contained no indexes. It was…
0 comments Read more -
20May
How to safely drop all tables in a MS SQL database
Some time ago, for testing purposes, I needed a fast and simple way to drop all tables from a database. If possible it…
2 comments Read more -
26Apr
Hey, who changed my IDENTITY?
The first time I saw this effect I was like “someone was playing with my little table!”. Had someone added and…