Fun-time Friday - Data outages, Security Breaches and Brexit
It’s been an interesting week here at gethynellis.com. We have been busy with a SQL Server version upgrade for a...
2018-12-28 (first published: 2018-12-07)
1,956 reads
Blog Posts
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
462 reads
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,703 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
20 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,011 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
17 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,336 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
533 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,501 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Alamat Kantor BCA KCP Talavera Telp/Wa:0821-8200-233
CSO 08218200233 Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar., Kec....
Alamat BCA KCP Mega Kuningan Telp/Wa:0821-8200-203
CSO 08218200203 Lingkar Mega Kuningan No.Blok E 4, RT.5/RW.2, Kuningan, Kuningan Tim., Kecamatan Setiabudi,...
Alamat BCA KCP Wisma Mulia Telp/Wa:0821-8200-174
CSO 08218200174 Jl. Gatot Subroto No.42 Suite G02, RT.3/RW.2, Kuningan Bar., Kec. Mampang Prpt.,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers