DevOps Debugs the Demo
I had my 24 Hours of Pass session today, Database DevOps to Ensure Compliance, and my demo broke. At least,...
2018-06-29 (first published: 2018-06-12)
2,157 reads
Power BI Custom Visuals Class (Module 107 – Advance Card)
In this module you will learn how to use the Advance Card. The Advance Card is similar to the native...
2018-06-26 (first published: 2018-06-12)
2,832 reads
Temporary Post Used For Theme Detection (84fc925e-61af-4c19-b75b-9b99021b1635 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (e4f4591b-a7d5-4be4-937e-8d6230ec51d8 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2018-06-12
940 reads
10 Years Young
It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the previous year’s PASS Summit and started I-380 PASS,...
2018-06-12
29 reads
10 Years Young
It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the previous year’s PASS Summit and started I-380 PASS,...
2018-06-12
24 reads
10 Years Young
It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the previous year’s PASS Summit and started I-380 PASS,...
2018-06-12
32 reads
10 Years Young
It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the previous year’s PASS Summit and started I-380 PASS,...
2018-06-12
40 reads
10 Years Young
It was early in 2009 – I don’t remember the date exactly. A group of us had gotten together after the...
2018-06-12
326 reads
It’s Azure T-SQL Tuesday #103
I’m slightly surprised that there haven’t been more invitations about Azure, with the main development branch of SQL Server being...
2018-06-12
332 reads
Getting Started with Mssql-cli tool
A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements and business...
2018-06-12
267 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
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