2019-07-18
614 reads
Administration
The Dangers When Changing Database File Names
Recently a friend had an issue with their SQL Server as a result of a file change in their SQL Server database. In this short piece, I want to highlight the dangers of making some changes to an online database that might cause an unexpected outage. This is really the same whether you are changing […]
2019-07-09
3,404 reads
2019-07-05
783 reads
2019-07-01
763 reads
2019-06-28
817 reads
Find Estimate Time of recovery for database after Reboot
This Script will read the Estimated Time for recovery from Error Log
2019-07-08 (first published: 2019-06-26)
463 reads
2019-06-24
720 reads
2019-06-10
931 reads
2019-06-06
1,030 reads
SQL SERVER – FIX: Msg 4353 – Conflicting File Relocations Have Been Specified for File. Only a Single WITH MOVE Clause Should be Specified for Any Logical File Name
In this blog we would learn how to fix Msg 4353 - ...
2019-05-24
Blogs
Transaction log Information gathering
By Vinay Thakur
Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...
What's New in SQL 2019? at BRSSUG
By Will Assaf
Thanks to everyone who joined the BRSSUG for a night all about SQL Server...
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 3
By Gerard
This is the third post in a series about modern Data Lake Architecture where...
Forums
Azure file copy creating a directory to hold the renamed file
Hi All, I'm pretty new to azure and am hitting the following problem. I've...
MSAccess to SQLServer Query Conversion
Hi, Our client have MS-Access database which has more queries written in MS-Access 2010...
Log file growth
Index maintenance and loading data conflict with each other cause the log file to...
Ask SSC