UDP Flood Attack

Background My Internet connection has been spotty for a while here. TroubleShooting Finally, took the time this evening to see what is going on. Outline Router Check the Router Wireless Access Point Check the Wireless Access Points Computer & Hosts Check the computers and hosts connected to your Router & Hosts Internet Service Provider Check … Continue reading UDP Flood Attack

SQL Server – 2019 – Developer Edition – Installation Media

Background Microsoft SQL Server Developer Edition is free for non-production use.   Explore Let us touch on where to get our hands on the install media/ISO. Media Microsoft SQL Server Downloads URL Link Microsoft | Visual Studio Subscriptions URL Link   Review Media Availability Microsoft | Visual Studio Subscriptions Outline Go to Visual Studio Subscriptions … Continue reading SQL Server – 2019 – Developer Edition – Installation Media

SoSci Survey GmbH – View Chars

Background Need to view non-printable Unicode characters. Tools Outline Here are some tools for viewing non-printable Unicode characters :- SoSci Survey GmbH • Munich • Germany View Chars Link Usage SoSci Survey GmbH • Munich • Germany Entered the text pasted below :- Received back :- From the original text, it does not appear that … Continue reading SoSci Survey GmbH – View Chars

“Entity Relationship” meets poetry

Background Researching an issue and wanted to see the best choice for a name.  Googled on it and found good reasoning. Question The Question is :- Image Text Table: Color Columns: Id, ColorName, ColorCode Table: Shape Columns: Id, ShapeName, VertexList What should I call the table that maps color to shape? Table: ??? Columns: ColorId, … Continue reading “Entity Relationship” meets poetry

Dr. Thomas Oden, A theologian who made no new contribution to theology

Who is Thomas Clark Oden? Wikipedia Link Thomas Clark Oden was an American United Methodist theologian and religious author. He is often regarded as the father of the paleo-orthodox theological movement and is considered to be one of the most influential theologians of the 20th century and the beginning of the 21st century. Quotes & … Continue reading Dr. Thomas Oden, A theologian who made no new contribution to theology

Dbeaver / Date Format

Background Quick follow-up to our last post on String Representation of datetime. Referenced Post BTW, that post is here: Db/2 – LUW – SQL Error [22007]: “The string representation of a datetime value is out of range” Link Goal In this post we will discuss options for displaying date columns in "locale" sensitive ways. Implementation … Continue reading Dbeaver / Date Format

Transact SQL – Error – “Arithmetic overflow error converting numeric to data type numeric”

Background Revising a SQL Code snippet for finding Bookmark Lookups and ran into an error stating: Msg 8115, Level 16, State 1 Arithmetic overflow error converting numeric to data type numeric Code Original Code Here is the original code ...   Error Message Remediation To remediate please try one of the options stated below: Set … Continue reading Transact SQL – Error – “Arithmetic overflow error converting numeric to data type numeric”

SQL Server – Storage – IO Pattern – Seeks versus Scans

Background One of the areas that needs to be considered when preparing IOPs requirements, is the mix of Seeks versus Scans. Let us see how we compare amount of seeks versus scans on an existing system.   Referenced Blogs Here are the blogs that pre-meditated this post. SQL Server – Storage – IO Pattern – … Continue reading SQL Server – Storage – IO Pattern – Seeks versus Scans

Sql Server Reporting Services – Does Date Cover Entire Day?

  Background One of our users pleasantly gave me a list of things she will like to change in our Reports. The list includes whether we can assume entire day, when she presents us with a day. Report Designer Here is our Report's parameter panel:   Quick Explanation: So for Date Start, she wants to … Continue reading Sql Server Reporting Services – Does Date Cover Entire Day?