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: )

17 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: )

561 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: )

929 reads

Technical Article

Validating different types of data like Gmail, Outlook email addresses, phone numbers, and URLs

Validating different types of data like Gmail, Outlook email addresses, phone numbers, and URLs in SQL can be a bit challenging since SQL is primarily used for data manipulation in databases and not for complex data validation. However, depending on the database system you are using, there might be some limited string manipulation functions available that can help you perform basic validation checks.

1 (2)

You rated this post out of 5. Change rating

2023-07-28

249 reads

Blogs

The Basics of TRY CATCH Blocks–#SQLNewBlogger

By

I was working with a customer and discussing how to do error handling. This...

Working with ALS – Insights from the Ability Summit

By

The 14th annual Ability Summit is a global event that I attended a few...

Apr 9 Webinar: Accelerating Success: De-risking and Streamlining Releases with Flyway Enterprise

By

UPDATE: This moved to Apr 9 Join me Tuesday, Apr 9 for a webinar,...

Read the latest Blogs

Forums

Botched "Data warehouse" design...

By pietlinden

Someone landed a PowerBI mess in my lap, and near as I can tell,...

disaster recovery

By sqlfriend

We have two data centers in same city. One is our main site, the...

Set up Availability Group without a cluster to create read-only database

By koln

I want to have a a secondary ready-only database available for reporting, which is...

Visit the forum

Question of the Day

Backing up the Resource Database

How does the Resource database in SQL Server 2022 get backed up?

See possible answers