Adding File to Database in AlwaysOn Availability Group
When a database is part of AlwaysOn Availability Group, it means whatever commands we are executing on Primary replica database,...
2018-07-27
4,471 reads
When a database is part of AlwaysOn Availability Group, it means whatever commands we are executing on Primary replica database,...
2018-07-27
4,471 reads
The AlwaysOn_health XEvent session is installed by SQL Server by default, and started by the Create Availability Group wizard when...
2018-07-25
2,589 reads
The AlwaysOn Dashboard is an excellent tool in SQL Server Management Studio that allows you to monitor Replica status, Availability...
2018-07-24
588 reads
If you are working on SQL Server Availability Group Databases, you may have seen that Availability Group is online but at-least...
2018-07-23
860 reads
Gladly sharing that I got the news of my MVP award on 1st July. I am happy, honored, and humbled...
2018-07-16
231 reads
SQLCMD mode in SSMS allows you to use the command line tool within SSMS. Using this feature of the SSMS,...
2018-06-07
11,968 reads
As a DBA, implementing a new database consists of a variety of aspects like correct table structure, tuning the stored...
2018-05-28 (first published: 2018-05-21)
7,194 reads
In my previous blog, I discussed about “Which are the queries using a particular index or table?“. Today’s post, I am...
2018-05-13
2,385 reads
The DMV sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats give you excellent detailed information about how the indexes are being used and what operations...
2018-05-07
922 reads
It is very common to see in a relational database that stored procedures are using many Tables, Views, Sequence Object,...
2018-05-01
619 reads
You can find the slides for my session at Future Data Driven summit at...
By Steve Jones
I saw someone limit the databases they see in SSMS, which isn’t something I...
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
Hi all, I have an SQL database table with events, and within it a...
Hi All, I have been trying to download a csv file which is produced...
Hi We have an stored procedure which runs frequently and it contain logic in...