(Jeffrey Yao) I sometimes get requests to copy a database from one server to another without any data. I just need an empty database with just the schema information and no data, how can I do it?

(Nakul Vachhrajani) We got a new server recently and one of my colleagues ran into an error when restoring a database. The error was a quite generic (reformatted below for readability):

(Thomas LaRock) I’ve talked before about examining the contents of a DACPAC using the built in ‘Unpack…’ command as shown here:

(Pinal Dave) My learning is always fun. I strongly believe that unless you break something, you can’t learn how to fix them. While writing a new blog about auditing, I faced an interesting error. So, I thought of writing my findings before I write the actual blog. Let us learn about Audit failed to

(Derik Hammer) The differences between TRUNCATE TABLE and DELETE are often misunderstood. I seek to disprove the myth that TRUNCATE TABLE cannot be rolled back:

(Kenneth Fisher) Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. No luck.

(Marcin Policht) In the past we’ve discussed the automated backup capabilities of SQL Server instances deployed to Azure virtual machines. These capabilities rely on either a dedicated Azure VM Agent extension or on system stored procedures introduced in SQL Server 2014, in order to transfer backup

(Jack Vamvas) Question: I have two tables and would like to return a recordset which is made up of table1 plus an extra column which is made up of a comma-delimited string from table2 based on an INNER JOIN.

(Robert Sheldon) Of course we all like our colleagues to think that we know everything there is to know about SQL Server Collations. However, the truth is that it is a rather complicated topic to fully understand and the cost of getting collation wrong can be great. If only one could ask certain que

(Yochanan Rachamim) When using blob auditing on Azure SQL Server or Database, after you export database to .bacpac file