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
6,064 reads
Dharmendra Keshari
AlwaysOn_health Extended Event Session
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,998 reads
AlwaysOn Dashboard uses System Policies
The AlwaysOn Dashboard is an excellent tool in SQL Server Management Studio that allows you to monitor Replica status, Availability...
2018-07-24
663 reads
Why Availability Databases Are Not Synchronizing?
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
927 reads
Another MVP Award – 2018-2019
Gladly sharing that I got the news of my MVP award on 1st July. I am happy, honored, and humbled...
2018-07-16
239 reads
Enable SQLCMD Mode in SQL Server Management Studio
SQLCMD mode in SSMS allows you to use the command line tool within SSMS. Using this feature of the SSMS,...
2018-06-07
15,982 reads
SQL Server Stress Testing Using OStress – RML Utilities
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,239 reads
Find Query with Implicit Conversion in the Plan Cache
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
3,042 reads
Which are the queries using a particular index or table?
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
1,076 reads
Determine Referenced Objects in the Stored Procedures
It is very common to see in a relational database that stored procedures are using many Tables, Views, Sequence Object,...
2018-05-01
1,717 reads
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers