Articles

External Article

Summit 2022 Call for Speakers Now Open

Share your knowledge and insights at the world's largest gathering of data platform professionals! The PASS Data Community Summit conference is going hybrid this year, and whether you're planning to attend in-person in Seattle or online, this is your chance to reach a global audience and advance your career as a speaker. If you're an expert in a data-related topic, we want to hear from you. Speakers of all experience levels are welcome to submit a proposal and the Call for Speakers is open until March 31. Registration also opens on March 24, so don't miss your chance to register for Summit's homecoming in Seattle at early bird pricing.

2022-03-16

External Article

What’s new in SQL Monitor? Tagging and Current Activity Page (minor release v12.1)

We've released a minor version of SQL Monitor, v12.1, that includes two exciting new features: ‘Tagging’ and a ‘Current Activity’ page. In a nutshell: tags allow you to record aspects of a server so that you have information at your fingertips, and the Current Activity page directly queries the monitored server when you open it to get the most up-to-date information possible. It’s all part of our commitment to making SQL Monitor the best monitoring tool out there!

2022-03-14

2 reads

SQLServerCentral Article

Exploring Knowledge Center in Azure Synapse Analytics

Introduction Azure Synapse Analytics is an enterprise analytics service that brings together popular data warehouse technologies and big data systems together. It provides SQL for enterprise data warehousing, Spark technologies for big data, Data explorer for analytics, Pipeline for data integration and ETL and ELT, and other popular Azure services including Power BI, CosmosDB, and […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2022-03-11

1,471 reads

External Article

SQL Prompt ALT S Magic

SQL Prompt's new command palette provides a fast way to navigate the tool's functionality via a single keyboard shortcut: ALT+S. Phil Factor explains how you can use the command palette to find and execute SQL Prompt functionality and common SSMS commands, as well as search for database objects.

2022-03-11

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