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 Beautifier

Background As a Database Administrator get so see a bit of SQL Statements. Avenues The SQL gets to the DBA through various avenues, inclusive :- Developers Submitted to review and execute against Production Database Monitoring Tools In quite a few cases, the first thing one has to do is space things out a bit. SQL … Continue reading SQL Beautifier

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?

Reporting Services – Chart – Parameter Driving Vertical Axis – Maximum Value

Background As we delved a bit more into Charting in Reporting Services, I thought it best to allow the user to choose which specific column the Y-Axis should be charted on. Guide Code SQL Server Stored Procedure In Transact SQL code, we pass in a variable. In our case, we pass in @columnValue and return … Continue reading Reporting Services – Chart – Parameter Driving Vertical Axis – Maximum Value