My Azure ARM template development workflow
Writing infrastructure as code is pretty nice and I enjoy the declarative approach of defining what you want and letting...
2017-12-13
41 reads
My Azure ARM template development workflow
Writing infrastructure as code is pretty nice and I enjoy the declarative approach of defining what you want and letting...
2017-12-13
49 reads
Configure SQL Server 2017 on Linux with mssql-conf, the Linux way
The configuration of any system plays a vital role in its working efficiently. However, configuring a system needs not necessarily...
2017-12-13
801 reads
How to Get Started with Always Encrypted for Beginners Part 2
In this post we will pick up where we left off in Part 1, if you haven’t read that please...
2017-12-29 (first published: 2017-12-13)
1,757 reads
2017-12-13
328 reads
Is Your Database Overweight?
The obesity epidemic is much in the news these days. The list of health issues related to being overweight is...
2017-12-27 (first published: 2017-12-13)
1,784 reads
The Value of Consistent Design
Yesterday I wrote about best practices, illustrating that what may be an assumed technical design standard doesn’t fit every scenario....
2017-12-13
408 reads
Understanding Keys and Certificates with Transparent Data Encryption (TDE)
I’ve been taking a bit of a deep dive into understanding Transparent Data Encryption (TDE). As part of that I’ve...
2017-12-28 (first published: 2017-12-12)
3,303 reads
Power BI Custom Visuals Class (Module 81 – Social Network Graph)
In this module you will learn how to use the Social Network Graph Custom Visual. The Social Network Graph allows...
2018-01-02 (first published: 2017-12-12)
1,964 reads
BK’s Professional Learning Plans for 2018 #tsql2sday
With 2018 coming, I’ve thought about the question, “What do I want to be when I grow up?” I ask...
2018-01-01 (first published: 2017-12-12)
1,432 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...
Layanan Resmi BCA KCU TEGAL Telp:0821°7555°651
Telp/Wa 628217555651 Jl. A. R. Hakim No.2, Mangkukusuman, Kec. Tegal Tim., Kota Tegal, Jawa...
Kantor Resmi BCA KCU SALATIGA Telp:0817°825°533
Telp/Wa 62817825533 Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo, Kota Salatiga, Jawa Tengah 50711
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