(Kenneth Fisher) The development team has told me they’ve shut down the application, there are no more connections and I can go ahead and set the database to SINGLE_USER, or maybe RESTRICTED_USER before running various processes on it. I check and low and behold, no connections.

(Pinal Dave) Restoring the database with Just Log File is not possible. If you are looking for the answer to this question, you have bad news.

(Bill Graziano) At one of my clients, I’ve seen the benefits of using tools like Puppet to push configurations to servers. I’ve long tried to write idempotent configuration scripts for my servers.

(Michael J. Swart) I was looking at the docs for DROP TABLE and I noticed this in the syntax: [ ,…n ]. I never realized that you can drop more than one table in a statement.

(Haroon Ashraf) As a Data Warehouse or SQL BI (Business Intelligence) developer how I can make sure that my SQL Server Integration Services (SSIS) packages use Azure UTC time to log events rather than my local system time? My packages are built locally, but run against an Azure SQL Database.

(Andrey Podkolzin) This is going to be the final article in the series of articles on the life of IDE developers for databases.

(Pinal Dave) Yesterday, I wrote a blog post SQL SERVER – Statistics Modification Counter – sys.dm_db_stats_properties where I discussed how many rows have been modified based on sys.dm_db_stats_properties. I received lots of follow up questions and comments on the blog.

(Koen Verbeeck) I’m developing SQL Server Integrations Services (SSIS) packages in Visual Studio. These packages are deployed into Azure using the Azure-SSIS Integration Runtime in Azure Data Factory (ADF). Sometimes packages fail when running in Azure while they run successfully in Visual Studio.

(Pinal Dave) When you work with the SQL Server Performance tuning area, every single day there are new learnings and discoveries. Recently while I was working at my client’s place on Comprehensive Database Performance Health Check, they asked me if I know a way to know which table has been most upda

(Grant Fritchey) I’m expanding my skill set into AWS in a big way. So, one of the things I do when I’m learning a technology is to write blog posts about that tech.