Community Engagements Second Half of 2018 – It’s all about Biml
I have a couple of community engagements coming up in the second half of 2018 and I’d like to share...
2018-07-31
341 reads
Power BI Custom Visuals Class (Module 113 – Small Multiple Line Chart)
In this module you will learn how to use the Small Multiple Line Chart. The Small Multiple Line Chart allows...
2018-08-07 (first published: 2018-07-31)
2,288 reads
SQL Operations Studio: Keyboard Shortcuts, Actual Plans, & More
Last week I posted a quiz on SQL Operations Studio, a free, multi-platform tool from Microsoft. This tool is under active development and the features are improving by the day...
2018-07-31
42 reads
Should You Use Index Hints?
Watch this week’s post on YouTube
One of the things that the SQL Server query optimizer does is determine how to...
2018-08-16 (first published: 2018-07-31)
3,993 reads
Should You Use Index Hints?
Watch this week's video on YouTube
One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.
Usually it does...
2018-07-31
25 reads
Should You Use Index Hints?
Watch this week's video on YouTube
One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.
Usually it does...
2018-07-31
21 reads
Failed to join local availability replica to Availability Group – SQL Server error 41106 and 41158
When you configure SQL Server AlwaysOn Availability Group from management studio, it may fail with below error while joining secondary...
2018-07-31
15,821 reads
SQL Server Availability Group Auto Seeding Error
SQL Server Availability Group Auto Seeding is a wonderful thing, it saves database administrators time when setting up availability groups. ...
2018-07-30
736 reads
Coming Back After complete 3 Years
Friends/My Readers,
Its been a long i have been away from my blogging.When i see back Its exactly 3 yrs Today(30/July/2015...
2018-07-30
358 reads
Identifying HIPAA, PCI & SOX Data for Masking
Working for a company based in the UK (still currently a part of the EU) I had a lot of...
2018-08-15 (first published: 2018-07-30)
2,692 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