10 questions with SQL Server Training tags

Sort by: Updated
0 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,353 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
10 questions
asked 2024-07-14T02:43:10.5333333+00:00
Jacob Shuster 0 Reputation points
commented 2024-07-25T10:46:41.32+00:00
AmaranS 4,015 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

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…

Azure SQL Database
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
68 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,600 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
10 questions
asked 2024-07-22T22:24:04.8633333+00:00
andrew omofonma 61 Reputation points
accepted 2024-07-23T17:36:56.54+00:00
andrew omofonma 61 Reputation points
1 answer One of the answers was accepted by the question author.

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.

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
10 questions
asked 2024-07-23T14:46:46.1766667+00:00
Jonathan Brotto 220 Reputation points
edited the question 2024-07-23T16:59:13.74+00:00
VarunTha 5,980 Reputation points Microsoft Vendor
1 answer

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,353 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
10 questions
asked 2024-07-12T15:57:37.2466667+00:00
Lewis, Frances 0 Reputation points
answered 2024-07-15T02:25:09.2366667+00:00
ZoeHui-MSFT 35,551 Reputation points
2 answers

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…

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
10 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
240 questions
asked 2024-05-31T19:07:21.7766667+00:00
Ric Oliva 0 Reputation points
edited the question 2024-07-03T04:21:10.9966667+00:00
Ryan Hill 27,031 Reputation points Microsoft Employee
2 answers

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.

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
10 questions
asked 2024-06-26T20:03:12.53+00:00
Danielle 0 Reputation points
commented 2024-07-01T06:44:06.22+00:00
LucyChenMSFT-4874 3,005 Reputation points
2 answers One of the answers was accepted by the question author.

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.

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
10 questions
asked 2024-06-11T18:15:45.0166667+00:00
Jonathan Brotto 220 Reputation points
accepted 2024-06-13T14:19:17.6+00:00
Jonathan Brotto 220 Reputation points
0 answers

Security Update for SQL Server 2019 RTM GDR (KB5035434) failed

Security Update for SQL Server 2019 RTM GDR (KB5035434) failed

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
10 questions
asked 2024-04-21T23:27:28.2766667+00:00
Roger Bergeron 10 Reputation points
edited the question 2024-04-22T06:03:13.3566667+00:00
SadiqhAhmed-MSFT 41,716 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

What does "Three and Four-part names? mean in "Elastic Query?

as question, would you please advise?

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
10 questions
asked 2024-02-18T15:06:42.2966667+00:00
Ho Ming Tam 45 Reputation points
edited the question 2024-03-27T09:04:42.29+00:00
AmaranS 4,015 Reputation points Microsoft Vendor
2 answers

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.…

SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
10 questions
asked 2024-02-03T06:44:21.65+00:00
Santosh Kumar Vellala 0 Reputation points Microsoft Employee
edited the question 2024-03-27T09:00:42.18+00:00
AmaranS 4,015 Reputation points Microsoft Vendor