DataOnWheels

Steve Hughes is the Director of Consulting at 3Cloud. In my current role, I manage the West and Central Data & AI consultant team at 3Cloud. I did a similar role at Pragmatic Works before our merger with 3Cloud. I focus on team development and company growth with this role. In my previous role as a Principal Consultant Lead at Pragmatic Works, I focused on designing solutions for customers on Microsoft technologies including SQL Server, Power Platform, and Azure.

Kristyna Hughes is the Team Lead for BI at GlobalTranz. I have played an instrumental role in moving our company from 3 different reporting platforms to hosting our reporting within Power BI. I provide advice on security structures within the platform, manage the gateways, create and implement design strategies, train, and build reports for both our internal operations committee and external customers. I will also be aiding in embedding Power BI within an unified TMS and ensuring various levels of security are maintained within the embedded reports.

Blogs

SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL

By

Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...

Yippee-Kai-Yay 2027 Summit in Denver

By

Next year the PASS Data Community Summit is in DENVER! and London, but Denver...

PASS Data Community Summit 2026

By

Yesterday was the first day of sessions at the PASS Data Community Summit (after...

Read the latest Blogs

Forums

Pay for Performance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Pay for Performance, which is...

Switching Schemas I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Switching Schemas I

Enforcing Unique Customer Emails When Duplicates Already Exist

By Imran2629

Comments posted to this topic are about the item Enforcing Unique Customer Emails When...

Visit the forum

Question of the Day

Switching Schemas I

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 one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beer
What happens?

See possible answers