Technical Article

Drop all Databases (+the option to exclude one)

I made this Query because we fix databases localy on a workstation (we have no sql server) but when backup up the server they need to be deleted localy that could sometimes take a while.U can run this Query from the QA or ad it as a Job it's possible to run it from an […]

4.5 (2)

You rated this post out of 5. Change rating

2005-08-26 (first published: )

506 reads

Blogs

How Long Will It Take to Learn SQL? The Truth Might Surprise You

By

In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...

Flying Halfway Around the World to Australia

By

I leave tonight for Australia. I was in London 3 days ago, so this...

Dealing with Change – Two Resources

By

As I look at the state of information technology today, I see one constant:...

Read the latest Blogs

Forums

SSIS Web Service task SSL errors

By smithloo

I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great...

CDC Custom Alert

By Abdul122

Hi All,   I am writing an alert in a sql agent job, basically...

How to use a scalar function in INSERT stmt?

By mjdemaris

Hello all, I would like to create an INSERT statement and use a UDF...

Visit the forum

Question of the Day

Initial Config of tempdb

What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?

See possible answers