sql prompt

Article

Generative AI holds immense potential for businesses, but its success depends on the quality of your data. High-quality, strategically managed data is essential for building trustworthy, unique, and competitive AI applications. This article explores how AI leverages your data through embeddings, outlines best practices for data management, and emphasizes the importance of responsible AI development. By prioritizing data quality and effective management, you'll position your business to reap the full benefits of Generative AI and drive innovation.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2024-02-21

2,999 reads

Discuss

SQL Window Functions Series: LAG() and LEAD()

by Nikhil Bangad

SQLServerCentral

Article

Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2023-12-11

11,046 reads

Discuss

SQL Prompt Safety Net Features for SSMS: SQL History

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

Mistakes occasionally happen. Occasionally, you make some ill-judged 'refinements' to working code and now just wish you could rewind your tab back in time an hour and forget the whole sorry episode. Now and again, SSMS just conspires against you and crashes unexpectedly, and you lose all your currently open query tabs, some of which you hadn't saved. SQL History offers a useful safety net in the event of any of these unfortunate events.

2023-04-17

SQL Prompt ALT S Magic

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

SQL Prompt's new command palette provides a fast way to navigate the tool's functionality via a single keyboard shortcut: ALT+S. Phil Factor explains how you can use the command palette to find and execute SQL Prompt functionality and common SSMS commands, as well as search for database objects.

2022-03-11

Exploring Auto-fix in SQL Code Analysis

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

Phil Factor presents a useful but slightly flawed 'table report' script as an adventure playground for exploring SQL Code analysis issues. He demonstrates use of the auto-fix feature, to arrive at a pristine script free from wavy green underlines.

2022-01-05

Managing, Editing and Comparing SQL Code Analysis Settings

by Additional Articles

SQLServerCentral

Vendors/3rd-party Products

Article

If you need to manage multiple code analysis settings files, per team or database, you'll want a good way to document and manage the files, and to compare two files to see what changed.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2021-08-06

How to Compare Two SQL Prompt Styles

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

A PowerShell function that will compare two SQL formatting styles, saved in JSON, and produce a report showing the differences between the options they use to lay out your SQL code.

2021-07-26

Creating and Maintaining a SQL Code Snippet Library

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

How to save all your different types of SQL code snippets in a central library of JSON Snippet Collections, where you can search and edit each collection and then write them out as individual code snippets, for use in SQL Prompt, SSMS or your programmer's clipboard.

2021-06-28

Managing SQL Snippet Collections using JSON and PowerShell

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

Maintain your favorite SQL snippets and queries centrally, using PowerShell to save and update each snippet collection, in JSON, and then converting them into SQL code snippets for SQL Prompt.

2021-06-16

Customizations in SQL Prompt

by Additional Articles

Redgate

Vendors/3rd-party Products

Article

In this brand new course on the Redgate University Grant Fritchey walks you through the many ways in which SQL Prompt can be customized to suit your specific needs.

2021-03-29

sql prompt

Forget the Models, Your Data is the Secret Sauce for Generative AI

SQL Window Functions Series: LAG() and LEAD()

SQL Prompt Safety Net Features for SSMS: SQL History

SQL Prompt ALT S Magic

Exploring Auto-fix in SQL Code Analysis

Managing, Editing and Comparing SQL Code Analysis Settings

How to Compare Two SQL Prompt Styles

Creating and Maintaining a SQL Code Snippet Library

Managing SQL Snippet Collections using JSON and PowerShell

Customizations in SQL Prompt

Blogs

Rambling about Data on Wheels – origins, branding, expansion

Think Twice Before Enabling Fabric’s Inbound Network Protection

Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python

Forums

AI Observability Challenges in FinOps as a DBA

Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL

SQL Agent Job Automated Change Capture Process

Question of the Day

Finding a Database Master Key