What's changed recently?
Often when tracking down problems, you need to know if anything has changed recently, this script will tell you...
2015-10-20 (first published: 2013-05-30)
3,916 reads
Scripts
2015-10-19 (first published: 2013-08-30)
4,386 reads
2015-10-16 (first published: 2013-05-30)
5,737 reads
Figure out the Blocking issue
This script will help you to get the culprit along with IP address and User name which helps us to determine the Blocking root cause.
2015-10-14 (first published: 2013-12-08)
4,413 reads
List all tables and their respective information.
List all tables in a SQL Server database with the details of them.
2015-10-13 (first published: 2013-02-20)
4,580 reads
Get IP Addresses of all Hostnames using SQL Server
To get the IP addresses of Multiple hostnames from below stored procedure.
2015-10-12 (first published: 2013-04-17)
5,812 reads
2015-10-09 (first published: 2014-03-21)
5,004 reads
2015-10-08 (first published: 2015-07-02)
1,107 reads
2015-10-07 (first published: 2015-09-18)
1,635 reads
Migrate existing DB Mail Exchange Configuration with New
Sometime due to the heavy load in Exchange servers we received configuration alerts notifications and report delay and that time it is require to move to some other exchange servers to full fill the requirement during the critical periods.
2015-10-06 (first published: 2014-12-19)
1,115 reads
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
BCA KCU PANAKKUKANG Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Boulevard No.5 Blok F5, Masale, Kec. Panakkukang, Kota Makassar, Sulawesi...
BCA KCU MAKASSAR Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Ahmad Yani No.31, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan...
BCA KCU AMBON Telp/WA:0817844112
phone/Wa, Cs. 0817844112 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers