Working with PowerShell strings
Knowing how to manipulate strings is critical in any language. In this article, Greg Moore explains working with PowerShell strings.
2021-12-20
Knowing how to manipulate strings is critical in any language. In this article, Greg Moore explains working with PowerShell strings.
2021-12-20
RESTful APIs offer a straightforward way for businesses to work with external data and offer access to their own data. With more than 24,000 public APIs providing access to limitless data and the typical enterprise leveraging more than 200 applications, teams and developers need more efficient ways to query API data. With the CData API […]
2021-12-17
742 reads
You can do essential performance tuning on your SQL Server databases using a FREE toolkit!
2021-12-17
6,782 reads
Database professionals often work with more than one database platform. Grant Fritchey explains setting up and connecting to PostgreSQL database.
2021-12-17
SQL Monitor allows you to bring your whole estate into a single monitoring landscape that has a consistent interface, whether you have an all-Azure environment, or, more likely, a mixed database environment. Find out more, here!
2021-12-17
BETWEEN can be used in a SQL WHERE clause to filter on a range. Joe Celko explains the history of BETWEEN and also could be implemented.
2021-12-15
How different is it working as a DBA at an airline? Find out how your peers work in this series: DBAs at work. This episode features Deborah Thompson, Database Administrator at WestJet, Canada’s second largest airline.
2021-12-15
Learn how to work with SQL Agent Jobs in Azure Data Studio.
2021-12-13
10,251 reads
Demonstrates a cross-database PowerShell callback script for reporting on and auditing Flyway migrations, telling you which scripts were used to create each version, when they were run, who ran them and more.
2021-12-13
In this article we look at how ingestion will read data from the landing zone and push data into the Bronze layer of the Delta Lake tables for Azure Synapse Analytics.
2021-12-13
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