2022-02-28
11,425 reads
2022-02-28
11,425 reads
Continuous Compliance Automation aims strike a balance between baking compliance requirements into daily operations, and business demands for speed and agility. Redgate's Security Lead, will be joined by a panel of peers to discuss this mindset change and the impact it can have on your organization.
2022-02-28
In this article learn about how to use the new diagram view along with a schema view in Power BI to make Power Query online editing easier on report designers.
2022-02-28
Chaos engineering is all about breaking your application. Let us see what it is all about and how easy it is in Azure.
2022-02-25
7,773 reads
Find out how 2500+ of your database professional peers are meeting current and upcoming challenges in our free reports. We cover the Cloud, Security, Growing Environments and the value of monitoring for the entire organization.
2022-02-25
Python is a modern general-purpose programming language that's very useful for analytics. Sanil Mhatre demonstrates sentiment analysis with Python.
2022-02-25
Learn how to use Azure File and Blob storage with your applications.
2022-02-23
21,380 reads
The first step when getting started with MySQL is to get it installed and running. In this article, Robert Sheldon explains how to install it on Windows and create the first database and table.
2022-02-23
This article describes a route to adopting Flyway in order to bring management and control to a chaotic database development process. It is based on use of Flyway migrations to update a database from version to version, while maintaining object-level source scripts for tracking changes between versions.
2022-02-23
Learn about the Schema Compare feature in Azure Data Studio.
2022-02-21
10,502 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
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 two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers