Skip to content

Instantly share code, notes, and snippets.

SELECT
TOP 10
qs.last_execution_time,
SUBSTRING(st.text, (qs.statement_start_offset/2) + 1,
((CASE qs.statement_end_offset
WHEN -1 THEN DATALENGTH(st.text)
ELSE qs.statement_end_offset
END - qs.statement_start_offset)/2) + 1) AS query_text
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st
SELECT
TOP 10
qs.total_elapsed_time / qs.execution_count AS average_execution_time,
qs.execution_count,
qs.total_logical_reads / qs.execution_count AS average_logical_reads,
qs.total_physical_reads / qs.execution_count AS average_physical_reads,
SUBSTRING(qt.text, (qs.statement_start_offset/2) + 1,
((CASE qs.statement_end_offset
WHEN -1 THEN DATALENGTH(qt.text)
ELSE qs.statement_end_offset
import (
"database/sql"
_ "github.com/microsoft/go-mssqldb"
_ "github.com/microsoft/go-mssqldb/integratedauth/krb5"
)
func main() {
// Replace with actual values
connectionString := "authenticator=krb5;server=your_server_name;database=your_database_name;user id=your_username;krb5-realm=comani.com;krb5-configfile=/etc/krb5.conf;"
function Generate-CodeVerifier {
$bytes = New-Object Byte[] 32
[System.Security.Cryptography.RandomNumberGenerator]::Create().GetBytes($bytes)
return [System.Convert]::ToBase64String($bytes) -replace '\+', '-' -replace '\/', '_' -replace '='
}
function Generate-CodeChallenge($verifier) {
$bytes = [System.Text.Encoding]::ASCII.GetBytes($verifier)
$hash = [System.Security.Cryptography.SHA256]::Create().ComputeHash($bytes)
return [System.Convert]::ToBase64String($hash) -replace '\+', '-' -replace '\/', '_' -replace '='
package main
import (
"crypto/x509"
"fmt"
"net/http"
"io/ioutil"
"encoding/base64"
package main
import (
"fmt"
"io/ioutil"
"log"
"net/http"
"github.com/skratchdot/open-golang/open"
)
package main
import (
"bytes"
"flag"
"fmt"
"os"
"strings"
)
package main
import (
"encoding/json"
"fmt"
"io/ioutil"
"net/http"
"os"
"strings"
)
async provideInlineCompletionItems(document, position, context, token) {
console.log('provideInlineCompletionItems triggered');
// Read the configuration settings
const config = vscode.workspace.getConfiguration('codeHelper');
const maxToGenerate = config.get<number>('maxToGenerate') || 128;
const temperature = config.get<number>('temperature') || 0.6;
const modelName = config.get<string>('modelName') || 'default_model';
const username = config.get<string>('username') || ''; // Read the username setting
const password = config.get<string>('password') || ''; // Read the password setting
"codeHelper.username": {
"type": "string",
"default": "",
"description": "Username for API authentication."
},
"codeHelper.password": {
"type": "string",
"default": "",
"description": "Password for API authentication."
}