(Pinal Dave) Learning never stops for a consultant. In this blog, I would share another learning and discuss message: cannot shrink log file because the logical log file located at the end of the file is in use.
Tag: sql server
Cloning Databases with PSDatabaseClone
(Sander Stad) PSDatabaseClone is a PowerShell module that has the ability to create images of databases (“clones”) and distribute those clones to one or more hosts.
Lesson Learned #59: I would like to upload my own certificate to connect to Azure SQL Database.
(Jose M Jurado) Today, I worked on a service request that our customer asked about to use their own certificate to connect to Azure SQL Database.
Monitoring Disk Space on Linux – Helpful Commands for SQL Server DBAs
(Rajendra Gupta) In this article, we will explore the different Linux commands related to the disk space.
DevOps and Automation Will Eliminate the DBA
(Grant Fritchey) I’ve been reading about the death of the DBA ever since I first made the jump from full time developer to full time data professional.
File Maintenance – Cleaning Up Old Files
(Jason Brimhall) We have all run into a need or a desire to clean up old stale files from the file system, whether it be to remove old backup files or flat files that are created from one process or another.
SQL SERVER – T-SQL Script to Check SQL Server Job History
(Pinal Dave) Yesterday my long time customer from New Zealand asked me during our regular weekly meet of Comprehensive Database Performance Health Check if I know a T-SQL Script to Check SQL Server Job History.
SQL SERVER – How to Write Correlated Subquery?
(Pinal Dave) This is a follow-up blog post to my earlier blog post written about SQL SERVER – Writing Your First Subquery From a Single Table.
Controlling the firewall for an Azure SQL DB via T-SQL
(Kenneth Fisher) The other day I took a Microsoft Learn course about securing Azure SQL DB. It was really enjoyable and I learned quite a bit, but one of the things that really stood out was the fact that you can control the firewall via T-SQL.
Difference between ORIGINAL_LOGIN() and CURRENT_USER
(Jack Vamvas) ORIGINAL_LOGIN() and CURRENT_USER are useful functions in SQL Server , used to report on identities within SQL Server sessions.
