Scripts

Technical Article

5 (6)

2022-02-22 (first published: )

5,704 reads

Technical Article

SQL Server instance startup type check by SQL script

I have developed the script to check SQL Server instances startup type, sometimes we didn't know all our SQL instances startup type correctly configurated, especially we cannot distinguish the Automatic and Automatic(Delayed Start) from the direct query, the only way is querying from the registry, you can use this script in your environment to bulk […]

5 (1)

2021-12-24

1,026 reads

Technical Article

Get backup folder sizes from shared Location

Got a message from the Operation team as below Hi Harsha, I'm seeing a larger than normal rate of change for a week day on the backups for the SQL2000 servers. Did anything run differently yesterday compared to Monday? I have 22 sql servers and all the Weekend and Monthly backups goes to the location […]

2021-12-03

321 reads

Technical Article

Import Multiple Packages to SSIS server

We cannot import multiple packages on the SSIS server. So, loading 100 packageS from  file location will be a tedious task for a DBA. We can solve this issue by making use of the DTUTIL utility. The DTUTIL utility can also import one package at a time, but we can write the batch file using the […]

2021-09-27 (first published: )

854 reads

Blogs

Speaking at SQLSaturday MN 2022

By

Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...

Goal Progress for Nov 2022

By

I set goals at the beginning of the year, and I’m tracking my progress...

PGSQL PHRIDAY #3: What is the PostgreSQL Community To You?

By

Very excited to take part in my third #PGSQLPhriday blogging event, even more so...

Read the latest Blogs

Forums

NULLIF in SSIS?

By Jobs90312

Hi everyone, I have a sql query: SELECT NULLIF('1900-01-01','1900-01-01') The result of above query...

Table has no data but query takes 20 secs to complete

By vsamantha35

Hi All, I have come across one issue today and I am looking for...

The DAX Text Contatenation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The DAX Text Contatenation

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers