13 local accounts, 2 being admin (1 is a dominion specific account that I doubt any local officials know), direct access to SQL through SSMS (yes it is installed), SQLCMD.EXE (yes it is installed), and TCP 1433 is wide open in the firewall with the instance sitting right on it with TCP/IP, Shared Memory, and Named Pipes enabled. Powershell installed, and yes, invoke-sqlcommand is ready to go on UNENCRYPTED PORT 5985, lol (see image). Can you BELIEVE THIS is deemed part of our NATIONAL CRITICAL INFRASTRUCTURE??? Can you BELIEVE this was 'tested' by multiple testing labs? Can you BELIEVE these 'testing labs' tested all our nation's voting systems? Oh and are you ready for the firewall ports opened???? You may want to sit down first...enjoy: NetBIOS UDP Port 123 Inbound Network Discovery (UPnP-In) Network Discovery (UPnP-Out) Network Discovery (NB-Name-In) Network Discovery (NB-Name-Out) Network Discovery (NB-Datagram-In) Network Discovery (NB-Datagram-Out) Network Discovery (WSD EventsSecure-In) Network Discovery (WSD EventsSecure-Out) Network Discovery (WSD Events-In) Network Discovery (WSD Events-Out) Network Discovery (SSDP-In) Network Discovery (SSDP-Out) Network Discovery (UPnPHost-Out) Network Discovery (WSD-In) Network Discovery (WSD-Out) Network Discovery (LLMNR-UDP-In) Network Discovery (LLMNR-UDP-Out) Network Discovery (Pub-WSD-In) Network Discovery (Pub WSD-Out) DVS Report Service DVS Adjudication Data Service NetBIOS UDP Port 123 Outbound SQL IIS Web Management Service (HTTP Traffic-In) File Server Remote Management (SMB-In) File Server Remote Management (DCOM-In) File Server Remote Management (WMI-In) File and Printer Sharing (NB-Session-In) File and Printer Sharing (NB-Session-Out) File and Printer Sharing (SMB-In) File and Printer Sharing (SMB-Out) File and Printer Sharing (NB-Name-In) File and Printer Sharing (NB-Name-Out) File and Printer Sharing (NB-Datagram-In) File and Printer Sharing (NB-Datagram-Out) File and Printer Sharing (Spooler Service - RPC) File and Printer Sharing (Spooler Service - RPC-EPMAP) File and Printer Sharing (Echo Request - ICMPv4-In) File and Printer Sharing (Echo Request - ICMPv4-Out) File and Printer Sharing (Echo Request - ICMPv6-In) File and Printer Sharing (Echo Request - ICMPv6-Out) File and Printer Sharing (LLMNR-UDP-In) File and Printer Sharing (LLMNR-UDP-Out) Message Queuing UDP Outbound Message Queuing UDP Inbound Message Queuing TCP Outbound Message Queuing TCP Inbound File and Printer Sharing (NB-Session-In) File and Printer Sharing (NB-Session-Out) File and Printer Sharing (SMB-In) File and Printer Sharing (SMB-Out) File and Printer Sharing (NB-Name-In) File and Printer Sharing (NB-Name-Out) File and Printer Sharing (NB-Datagram-In) File and Printer Sharing (NB-Datagram-Out) File and Printer Sharing (Spooler Service - RPC) File and Printer Sharing (Spooler Service - RPC-EPMAP) File and Printer Sharing (Echo Request - ICMPv4-In) File and Printer Sharing (Echo Request - ICMPv4-Out) File and Printer Sharing (Echo Request - ICMPv6-In) File and Printer Sharing (Echo Request - ICMPv6-Out) File and Printer Sharing (LLMNR-UDP-In) File and Printer Sharing (LLMNR-UDP-Out) Network Discovery (UPnP-In) Network Discovery (UPnP-Out) Network Discovery (NB-Name-In) Network Discovery (NB-Name-Out) Network Discovery (NB-Datagram-In) Network Discovery (NB-Datagram-Out) Network Discovery (WSD EventsSecure-In) Network Discovery (WSD EventsSecure-Out) Network Discovery (WSD Events-In) Network Discovery (WSD Events-Out) Network Discovery (SSDP-In) Network Discovery (SSDP-Out) Network Discovery (UPnPHost-Out) Network Discovery (WSD-In) Network Discovery (WSD-Out) Network Discovery (LLMNR-UDP-In) Network Discovery (LLMNR-UDP-Out) Network Discovery (Pub-WSD-In) Network Discovery (Pub WSD-Out) DHCP Server (SMB-In) DHCP Server Failover (TCP-Out) DHCP Server Failover (TCP-In) DHCP Server - Remote Service Management using SCM (RPC-in) DHCP Server (RPCSS-In) DHCP Server (RPC-In) DHCP Server v6 (UDP-In) DHCP Server v4 (UDP-In) DHCP Server v6 (UDP-In) DHCP Server v4 (UDP-In) All Outgoing (UDP) All Outgoing (TCP) RPC (TCP, Incoming) DNS (UDP, Incoming) DNS (TCP, Incoming) RPC Endpoint Mapper (TCP, Incoming) Windows Communication Foundation Net.TCP Listener Adapter (TCP-In) World Wide Web Services (HTTPS Traffic-In) World Wide Web Services (HTTP Traffic-In) @{Microsoft.XboxGameCallableUI_1000.14393.0.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.XboxGameCallable... @{Microsoft.Windows.Apprep.ChxApp_1000.14393.0.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.Appre... @{Microsoft.LockApp_10.0.14393.0_neutral__cw5n1h2txyewy?ms-resource://Microsoft.LockApp/resources/AppDisplayName} @{Microsoft.AccountsControl_10.0.14393.0_neutral__cw5n1h2txyewy?ms-resource://Microsoft.AccountsControl/Resources/Di... @{Microsoft.Windows.Cortana_1.7.0.14393_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.Cortana/resour... @{Microsoft.Windows.Cortana_1.7.0.14393_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.Cortana/resour... @{Microsoft.Windows.ShellExperienceHost_10.0.14393.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.S... @{Microsoft.Windows.CloudExperienceHost_10.0.14393.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.C... @{Microsoft.Windows.CloudExperienceHost_10.0.14393.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.C... @{Microsoft.AAD.BrokerPlugin_1000.14393.0.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.AAD.BrokerPlugin/r... @{Microsoft.AAD.BrokerPlugin_1000.14393.0.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.AAD.BrokerPlugin/r... @{Microsoft.XboxGameCallableUI_1000.14393.0.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.XboxGameCallable... @{Microsoft.Windows.Apprep.ChxApp_1000.14393.0.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.Appre... @{Microsoft.LockApp_10.0.14393.0_neutral__cw5n1h2txyewy?ms-resource://Microsoft.LockApp/resources/AppDisplayName} @{Microsoft.AccountsControl_10.0.14393.0_neutral__cw5n1h2txyewy?ms-resource://Microsoft.AccountsControl/Resources/Di... @{Microsoft.Windows.Cortana_1.7.0.14393_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.Cortana/resour... @{Microsoft.Windows.Cortana_1.7.0.14393_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.Cortana/resour... @{Microsoft.Windows.ShellExperienceHost_10.0.14393.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.S... @{Microsoft.Windows.CloudExperienceHost_10.0.14393.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.C... @{Microsoft.Windows.CloudExperienceHost_10.0.14393.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.C... @{Microsoft.AAD.BrokerPlugin_1000.14393.0.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.AAD.BrokerPlugin/r... @{Microsoft.AAD.BrokerPlugin_1000.14393.0.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.AAD.BrokerPlugin/r... @{Microsoft.XboxGameCallableUI_1000.14393.0.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.XboxGameCallable... @{Microsoft.Windows.Apprep.ChxApp_1000.14393.0.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.Appre... @{Microsoft.LockApp_10.0.14393.0_neutral__cw5n1h2txyewy?ms-resource://Microsoft.LockApp/resources/AppDisplayName} @{Microsoft.AccountsControl_10.0.14393.0_neutral__cw5n1h2txyewy?ms-resource://Microsoft.AccountsControl/Resources/Di... @{Microsoft.Windows.Cortana_1.7.0.14393_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.Cortana/resour... @{Microsoft.Windows.Cortana_1.7.0.14393_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.Cortana/resour... @{Microsoft.Windows.ShellExperienceHost_10.0.14393.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.S... @{Microsoft.Windows.CloudExperienceHost_10.0.14393.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.C... @{Microsoft.Windows.CloudExperienceHost_10.0.14393.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.C... @{Microsoft.AAD.BrokerPlugin_1000.14393.0.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.AAD.BrokerPlugin/r... @{Microsoft.AAD.BrokerPlugin_1000.14393.0.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.AAD.BrokerPlugin/r... @{Microsoft.XboxGameCallableUI_1000.14393.0.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.XboxGameCallable... @{Microsoft.Windows.Apprep.ChxApp_1000.14393.0.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.Appre... @{Microsoft.LockApp_10.0.14393.0_neutral__cw5n1h2txyewy?ms-resource://Microsoft.LockApp/resources/AppDisplayName} @{Microsoft.AccountsControl_10.0.14393.0_neutral__cw5n1h2txyewy?ms-resource://Microsoft.AccountsControl/Resources/Di... @{Microsoft.Windows.Cortana_1.7.0.14393_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.Cortana/resour... @{Microsoft.Windows.Cortana_1.7.0.14393_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.Cortana/resour... @{Microsoft.Windows.ShellExperienceHost_10.0.14393.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.S... @{Microsoft.Windows.CloudExperienceHost_10.0.14393.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.C... @{Microsoft.Windows.CloudExperienceHost_10.0.14393.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.Windows.C... @{Microsoft.AAD.BrokerPlugin_1000.14393.0.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.AAD.BrokerPlugin/r... @{Microsoft.AAD.BrokerPlugin_1000.14393.0.0_neutral_neutral_cw5n1h2txyewy?ms-resource://Microsoft.AAD.BrokerPlugin/r... Distributed Transaction Coordinator (TCP-In) Windows Management Instrumentation (ASync-In) Windows Management Instrumentation (WMI-Out) Windows Management Instrumentation (WMI-In) Windows Management Instrumentation (DCOM-In) mDNS (UDP-Out) mDNS (UDP-In) Core Networking - Group Policy (LSASS-Out) Core Networking - DNS (UDP-Out) Core Networking - Group Policy (TCP-Out) Core Networking - Group Policy (NP-Out) Core Networking - IPv6 (IPv6-Out) Core Networking - IPv6 (IPv6-In) Core Networking - IPHTTPS (TCP-Out) Core Networking - IPHTTPS (TCP-In) Core Networking - Teredo (UDP-Out) Core Networking - Teredo (UDP-In) Core Networking - Dynamic Host Configuration Protocol for IPv6(DHCPV6-Out) Core Networking - Dynamic Host Configuration Protocol for IPv6(DHCPV6-In) Core Networking - Dynamic Host Configuration Protocol (DHCP-Out) Core Networking - Dynamic Host Configuration Protocol (DHCP-In) Core Networking - Internet Group Management Protocol (IGMP-Out) Core Networking - Internet Group Management Protocol (IGMP-In) Core Networking - Destination Unreachable Fragmentation Needed (ICMPv4-In) Core Networking - Multicast Listener Done (ICMPv6-Out) Core Networking - Multicast Listener Done (ICMPv6-In) Core Networking - Multicast Listener Report v2 (ICMPv6-Out) Core Networking - Multicast Listener Report v2 (ICMPv6-In) Core Networking - Multicast Listener Report (ICMPv6-Out) Core Networking - Multicast Listener Report (ICMPv6-In) Core Networking - Multicast Listener Query (ICMPv6-Out) Core Networking - Multicast Listener Query (ICMPv6-In) Core Networking - Router Solicitation (ICMPv6-Out) Core Networking - Router Solicitation (ICMPv6-In) Core Networking - Router Advertisement (ICMPv6-Out) Core Networking - Router Advertisement (ICMPv6-In) Core Networking - Neighbor Discovery Advertisement (ICMPv6-Out) Core Networking - Neighbor Discovery Advertisement (ICMPv6-In) Core Networking - Neighbor Discovery Solicitation (ICMPv6-Out) Core Networking - Neighbor Discovery Solicitation (ICMPv6-In) Core Networking - Parameter Problem (ICMPv6-Out) Core Networking - Parameter Problem (ICMPv6-In) Core Networking - Time Exceeded (ICMPv6-Out) Core Networking - Time Exceeded (ICMPv6-In) Core Networking - Packet Too Big (ICMPv6-Out) Core Networking - Packet Too Big (ICMPv6-In) Core Networking - Destination Unreachable (ICMPv6-In) Cast to Device functionality (qWave-TCP-Out) Cast to Device functionality (qWave-TCP-In) Cast to Device functionality (qWave-UDP-Out) Cast to Device functionality (qWave-UDP-In) Cast to Device UPnP Events (TCP-In) Cast to Device SSDP Discovery (UDP-In) Cast to Device streaming server (RTSP-Streaming-In) Cast to Device streaming server (RTSP-Streaming-In) Cast to Device streaming server (RTSP-Streaming-In) Cast to Device streaming server (RTP-Streaming-Out) Cast to Device streaming server (RTP-Streaming-Out) Cast to Device streaming server (RTP-Streaming-Out) Cast to Device streaming server (RTCP-Streaming-In) Cast to Device streaming server (RTCP-Streaming-In) Cast to Device streaming server (RTCP-Streaming-In) Cast to Device streaming server (HTTP-Streaming-In) Cast to Device streaming server (HTTP-Streaming-In) Cast to Device streaming server (HTTP-Streaming-In) Windows Remote Management (HTTP-In) Windows Remote Management (HTTP-In) DIAL protocol server (HTTP-In) DIAL protocol server (HTTP-In) AllJoyn Router (UDP-Out) AllJoyn Router (UDP-In) AllJoyn Router (TCP-Out) AllJoyn Router (TCP-In) Connected User Experiences and Telemetry

-💡 I broke down the core SQL command types every Data Analyst should know — plus a quick tip on commands vs. statements. -Check it out!👇 linkedin.com/posts/rofiah-ab… #dataanalysis #sqlcommand

これ実装良くない気がするな。 SqlCommandでreader取った後値取ってないからフェアじゃない。 github.com/neko3cs/neko3cs-l…

IMO, FromSql() should have been defined with an overload that accepts an object of the SqlCommand-like type as its parameter, to protect against improperly crafted raw SQL statements from string literals. The EF query processor can deduce the actual SQL string.

So proud of you for using C# Robert Embrace the wonders of using "var" to declare variables; much tidier: "var cmd = new SqlCommand..."

The SqlCommand and SqlDataReader suggest it's C#.

Side project took 20 minutes to convert 10 projects from mostly NET5, two NET7 to NET8. Totally wigged out both Visual Studio 2022 and ReSharper once done. At the end everything runs as expects, but 🔹Visual Studio would not do multiple save 🔹ReSharper code lens just blinked but worked. Final steps 📎 Get rid of SqlCommand for Dapper 📎 Implement new NET8/EF Core 8 features 📎 Add SeriLog

Number 2. Also not a big fan of 'new()'. Would prefer 'var cmd = new SqlCommand {...}'

O si tiene que hacerlo desde el lenguaje porque no tiene privilegios para crear procedimientos almacenados en base de datos, por lo menos que prepare la consulta para evitar Inyección. En C# de hace con SqlCommand, en Java no se.

SQL Command Types in a Nutshell ✅ Don't forget to save this post for later 👈 Follow @akavikash Tags:- #sql #sqlcommand #sqlcommandtypes #crud #database #databasequeries #dba #databaseadministrator #devops #developer #coder #programmers

In a strange coincidence: I also brushed off my VB in the last week - I have Dapper.Advisor working on VB (not released yet) - and it would work *on your code as written* (SqlCommand etc) - as in, it'll show any SQL problems. I haven't done "find the parameters" for raw ado yet.

DapperやSQLCommandが速くて良き。

From KB : Execute Stored Procedures using SqlCommand in AspNet Core binaryintellect.net/articles… #AspNet #AspNetCore #DotNet #CSharp #VisualStudio #WebDevelopment #SoftwareDevelopment #TechBlog #CodingTips #TechNews #LearnToCode #DevCommunity

How about using raw SQL with SqlCommand :)

Alın size meşhur ChatGPT'nin .Net 7.0 ve Linq Entity kullanarak yaz dediğim kodları. Her bir item için tek tek insert komutunu raw sql ile execute ediyor. Transaction, hata yakalama falan da hak getire. Tek doğru şey tek connection açması :) Entity 7.0'da SqlCommand neyy yaa🌼

SQL COMMAND TYPES #Database #Coding_Everybody #dataengineer #sql #dbms #query #sqlcommand

Execute Stored Procedures using SqlCommand in ASP .NET Core by @joshibipin binaryintellect.net/articles… #aspnetcore

New Article : Execute Stored Procedures using SqlCommand in AspNet Core binaryintellect.net/articles… #AspNet #AspNetCore #DotNet #DotNetCore #CSharp #VisualStudio #WebDevelopment #SoftwareDevelopment #Programming #Coding #DevCommunity

New Article : Execute action queries using SqlCommand in AspNet Core binaryintellect.net/articles… #AspNet #AspNetCore #DotNet #DotNetCore #CSharp #VisualStudio #WebDevelopment #SoftwareDevelopment #Programming #Coding #DevCommunity

Two years later, I find the remote connection error bug on my #PowerShell Invoke-SQLCommand script trying to fix something completely different. A typo in a variable name… the hours spent trying to fix this…