SSWUG.ORG https://sswug.org/ SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help Wed, 01 Dec 2021 20:39:18 +0000 en-US hourly 1 https://wordpress.org/?v=6.9.4 Debugging Multi-Cloud Performance https://sswug.org/siteadmin/editorials/debugging-multi-cloud-performance/ Wed, 01 Dec 2021 20:39:16 +0000 https://sswug.org/?p=276149 We’ve been chasing issues with performance across a series of applications where there are multiple cloud providers (specifically AWS and Azure) in play. The application is a fairly typical .net web-based application that does calls to Azure SQL DB and AWS RDS at various times and places. The issue we’ll see from time to time surrounds lag time between the […]

The post Debugging Multi-Cloud Performance appeared first on SSWUG.ORG.

]]> Mixing Flavors of SQL Server https://sswug.org/swynk/editorials/mixing-flavors-of-sql-server/ https://sswug.org/swynk/editorials/mixing-flavors-of-sql-server/#respond Mon, 22 Nov 2021 18:09:38 +0000 https://sswug.org/?p=276145 It’s been an interesting ride, optimizing SQL Server, figuring out best use cases for the different flavors of SQL Server that we have come to rely on, and we’re seeing those choices pay off in terms of management, performance, and cost savings. The “flavors” I’m speaking of? AWS RDS SQL Server, Azure SQL DB specifically. Our event platform is based […]

The post Mixing Flavors of SQL Server appeared first on SSWUG.ORG.

]]> https://sswug.org/swynk/editorials/mixing-flavors-of-sql-server/feed/ 0 July Spotlight – Db2 LUW: Types of I/O https://sswug.org/sswugresearch/community/july-spotlight-db2-luw-types-of-i-o/ https://sswug.org/sswugresearch/community/july-spotlight-db2-luw-types-of-i-o/#respond Wed, 12 Aug 2020 07:00:19 +0000 https://sswug.org/?p=276060 (Martin Hubel) Since the beginning of commercial applications, input/output (I/O) has been one of the main determining factors for overall performance. In the world of relational database, I/O can easily surpass all other considerations, particularly if an SQL statement asks for a very large result

The post July Spotlight – Db2 LUW: Types of I/O appeared first on SSWUG.ORG.

]]> https://sswug.org/sswugresearch/community/july-spotlight-db2-luw-types-of-i-o/feed/ 0 Part II: Overview of B- Tree and B+ Tree https://sswug.org/sunnysingh/sql-server/part-ii-overview-of-b-tree-and-b-tree/ Mon, 10 Aug 2020 07:00:00 +0000 https://sswug.org/?p=275496 Introduction to B+ Tree The drawback of the B tree used for indexing is that it stores a data pointer (a pointer to a block of a disk file with a key value) that matches a given key value, along with that key value in the B tree node. This technique significantly reduces the number of entries that can be […]

The post Part II: Overview of B- Tree and B+ Tree appeared first on SSWUG.ORG.

]]> Is it undermining or rude to email the boss to ask him to get his act together? https://sswug.org/laurarose/sql-server/is-it-undermining-or-rude-to-email-the-boss-to-ask-him-to-get-his-act-together/ Fri, 07 Aug 2020 07:00:03 +0000 https://sswug.org/?p=274950&preview=true&preview_id=274950   A busy professional asked me this question:   Is it undermining or rude to email the boss to ask him to get his act together after 1am? This is one of the reasons- undermining management, the HR dismissed me for gross misconduct. I was a chef and finished very late every night.   I would not do it. It’s […]

The post Is it undermining or rude to email the boss to ask him to get his act together? appeared first on SSWUG.ORG.

]]> Getting Started With Deep Learning in Your Browser Using TensorFlow.js https://sswug.org/sswugresearch/community/getting-started-with-deep-learning-in-your-browser-using-tensorflow-js/ https://sswug.org/sswugresearch/community/getting-started-with-deep-learning-in-your-browser-using-tensorflow-js/#respond Wed, 05 Aug 2020 07:00:12 +0000 https://sswug.org/?p=276059 (Raphael Mun) Here we look at: Setting up TensorFlow.js, creating training data, defining the neural network model, and training the AI.

The post Getting Started With Deep Learning in Your Browser Using TensorFlow.js appeared first on SSWUG.ORG.

]]> https://sswug.org/sswugresearch/community/getting-started-with-deep-learning-in-your-browser-using-tensorflow-js/feed/ 0 SQL Server Collation Overview and Examples https://sswug.org/sswugresearch/community/sql-server-collation-overview-and-examples/ https://sswug.org/sswugresearch/community/sql-server-collation-overview-and-examples/#respond Wed, 05 Aug 2020 07:00:11 +0000 https://sswug.org/?p=276058 (Aubrey Love) While installing SQL Server or creating databases and tables, we often run with the defaults. In most cases, that’s not a bad thing. However, when it comes to setting the COLLATION, we again often run with the default settings.

The post SQL Server Collation Overview and Examples appeared first on SSWUG.ORG.

]]> https://sswug.org/sswugresearch/community/sql-server-collation-overview-and-examples/feed/ 0 MySQL Escaping on the Client-Side With Go https://sswug.org/sswugresearch/community/mysql-escaping-on-the-client-side-with-go/ https://sswug.org/sswugresearch/community/mysql-escaping-on-the-client-side-with-go/#respond Wed, 05 Aug 2020 07:00:10 +0000 https://sswug.org/?p=276057 (Max Dudin) Day-to-day database operation requires, from an administrator, deep knowledge of db internals and security issues, in particular things like SQL injections.

The post MySQL Escaping on the Client-Side With Go appeared first on SSWUG.ORG.

]]> https://sswug.org/sswugresearch/community/mysql-escaping-on-the-client-side-with-go/feed/ 0 VS Code Gets New Python Language Server, Named After Monty Python Character https://sswug.org/sswugresearch/community/vs-code-gets-new-python-language-server-named-after-monty-python-character/ https://sswug.org/sswugresearch/community/vs-code-gets-new-python-language-server-named-after-monty-python-character/#respond Wed, 05 Aug 2020 07:00:09 +0000 https://sswug.org/?p=276056 (David Ramel) Someone on the development team for Python in Visual Studio Code is a Monty Python fan.

The post VS Code Gets New Python Language Server, Named After Monty Python Character appeared first on SSWUG.ORG.

]]> https://sswug.org/sswugresearch/community/vs-code-gets-new-python-language-server-named-after-monty-python-character/feed/ 0 How Hello World! changed – top level statements and functions (C# 9) https://sswug.org/sswugresearch/community/how-hello-world-changed-top-level-statements-and-functions-c-9/ https://sswug.org/sswugresearch/community/how-hello-world-changed-top-level-statements-and-functions-c-9/#respond Wed, 05 Aug 2020 07:00:08 +0000 https://sswug.org/?p=276055 (Christian Nagel) C# 9 comes with many new features to enhance productivity and fix bugs. One productivity enhancement comes for small programs and learning C#: top level statements.

The post How Hello World! changed – top level statements and functions (C# 9) appeared first on SSWUG.ORG.

]]> https://sswug.org/sswugresearch/community/how-hello-world-changed-top-level-statements-and-functions-c-9/feed/ 0