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,587 reads
Scripts
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,823 reads
2015-10-09 (first published: 2014-03-21)
5,021 reads
2015-10-08 (first published: 2015-07-02)
1,113 reads
2015-10-07 (first published: 2015-09-18)
1,641 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,122 reads
Capture the tasks performed in a text file
Creates a record of all or part of a Windows PowerShell session in a text file.
2015-10-02 (first published: 2015-09-17)
1,146 reads
2015-10-01 (first published: 2015-09-13)
1,940 reads
2015-09-30 (first published: 2015-09-17)
1,793 reads
Get Server version Info
Yet another Script To get Sql server version Info. Run From Central Management server to get all your environment servers
2015-09-29 (first published: 2015-09-10)
1,754 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Alamat BCA KCP Menara Imperium Telp:0821-8200-233
Telp/Wa 62 821-8200-233 Jl. H. R. Rasuna Said No.Kav. 01, RW.6, Guntur, Kecamatan Setiabudi,...
Alamat BCA KCP Sejati Mulia Telp:0821-8200-203
Telp/Wa 62 821-8200-203 Koperasi Sejati Mulia, Jl. Raya Ragunan B 1, RT.3/RW.3, Jati Padang,...
Alamat BCA KCP Graha Inti Fauzi Telp:0821-8200-174
Telp/Wa 62 821-8200-174 Gd. Graha Inti Fauzi, Jl. Buncit Raya No.22 Lt. Dasar, RT.2/RW.7,...
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers