How to Cluster MaxDB on Windows in the Cloud #Azure #AWS #GCP #SAP
Recently I have had a number of customers looking for a high availability solution for MaxDB on Windows in the...
2018-12-28
454 reads
Blog Posts
Journaling
Most of the work I’ve done for the past couple years doesn’t require taking much in the way of notes....
2018-12-28 (first published: 2018-12-04)
2,699 reads
Shrinking Tempdb in SQL Server won’t work?
Problem statement When I was working DML operation on the database, It is noted that the tempdb has grown significantly...
2018-12-28
1,008 reads
Shrinking Tempdb in SQL Server won’t work?
Problem statement When I was working DML operation on the database, It is noted that the tempdb has grown significantly larger and I didn’t have much space on the...
2018-12-28
16 reads
SQL Servers Black Box Recorder – Def Trace
Very much like what you may find with the airline industry, the black box recorder in SQL Server is not just a single method (device) implemented to capture all of...
2018-12-28
12 reads
SQL Servers Black Box Recorder – Def Trace
Across many professions and industries there is often a need to have some sort of device that “audits” everything that...
2018-12-28
274 reads
Webcast: Data Modeling Scenarios and Best Practices
On January 17, 2019, I will be giving a webcast with MSSQLTips on data modeling best practices. It’s scheduled for...
2018-12-28
1,320 reads
Automation to list all TCP static and dynamic ports of SQL Server instances using PowerShell
I was asked by the reader on how to get all the port information of SQL Servers instances. As you...
2018-12-27
530 reads
Basic Sequences–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-12-27 (first published: 2018-12-05)
2,498 reads
How to: File Target use in Extended Events
Using a file target is not difficult from a creation point of view (event session creation). But, some basics are critical or you could end up with fewer follicles.
Related...
2018-12-27
14 reads
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
Alamat Kantor BCA KCP Dakota Telp:0817866887
WA:0817-866-887 Jl. Dakota No.Raya 42, H dan 46, Sukaraja, Kec. Cicendo, Kota Bandung, Jawa...
ALAMAT BCA KCU DAAN MOGOT WA {08218154393}
WA:08218154393 Jl. Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...
ALAMAT BCA KCU SURYOPRANOTO WA,?{08218154393}
WA:08218154393 Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus...
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers