CPU Issues and Speculative Execution

Posted: January 28, 2018 | Author: | Filed under: CPU Issues, Linux kernel, Security, Uncategorized | Tags: , , | Leave a comment

http://smooth1.co.uk/security/CPU_issues.html

Updated Linux kernel patches and added HardenedBSD.

Windows Process Monitor

Posted: January 21, 2018 | Author: | Filed under: Debugging, Uncategorized | Tags: | Leave a comment

Windows Proccess Monitor – https://docs.microsoft.com/en-gb/sysinternals/downloads/procmon

CPU Issues and Speculative Execution

Posted: January 11, 2018 | Author: | Filed under: Uncategorized | Leave a comment

A comprehensive blog post on CPU Issues and Speculative Execution:

http://smooth1.co.uk/security/CPU_issues.html

 

Db2 Version,Release,Modpacks,Fixpacks and Interim Fixes

Posted: December 30, 2017 | Author: | Filed under: DB2, DB2 LUW, Uncategorized | Tags: , | Leave a comment

https://www.ibm.com/developerworks/community/blogs/IMSupport/entry/All_about_ifixes_interim_fixes?lang=en

11.1.2.3 iFix001

11 (Version) seperatedly licensed, major feature changes,starts 5 year maintenance clock,download from Passport Advantage

1 (Release) Minor but significant feature changes,starts 5 year maintenance clock,download from Passport Advantage

2 (Modpack) Can include new functionality,does not start new maintenance clock, download from Fix Central

3 (Fixpack) Cumulative update of all available fixes and APARs,does not start new maintenance clock,download from Fix Central

iFix001 (iFix – Interim Fix) Tested and verified set of small number of key fixes and APARs,cumulative,Downloads found on Fix Central,Supported for the maintenance life of the Version.Release.

Disk Cleanup on Windows Server 2016

Posted: August 11, 2017 | Author: | Filed under: Microsoft Windows, Microsoft Windows Server, Uncategorized | Tags: | Leave a comment

To perform a full disk cleanup on Windows Server 2016

Dism.exe /Online /Cleanup-Image /AnalyzeComponentStore

 

SQL Server Management Studio – SQL Server Diagnostics Extension

Posted: June 26, 2017 | Author: | Filed under: Uncategorized | Leave a comment

The SQL Server engineering (TIGER) team announcement a preview for a SSMS SQL Server Diagnostics extension.

My writeup on this is at http://smooth1.co.uk/sqlserver2017/SSMS_SSD.html

SQL Server on Linux – new command line tools.

Posted: May 28, 2017 | Author: | Filed under: Microsoft SQL Server, Microsoft SQL Server 2017, SQL Server on Linux, Uncategorized | Tags: , | Leave a comment

I have been playing with the new SQL Server on Linux command line tools

http://smooth1.co.uk/sqlserver2017/LINUX_CMD_TOOLS.html

Very nice that sql-scripter has an option to limit output to a given SQL Server Version and even better Edition although did find an issue with this option and will be providing feedback to Microsoft.

 

SQL Server on Linux – SQL Server 2017 goes cross platform!

Posted: May 23, 2017 | Author: | Filed under: Linux, Microsoft SQL Server, SQL Server on Linux, Uncategorized | Tags: , | Leave a comment

Here are the slides for my recent talks on SQL Server on Linux – SQL Server 2017 goes cross platform!

http://smooth1.co.uk/presents/201705_SSOL/201705_SSOL.zip

SQL Server – Changing Recovery Model from Full to Bulk Logged whilst a Tranasction is active.

Posted: May 10, 2017 | Author: | Filed under: Microsoft SQL Server, Microsoft SQL Server 2016, Uncategorized | Tags: , , | Leave a comment

If have a SQL Server database and change the Recovery Model from Full to Bulk Logged whilst a transaction is open what happens?

If the ongoing transaction which was started under Recovery Model Full does an operation which can be minimally logged what happens?

Does the operation become minimally logged which then means the VLF is tagged as a minimally logged logfile which then does not allow certain operations e.g. restores from the next log backup with STOPAT.

We test with STOPAT and also use fn_dump_dblog to see exactly what ends up in the log backup and how we can identify minimally logged operations in a log backup file.

http://smooth1.co.uk/sqlserver2016/RM_BL_ML.html

SQL Server 2016 – Database Scoped Configuration Parameters and Always On Availability Group failovers.

Posted: May 10, 2017 | Author: | Filed under: Microsoft SQL Server, Microsoft SQL Server 2016, Uncategorized | Tags: , , | Leave a comment

In SQL Server 2016 we have database scoped parameters.

With an AlwaysOn Availability Groups we can have different database scoped parameter values on the primary compare to the secondaries.

How does this work with an Always On Availability Group failover ?

http://smooth1.co.uk/sqlserver2016/AA_AG_DSP.html

← Older Entries