The ChatGPT API (Application Programming Interface) is a service provided by OpenAI that allows developers to integrate ChatGPT into their applications, products, or services. ChatGPT is a language model based on the GPT architecture, and it can perform various natural language processing tasks, such as generating...
This code defines a stored procedure called sp_ExecuteRemoteQueryXML that allows you to execute a remote query on a different SQL Server instance and return the result as XML. This can be useful when you need to retrieve data from a remote server and process it as XML in your local SQL Server instance. By utilizing the...
Creating the first project with Selenium https://www.selenium.dev/ Start by create a new project : Consoloa App (.Net Framework) Add the NuGet packages: Selenium.WebDriver Edit the “Program.cs” file and add this code : 1 static void Main(string[] args) 2 { 3 IWebDriver driver = new ChromeDriver(); 4...
How to save/restore serializable object to/from file in C# ? Using binary file Writes and reads ALL object properties and variables to / from the file (i.e. public, protected, internal, and private). The data saved to the file is not human readable, and thus cannot be edited outside of your application. Have to...
Gradle# Convention bases build tool DSL to describe the build Support muit-projects Easy customizable Builds many languages Support dependencies Instalation# Setting up Gradle environment First thing, go to the website: https://gradle.org/ https://gradle.org/releases/ Download the binary-only, and unzip at c:\Gradle\...
Demo Preparation 1 2Create Database [Deadlockdemo] 3go 4use [Deadlockdemo]; 5go 6CREATE TABLE dbo.invoices_demo ( 7 id int NOT NULL, 8 num nvarchar(20) NOT NULL, 9 customer nvarchar(100) NOT NULL, 10 created_at DateTime NOT NULL, 11 updated_at DateTime NOT NULL, 12 CONSTRAINT PK_invoices PRIMARY KEY (id) 13); 14...
Why Python… Versatile, data science, machine learning, web development and more… Strong community, there are a package for everything. Easy to learn, easy to read, concise, interpreted language. Install Python… Open Microfost Store https://www.python.org/downloads/ and install Visual Studio Code...
Groundhog Day… A few years ago, we needed an application. Although there are hundreds of applications available on the internet, and everybody use this kind of application, and there are a lot of free open-source available. Well… We decided to create our version. … after months of development, hours and hours of...
Indexing is the fast way to be faster The problem is, though … how do you choose the right indexes? How do you choose the right index keys? It’s very easy to choose the wrong indexes, in this case bad performance. FILLFACTOR and PAD_INDEX FILLFACTOR and PAD_INDEX are only used when the index is being built or rebuilt....
When there is no more space Compress folders to Save Storage Space 1 2Invoke-WmiMethod -Path "Win32_Directory.Name='C:\Test'" -Name compress Command line 1echo Uninstall all previous versions of components 2DISM.exe /online /Cleanup-Image /StartComponentCleanup 3 4echo Remove files needed for uninstallation of service...
Find all CLRs on all databases can be hard work, this code help to find these CLRs. Select all CLRs on a database: 1-- Select all CLRs on a database 2SELECT distinct 3 DB_NAME() AS DatabaseName, 4 udf.type AS Type, 5 udf.name AS Name, 6 udf.object_id AS ID, 7 udf.create_date AS CreateDate, 8 udf.modify_date AS...
This time to change, after many years, I left Pluxml. Pluxml is an excellent CMS, it is easy to install, configure, fast, there are a lot of themes and plugins. There is no database, but I had some little issues as .. Must edit online. Must use Pluxml interface to add new post. You cannot use a writing assistance...
A browser add-on to help you find a tab easier. https://addons.mozilla.org/en-CA/firefox/addon/find-your-tab/
This article offers a sample of basic Markdown syntax that can be used in Hugo content files, also it shows whether basic HTML elements are decorated with CSS in a Hugo theme.
SQL Script to export table data in xml files, or export schema data to xsd files This use OLE Automation Stored Procedures (Transact-SQL), and maybe, you need to change the global configuration settings of SQL Server. It can be an issue in production environment, and this case. The SQL Script have three stored...
This PowerShell script generates an html report listing all accounts used as logon account by services on servers in an Active Directory domain. The script has filters to ignore accounts : NT Service, NT AUTHORITY and LocalSystem https://github.com/sozezzo/Powershell/blob/master/Report/report-service-server.ps1 Apply...
This query returns list of tables and their columns with details. 1 2SELECT @@Servername AS ServerName 3 , DB_NAME() AS DatabaseName 4 , DB_ID() AS DatabaseId 5 , sc.name AS SchemaName 6 , tab.schema_id AS SchemaId 7 , tab.NAME AS TableName 8 , tab.object_id AS TableId 9 , col.NAME AS ColumnName 10 , col.column_id 11 ,...
Disable all triggers on a table, you do what you have to do, after enable only the triggers that have been disabled. Step 1 : Disable all triggers 1 2--#region Disable triggers 3 4DECLARE @triggers TABLE (SqlEnableTrigger NVARCHAR(MAX)); 5DECLARE @SchemaName VARCHAR(128) = 'mySchema'; – ** TO DO ** 6DECLARE @TableName...
A jobSql Job was changed. The questions are: When? by Who? We suppose you always have a copy of yours jobs. ** Check the SQL Script for shared folder, your e-mail and SMTP server. Delete old audit configuration – make sure you want to do that. 1 2print @@servername 3 4USE [master] 5 6GO 7 8BEGIN TRY ALTER SERVER AUDIT...