Extended Events is a powerful feature that was introduced into SQL Server 2008 and onwards. It keeps historical system health...
2017-10-12 (first published: 2017-10-07)
12,699 reads
Since Microsoft has launched SQL Server on Linux, you would be working on both the platforms Linux and Windows. You...
2017-07-21
16,835 reads
In my previous two blogs – Capture Important Parameters of the SQL Server Replication and Add new articles to existing Transactional Replication...
2017-07-31 (first published: 2017-07-18)
2,786 reads
I always love to get my hands dirty with new features of SQL Server. I was exploring SQL Server on...
2017-07-27 (first published: 2017-07-14)
2,163 reads
Suppose, you have Transactional Replication configured in your production environment. There is a business requirement to add a new article to the...
2017-07-20 (first published: 2017-07-10)
11,937 reads
Whenever there is a business requirement to add a new article to an existing publication, you want to know how...
2017-07-13 (first published: 2017-07-03)
1,627 reads
Since the DMF sys.dm_io_virtual_file_stats shows cumulative I/O statistics value for the database files, you can’t just use the DMF to...
2017-06-29
1,143 reads
One of the real-world I/O troubleshooting problems is – If you have your databases spread across multiple LUNs and you want...
2017-07-03 (first published: 2017-06-26)
4,208 reads
In last three years, I presented two times on the topic Transaction Log File Architecture. During the sessions, when I discussed...
2017-06-28 (first published: 2017-06-20)
1,550 reads
With the release of SQL Server vNext CTP 1.4, the SQL Server Agent support is included. It enables DBAs to...
2017-06-16
3,025 reads
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
By Steve Jones
Redgate Monitor has grown tremendously from its early days and I find many customers...
The post Data Governance: The Invisible AI Accelerator appeared first on Joyful Craftsmen.
SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849 Our Extended Stored Procedure...
We have a publication with three subscribers; it's basically a part list with around...
Hi Experts, I have database about 300GB in size with ADR enabled but after...
What types of database operations does the Data API Builder support?
See possible answers