Drupal is a Senior SQL Server consultant with over 20 years of experience in engineering innovative SQL Server solutions for high growth organizations. A truly SQL Server specialist and IT generalist, Drupal is a certified MCDBA, Oracle OCP-DBA and IBM WebSphere Administrator. He is also ITIL V3 certified at the Foundation and Intermediate levels as well as PMP.

How to check whether and when sql index statistics were updated last time?

by SQLPals

Mission: SQL Homeostasis

I was working for a client on their very critical and heavily used database. The application was an E-commerce website...

2018-04-19

3,684 reads

How to start SQL Server job using TSQL and wait for it to complete?

by SQLPals

Mission: SQL Homeostasis

If you ever had a need to start a SQL job using sp_start_job stored procedure in msdb then you know...

2018-04-19

13,904 reads

SQL server database size, location and volume info

by SQLPals

Mission: SQL Homeostasis

For one of my clients, I needed to know and document not only database names, size and locations but also...

2018-04-19

549 reads

Blogs

My 2024 in Data: Music

This is my last week of the year working (I guess I come back...

A New Word: Suente

suente– n. the state of being so familiar with someone that you can be...

Side Projects

By Andrew Pruski

Anyone (everyone?) who has ever tried to learn a programming language knows that to...

Read the latest Blogs

Forums

Timeout Error while executing a TSQL statement in Sql server Express Edition

By IT researcher

I am getting the below error when I execute a SQL command in SQL...

Timeout Error while executing a TSQL statement in Sql server Express Edition

By IT researcher

I am getting the below error when I execute a SQL command in SQL...

Sql script replace and rearrange numbers

By diegodeveloper

Hi everyone. I have this table and this information. (left side of the image)...

Visit the forum

Question of the Day

DCL

We have DDL, DML, and DCL. What is DCL used for?

See possible answers