davepcallan

USE TestDB
GO

DECLARE @DatabaseName VARCHAR(100)
DECLARE @SchemaName VARCHAR(100)
DECLARE @TableName VARCHAR(100)
DECLARE @ColumnName VARCHAR(100)
DECLARE @FullyQualifiedTableName VARCHAR(500)

--Create Temp Table to Save Results

davepcallan

SELECT 'ALTER TABLE ' + QUOTENAME(ss.name) + '.' + QUOTENAME(st.name) + ' ADD created_date DATETIME NULL;'
FROM sys.tables st
INNER JOIN sys.schemas ss on st.[schema_id] = ss.[schema_id]
WHERE st.is_ms_shipped = 0
AND NOT EXISTS (
 SELECT 1
 FROM sys.columns sc
 WHERE sc.[object_id] = st.[object_id]
 AND sc.name = 'created_date'
)

davepcallan

{
  rateLimit {
    limit
    remaining
    used
    resetAt
  }
  user(login: "davepcallan") {
    name
    bio

davepcallan

using BenchmarkDotNet.Attributes;
using BenchmarkDotNet.Columns;
using BenchmarkDotNet.Configs;
using BenchmarkDotNet.Jobs;
using BenchmarkDotNet.Reports;
using BenchmarkDotNet.Environments;

namespace ExceptionBenchmark
{
    [Config(typeof(Config))]

davepcallan

-- Create Test Table
CREATE TABLE TruncateTest (ID INT)
INSERT INTO TruncateTest (ID)
SELECT 1
UNION ALL
SELECT 2
UNION ALL
SELECT 3
GO
-- Check the data before truncate

davepcallan

{
  rateLimit {
    limit
    remaining
    used
    resetAt
  }
  repository(owner: "dotnet", name: "runtime") {
    pullRequests(states: MERGED, first: 50, orderBy: {field: CREATED_AT, direction: DESC}) {
      edges {

davepcallan

davepcallan

{
  search(query: "repo:dotnet/runtime is:pr author:stephentoub", type: ISSUE, first: 100) {
    edges {
      node {
        ... on PullRequest {
          title
          url
          number
          createdAt
          state

davepcallan

{
  repository(owner: "dotnet", name: "runtime") {
    pullRequests(states: MERGED, first: 100, orderBy: {field: CREATED_AT, direction: DESC}) {
      edges {
        node {
          title
          url
          number
          mergedAt
          reviewDecision

davepcallan

using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.Logging;
using System.Text;
using System.Text.Json;

namespace Samples;

public class ChatGPTAPIExample(ILogger<ChatGPTAPIExample> logger, IConfiguration configuration)
{
    private string Prompt = "Please explain the following code :";