Configure Always on AG with SQL 2017
One of the new features that we have with SQL 2017 is that you no longer need a Windows cluster to enable the AlwaysOn feature with SQL server (remember...
2017-12-04
65 reads
Blog Posts
Configure Always on AG with SQL 2017
One of the new features that we have with SQL 2017 is that you no longer need a Windows cluster...
2017-12-04
24,988 reads
Monitoring and Alerts with Azure SQl Database
Continuing with the Azure SQL Database theme, in this short video David demonstrates how to setup alerts for an Azure SQL...
2017-12-04 (first published: 2017-11-22)
1,185 reads
PASS Linux for the SQL Server DBA Webinar – Dec 13
Join me for a session on Linux administration for the SQL Server DBA as part of the PASS SQL Server...
2017-12-04 (first published: 2017-11-26)
1,138 reads
SQL Homework – December 2017 – View the log
Last homework of the year. Last month was to create a view. This month it’s time to take a look...
2017-12-04
320 reads
System.ConsoleColor error while running powershell in SQL agent job step
Issue: While running powershell in SQL agent job step, I am getting below error: –
A job step received an error...
2017-12-04
1,010 reads
The Myth Of Tomorrow
“We’ll fix it in the mix.”
“It’s good enough for right now.”
“We’ll worry about that later.”
“Your check is in the mail.”
Of...
2017-12-04
741 reads
T-SQL Tuesday #97 – Setting learning goals for 2018
This is my first opportunity hosting a T-SQL Tuesday and am super excited!!T-SQL Tuesday is the brainchild of well respected SQL Guru...
2017-12-04
959 reads
Why I Use AdventureWorks for Demos
I know that when some people see AdventureWorks, their vision turns all red around the edges, their blood pressure spikes...
2017-12-04
381 reads
Enterprise Analysis Services Development: Interview with Alberto Ferrari and Marco Russo
Between sessions at the PASS Summit, I had the privilege of interviewing Alberto Ferrari and Marco Russo; SSAS Maestros and...
2017-12-03
442 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