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
9 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
17 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
427 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
473 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,042 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,446 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,269 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,457 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,621 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)
96,933 reads
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
SQL Server 2005 service fails to start
Hello, I’ve been trying to install Ms SQL Server 2005 for over two weeks...
How to Repair Corrupt MySQL Tables
Comments posted to this topic are about the item How to Repair Corrupt MySQL...
The Funny Dynamic SQL
Comments posted to this topic are about the item The Funny Dynamic SQL
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers