Moving Objects to a New Schema
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-09-28 (first published: 2018-09-20)
6,691 reads
Azure Integration Options and Overview
Today I’d like to talk about Azure integration services that you can leverage within the platform. Integration services allow data...
2018-10-01 (first published: 2018-09-20)
1,502 reads
Rescheduled Performance Troubleshooting Webinar
With Hurricane Florence no longer a hurricane, we have rescheduled the webinar for next Wednesday, September 26, 2018.
Free sign up...
2018-09-19
222 reads
Why Customers Are Looking At Azure
As a Principal Consultant with Pragmatic Works, I have many conversations with customers about moving to Azure. As a Consulting...
2018-09-19
325 reads
Apply for the 2019 Idera ACE Program
Sharing this before I forget, Idera is taking applications for their 2019 ACE Program. If you’re wanting to do more...
2018-09-19
772 reads
Public Service Announcement: check your backup notifications
The Azure cloud platform lost a data centre for a number of hours recently due to inclement weather. This affected...
2018-09-19
246 reads
What is Projectsv13 in SQL Change Automation?
I got this question recently from someone that was evaluating the SQL Change Automation client in Visual Studio. After setting...
2018-09-19
1,729 reads
All about PASS Summit 2018
Here are the things you must/should probably know about PASS Summit 2018, as told by me. First Timers Read this...
2018-09-19
258 reads
Three skills to look for in a technology partner
SQL Treeo’s founder and CEO, Danny Riebeek, reflects on his 20+ years in the IT industry. Q: What prompted you...
2018-09-19
304 reads
Overview of SQL Joins in SQL Server
The ability to combine results from related rows from multiple tables is an important part of relational database system design. In SQL...
2018-09-19
644 reads
Blogs
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat Telp BCA KCP Jatiwangi Hub/Wa. 0817-819-444
Jl. Jend. A. Yani No.224, Jatiwangi, Kec. Jatiwangi, Kabupaten Majalengka, Jawa Barat 45454
Alamat BCA KCP Rengasdengklok Hub/Wa. 0817-819-444
Jl. Raya R.Dengklok No.27, RT.049/RW.011, R.Dengklok Sel., Kec. R.Dengklok, Karawang, Jawa Barat 41352
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