An error occurred while writing an audit trace. SQL Server is shutting down
There was this incident at one of the clients in recent past. It was a nice morning. I was enjoying the tea of the day. I just started my...
2019-01-01
13 reads
SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP
Query Store Best Practice and Configuration
In my previous blog post I have talked about What is the Query Store and How to setup the Query Store. In this blog post today, I will explain...
2018-09-25
47 reads
New home for SQL Server Citation
Change is inevitable, it's natural. I would like to quote few lines from Shrimad Bhagavad Gita says Change is the...
2016-11-19
429 reads
A New Beginning #SQLFamily
For the years I have been watching the SQLPASS session recording and hearing that it's really a different experience to...
2016-11-06
475 reads
Resolve Microsoft SQL Server Error Code 824
Since data consistency is a crucial aspect for every user, the server has in-built mechanism which helps to maintain the...
2016-09-01 (first published: 2016-08-23)
3,101 reads
Learn About SQL Server Master Data Services 2016
SQL Server 2016 comes up with the new release of Master Data Services (MDS). In it, some new features have...
2016-07-28 (first published: 2016-07-25)
2,460 reads
Problems When Running DBCC SHRINKFILE On SQL Server Database
Overview of the Situation
While accessing data files in SQL Server, many issues may occur that may lead to frustrating situation...
2016-06-30 (first published: 2016-06-24)
2,274 reads
SQLPASS SUMMIT 2016 Discount Code
SQLPASS SUMMIT 2016 is around, only few months left for this super event. Probably you all would have heard about...
2016-05-14
1,459 reads
How to Recover Data From Corrupted Log File In SQL Server ?
Introduction
SQL Server is a database platform designed for providing large-scale transactions, e-commerce applications, data mining, etc. It is widely used...
2016-04-26
4,632 reads
Configure SQL Server Database Mirroring: Step By Step
Database Mirroring in SQL Server is deployed as a method to increase the availability of a SQL Server database in...
2016-04-05 (first published: 2016-03-25)
97,418 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers