Peter Marriott

  • Interests: Application Developer and occasional dev DBA, been working with Databases since the late eighties and used every version of SQLServer since the 4.21 through to SQL Azure.

Blogs

Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests

By

"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...

Adding a Local Model to Ollama through the GUI

By

I saw some good reviews of the small gemma3 model in a few places...

Connect resiliently to SQL Server

By

 Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...

Read the latest Blogs

Forums

Powershell extract

By Sqladmin1

$server = "YourServer" $db = "YourDatabase" $sqlFile = "C:\path\query.sql" $outFile = "C:\path\output.xlsx" # Run...

Powershell extract

By Sqladmin1

$server = "YourServer" $db = "YourDatabase" $sqlFile = "C:\path\query.sql" $outFile = "C:\path\output.xlsx" # Run...

Some query values change when query is run but not others. Why?

By water490

Hi everyone I have a 1000 line SQL query that is too long to...

Visit the forum

Question of the Day

PWDCompare

What does the PWDCOMPARE function do?

See possible answers