AlwaysOn Data Synchronization in Synchronous and Asynchronous Mode
When you are working on the AlwaysOn feature, it is crucial to understand how the AlwaysOn commit process works. This...
2018-08-15
5,677 reads
SQL Geek
Fastest Way to Find Row Count of All Tables From All Databases in SQL Server
There are many times you as DBA or Developer needs to get all row count from all tables or row...
2018-08-13
8,146 reads
Snapshot Agent Acquires schema modification (SCH-M) lock on all the articles of a publication
As the business requirement, It is very common to see a request for adding a new article or subscription to...
2018-08-22 (first published: 2018-08-06)
2,009 reads
SQL Server Enterprise Edition-Core VS Server+CAL – Demo on differences
In this blog, I am NOT going to discuss the SQL Server licensing model. If you are looking for that...
2018-08-03
2,462 reads
How to Change SQL Server License or Product Key?
Yesterday, I was doing SQL Server Database stress and benchmarking testing on the client side. When I started ramping-up more...
2018-08-02
133,668 reads
Have you ever wonder why Log Send Rate doesn’t show against Primary Replica on the AlwaysOn Dashboard?
Recently, I was working on the AlwaysOn Availability group issue where the log records were not moving from primary to...
2018-08-01
457 reads
Failed to join local availability replica to Availability Group – SQL Server error 41106 and 41158
When you configure SQL Server AlwaysOn Availability Group from management studio, it may fail with below error while joining secondary...
2018-07-31
15,770 reads
Disable or Turn-off SQL Server Telemetry Service
With SQL Server 2016, Microsoft is installing SQL Server Telemetry or CEIP (Customer Experience Improvement Program) Services by default. It...
2018-08-13 (first published: 2018-07-30)
65,171 reads
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
5,978 reads
Save the Connection String Parameters in SSMS – AlwaysOn
In the SQL Server AlwaysOn setup, whenever you are using a listener to connect to a secondary node, you have...
2018-08-10 (first published: 2018-07-26)
2,567 reads
Blogs
A Quick Look at Redgate Data Modeler
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
Prepping for Certification, Part 2 of ?
By Brian Kelley
The advantage of understanding the make-up of the exam: I can tailor my efforts...
PASS Data Summit 2025 Recap
By Tim Mitchell
Last week, I attended the annual PASS Data Summit in Seattle. This was the...
Forums
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Is Data Modeling Common?
Comments posted to this topic are about the item Is Data Modeling Common?
Getting The Database Name
Comments posted to this topic are about the item Getting The Database Name
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers