Join me at VS Live – Anaheim
We’re just a month away from Visual Studio Live in Anaheim where I’ll be speaking along with many others. Join...
2017-09-19
466 reads
Blog Posts
Power BI Custom Visuals Class (Module 67 – Impact Bubble Chart)
In this module you will learn how to use the Impact Bubble Chart Custom Visual. The Impact Bubble Chart is...
2017-09-19 (first published: 2017-09-05)
2,425 reads
PowerShell Modules Central - Share with community - What PowerShell modules are you using?
Like the blog post title states this is all about sharing with others! My idea is to share with the community which PowerShell modules you are using.
PowerShellModulesCentral is a...
2017-09-19
18 reads
SQL Server DB Migration – Cloning a database to another collation
Database migration is a vital task in any environment, complex or otherwise. Seamless migrations are the goal but the efforts...
2017-09-19
343 reads
When Deadlocks Become Art
We’ve all had to solve deadlock issues. Identify the two conflicting pieces of code, work out an appropriate change to...
2017-09-19
706 reads
Adding Replicas into existing Availability Groups
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-09-18
397 reads
dataMinds Connect 2017 (win a ticket!)
Within two weeks the wait is over: the first edition of dataMinds Connect! For those of you wondering what I’m...
2017-09-18
343 reads
DevOps Basics–Git Clients
This is also a part of a basic series on git and how to use it.
There are lots of git...
2017-09-18 (first published: 2017-09-07)
1,888 reads
Experimenting with VSCode instead of the ISE
I’ve been playing with PowerShell here and there, learning a few things. As I use the dbatools project, or
I...
2017-09-18
540 reads
Generate Markdown Table of Contents based on files within a folder with PowerShell
Last week I was talking with Constantine Kokkinos (b | t) about generating a Table Of Contents (TOC) for a GitHub repository.
He wrote a cool blog post - Generating...
2017-09-18
33 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
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.beerWhat happens? See possible answers