SQL Sever

Technical Article

5 (6)

You rated this post out of 5. Change rating

2022-02-22 (first published: )

7,758 reads

SQLServerCentral Article

Running SQL Server on Oracle and Google Cloud

  • Article

In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure and Google Cloud Platform offers to host a Microsoft SQL Server database. This information can prove to be handy while deciding on the best cloud provider to host a given application or database.

4.2 (5)

You rated this post out of 5. Change rating

2022-02-18

7,108 reads

SQLServerCentral Article

Power Query or SQL Server? Which, when and why

  • Article

When it comes to developing a Power BI report, we can use it for accessing data, transforming the data, and turning the data into information using visuals. With no doubt Power BI can do the job from beginning to end. Now, this is not the only, nor necessarily the best, tool for all the steps […]

4 (3)

You rated this post out of 5. Change rating

2021-01-25

17,056 reads

Technical Article

Migrate and Upgrade SQL Instance (2014/2016) to 2019 version with 1 click

  • Script

The script includes these steps:   STEP 1: CREATE EMPTY Databases STEP 2 - CREATE Logins WITH SERVER ROLESPERMISSIONS STEP 3 - COPY LINKED SERVERS STEP 4 - COPY SERVER OPTIONS STEP 5 - COPY CREDENTIALS STEP 6 - COPY AGENT JOBS STEP 7 - COPY DB Mail STEP 8 - COPY CERTIFICATES STEP 9 […]

You rated this post out of 5. Change rating

2020-05-22 (first published: )

1,132 reads

Technical Article

Migrate and Upgrade SQL Instance (2014/2016) to 2019 version with 1 click

  • Script

The script includes these steps:   STEP 1: CREATE EMPTY Databases STEP 2 - CREATE Logins WITH SERVER ROLES\PERMISSIONS STEP 3 - COPY LINKED SERVERS STEP 4 - COPY SERVER OPTIONS STEP 5 - COPY CREDENTIALS STEP 6 - COPY AGENT JOBS STEP 7 - COPY DB Mail STEP 8 - COPY CERTIFICATES STEP 9 […]

You rated this post out of 5. Change rating

2020-05-22 (first published: )

2,463 reads

Blogs

Measuring What Matters: Operationalizing Data Trust for CDOs

By

Trust is the currency of the data economy. Without it, even the most advanced...

A Small LLM Fail

By

Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...

SQL Server Versions: Out With the Old, In With the Supported

By

If your production SQL Servers are still running 2016 (or older) you’re basically banking...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

SSIS packages failing with a status "ended unexpectedly" (SSL/TLS timeout ?)

By Eric M Russell

We have an issue where SSIS packages are failing with a status of "ended...

SQL Newbie HELP: The query references an object that is not supported in distr..

By WBenning

Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...

Visit the forum

Question of the Day

Slip Streaming Installs

What does a slipstream installation mean?

See possible answers