Articles

External Article

Retrieving MySQL data from within Python

The approach you take when accessing MySQL will depend on the programming language you’re using and the connector you choose for interfacing with the database. Whatever approach you take, the same basic principles generally apply to each environment. You must establish a connection to the database and then issue the commands necessary to retrieve or modify the data.

2023-05-24

SQLServerCentral Article

How to Generate Images with AI and Store them in SQL Server using Python and DALL·E

Introduction In this article, we will learn how to generate images with AI. This time we will work with DALL·E. DALL·E is an image generator using AI. You just need to provide a description and DALL·E will generate the image: In this article we will learn these topics: First, we will learn what is DALL·E […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2023-05-22

4,074 reads

External Article

PostgreSQL 101: The 10 key differences between SQL Server & PostgreSQL

Join us for the second webinar in our PostgreSQL 101 series.

As a SQL Server developer or DBA, you have a broad skill set and have become accustomed to interacting with the larger #SQLFamily community. Now, by choice or necessity you've begun to explore PostgreSQL and things feel oddly familiar and foreign at the same time.

Join Ryan Booze on May 25th to find out the things that often trip up SQL Server users when they first start exploring PostgreSQL.

2023-05-22

Blogs

Should You Use CHOOSE(): #SQLNewBlogger

By

I was experimenting with CHOOSE() recently after I was asked a question. In a...

T-SQL Tuesday #204 – Are blogs still relevant? (Roundup)

By

I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...

Build vs Buy AI: When to adopt, partner, build or buy

By

Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...

Read the latest Blogs

Forums

Weird problem altering logins with sysadmin account

By Brandie Tarvin

Has anyone ever seen this before? I have sysadmin permission on a server. I...

Switching Schema II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Switching Schema II

A Practical Approach to Automating SQL Server Email Notifications

By Kunal Rathi

Comments posted to this topic are about the item A Practical Approach to Automating...

Visit the forum

Question of the Day

Switching Schema II

I run this query:

SELECT 
 s.name AS schemaname
 , o.name AS objectname
 FROM sys.objects o
 INNER JOIN sys.schemas s ON s.schema_id = o.schema_id
 WHERE o.name = 'Beer'
I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beer
What happens?

See possible answers