GenAI, writing T-SQL and Automation

With CoPilot for SQL Server Management Studio announced at SQL Bits, I can't help but wonder what the DBA toolbox will look like in 12 months! Anyone using these tools in their day-to-day? ChatGPT, CoPilot? What do you use it for? How do you wish you could use them? 

Parents
  • We played with Co Pilot  a bit.  It is frightening what it can do with just a basic schema of some tables loaded.  Without a foreign key, primary keys or anything, it correctly wrote an ON statement like this:

    on tblA.ID = tblB.SomethingLongWithoutAnID.

    The good thing, maybe it will eliminate ORM.....

Reply
  • We played with Co Pilot  a bit.  It is frightening what it can do with just a basic schema of some tables loaded.  Without a foreign key, primary keys or anything, it correctly wrote an ON statement like this:

    on tblA.ID = tblB.SomethingLongWithoutAnID.

    The good thing, maybe it will eliminate ORM.....

Children
No Data