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
29 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
60 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
439 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
478 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,115 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,467 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,280 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,463 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,645 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,557 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers