Forum Replies Created

Viewing 15 posts - 1 through 15 (of 41 total)

  • Reply To: AI Sings the Blues

    AI is a tool, and as the maestro, it is our responsibility to validate responses for hallucinations and iteratively refine prompts to achieve our goals. Machine Teaching (MT) plays a...

    • This reply was modified 8 months, 2 weeks ago by Peter Heller.
    • This reply was modified 8 months, 2 weeks ago by Peter Heller.
    • This reply was modified 8 months, 2 weeks ago by Peter Heller.
  • Reply To: AI Sings the Blues

    AI is transforming our world at a pace reminiscent of moving from horse-drawn carriages to the SSC Tuatara—the fastest stock commercial car, blazing ahead at 295 miles per hour. Despite...

  • Reply To: AI Sings the Blues

    AI is a powerful tool, but you are the maestro who brings it to life. It’s like having a grand piano at your disposal—shouting "Play!" won't produce a single note....

  • Reply To: Leveraging AI Tools for SQL Queries

    This was an excellent article in exploring the iterative prompt engineering.  Also, consider looking into https://ollama.com/ for private LLM's or Huggingfaces.com.  Look into medium.com for ideas on AI and the...

  • Reply To: Leveraging AI Tools for SQL Queries

    1. Providing the Northwinds2022TSQLV7.SQL metadata and using the SQL Server 2019 on Ubuntu helps with establishing the metadata and which target engine is being used.
    2. I need to write a...
  • Reply To: Leveraging AI Tools for SQL Queries

    1. Providing the Northwinds2022TSQLV7.SQL metadata and using the SQL Server 2019 on Ubuntu helps with establishing the metadata and which target engine is being used.
    2. I need to write a...
  • Reply To: Leveraging AI Tools for SQL Queries

    1. Providing the Northwinds2022TSQLV7.SQL metadata and using the SQL Server 2019 on Ubuntu helps with establishing the metadata and which target engine is being used.
    2. I need to write a...
  • Reply To: Machine learning K-Means applied to SQL Server data

    This is an awesome article.  I t  falls in line with my learning Python and Pandas.  Also, I a Database Connection class and choose pyodbc over SQLAlchemy.  Azure Data Studio...

  • Reply To: Existing scalar function within a trigger is not found

    This problem has been resolved.  Thanks to all.

  • Reply To: Existing scalar function within a trigger is not found

    The fix was [hashing].[CreateSha256KeyFromJsonInputSalesCustomer] not [hashing].[CreateSha256FromJsonInputSalesCustomer].

    Thanks for your suggestion about changing the naming.

  • Reply To: Existing scalar function within a trigger is not found

    create table [Audit].[SalesCustomerHistory](
    [SalesCustomerHistoryId] [sdSequenceNumber].[SurrogateKeyNumber] identity(1,1) not null,
    [AuditDateTimeStamp] [sdSysTime].[AuditTriggerTimestamp] not null,
    [DBAction] [dbo].[DbAction] not null,
    [CustomerID] [sdSequenceNumber].[SurrogateKeyNumber] not null,
    [CountryID] [sdSequenceNumber].[SurrogateKeyNumber] not null,
    [CustomerExpenditureClassificationID] [sdSequenceNumber].[SurrogateKeyNumber] null,
    [CustomerName] [sdPersonNameString].[CustomerName] null,
    [CustomerAddress1] [sdAddressesString].[AddressString] null,
    [CustomerAddress2] [sdAddressesString].[AddressString] null,
    [CustomerPostalCode]...
  • Reply To: INSERT EXEC statement cannot be nested, the Simple Solution

    This is a great proprietary solution but lacks portability in a heterogeneous database environment using ANSI SQL.

    You said "All those solutions are hacky, and it is simply not always possible...

    • This reply was modified 3 years ago by Peter Heller. Reason: No rating which I would have given a 5
  • Reply To: ODBC Driver 18.0

    Any suggestions to get to work using localhost,13001 and the default database?

    ODBC18

  • Reply To: Your First Repo in Azure Data Studio or VS Code

    Great article,  I will use it in my database class.  It works cross platform which will be awesome for the students.

  • Reply To: Crazy Interview Questions

    I was asked how I liked to report to my manager?

    I responded that I liked to respond to my manager in the manner in which they would like to me...

Viewing 15 posts - 1 through 15 (of 41 total)