Microsoft Applied Skill 4 - Failure to create Databases 1-4
While attempting the "Migrate SQL Server Workloads to Azure SQL Database" it failed to create Databases: DB1, DB2, DB3, and DB4. While DB5 was a partial. Has anyone else had this happen to them? What steps have you taken to resolve this…
How to figure out the total number of doses within a time span given to a client as dose are being added and stopped.?
If the cadence values are different, even if the dates overlap the records must be separate. If an order for the same dose and cadence value (including nulls) starts on the same day or the next day (+or-1 day) the record should continue. outlook of…
I have a query where I like to run in another server and database
I opened a query in another database, and I would like to run it in another window. Is there a way to do that while keeping the same query window? For example server A database Q to server B database Y.
Does Microsoft offer professional administrator sql server training with labs for a database administrator?
How can I find sql server administration training with labs for new DBA taught on SqlServer 2019 or later.
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
Typo on page
Hi, where do we give feedback for a typographical error on a MS Learn page? https://learn.microsoft.com/en-us/training/modules/sql-server-2022-performance-enhancements/3-memory-feedback-exercise Item 6. IsMemoryGrangFeedbackAdjusted should be…
How can I change the data mapping?
I'm importing a file via excel into a table in SQL. I keep getting this error about the date time. I've tried changing the date format in Excel and nothing helps. Also I can't change the format type either.
![](https://techprofile.blob.core.windows.net/images/J-cKqdzNMkWeJv8idBgCcQ.png?8DC812)
Search all columns with the same where clause
Is there a way to search all columns with the same where clause? It is one piece of text and ideally not write a long where with or statement would be nice.
Security Update for SQL Server 2019 RTM GDR (KB5035434) failed
Security Update for SQL Server 2019 RTM GDR (KB5035434) failed
![](https://techprofile.blob.core.windows.net/images/84eXqZh4KEGayKJ9OOltlQ.png?8DBCF1)
What does "Three and Four-part names? mean in "Elastic Query?
as question, would you please advise?
![](https://techprofile.blob.core.windows.net/images/SMwAf34s8UKP_EKjzMfzIQ.png?8DC0A3)
Is there a mistake in the depiction of EXCEPT Operator using Venn Diagram in the Advanced T-SQL Training
I believe there is a mistake in the Venn Diagram that depicts the usage of EXCEPT Operator in the Advance T-SQL Training. The result set should give "Silver/Black" also in the output as this is in the First Result Set and NOT in the Second One.…
![](https://techprofile.blob.core.windows.net/images/gxLmyUjNrk2ZFhgi2ujz0g.png?8DA6FE)