Scripts

Technical Article

Node Script to call Salesforce from external system

Salesforce runs batch jobs in its server which takes resources and time and creates a burden on the overall server. Hence often times there is a need for a mechanism to call Salesforce system from external system. Calling salesforce from external system results in less burden on the salesforce server and faster processing. By leveraging […]

5 (1)

You rated this post out of 5. Change rating

2024-03-21 (first published: )

112 reads

Technical Article

Simple T-SQL implementation for running SSRS subscriptions.

I created this stored procedure to be able to run SSRS subscriptions using T-SQL code instead of adding a component in the SSIS package with the subscription id. Let's say we have a set of report subscriptions named like this: ClientReport1, ClientReport2, ClientReport3. To run them using the stored procedure, all we need is this […]

5 (1)

You rated this post out of 5. Change rating

2023-11-29 (first published: )

1,118 reads

Technical Article

How to Move a Table into a Schema in T-SQL

To move a table into a schema in T-SQL, you can use the ALTER SCHEMA statement along with the TRANSFER option. Here are the steps to do this: Assuming you have an existing schema named "NewSchema" and a table named "YourTable" that you want to move into this schema: Open SQL Server Management Studio or […]

You rated this post out of 5. Change rating

2023-09-29 (first published: )

4,468 reads

Blogs

Speaking Engagements 2025

By

It’s been a minute since I’ve gotten out to speak at events, but the...

PASS Summit on Tour in New York City

By

The PASS Summit goes on tour this year, with an August stop in New...

SQL Server Errorlog: Not Just for Errors!

By

A Goldmine of Clues You Might Be Ignoring SQL Server’s Error Logs often get...

Read the latest Blogs

Forums

The Long Weekend

By Grant Fritchey

Comments posted to this topic are about the item The Long Weekend

Need Help to implement the De Duplication

By bala2014

Dear All, Good Day. I have a requirement to implement de-duplication on customer data...

Own Your Mistakes

By Grant Fritchey

Comments posted to this topic are about the item Own Your Mistakes

Visit the forum

Question of the Day

Independence Day

The film independence day was released in 1996. Which of these queries returns that year is run today?

See possible answers