15 questions with SQL Server Training tags

Sort by: Updated
Updated Created Answers
0 answers

Defender for SQL Servers - DCRs, LAW and settings

Hello all, we have activated Defender for SQL Servers in a customer environments. When we have enabled Defender for SQL, it automatically created some resources (as documented by MS) specifically: DCR: MicrosoftDefenderForSQL--dcr DCRA:…

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.
15 questions
asked 2024-08-04T07:47:51.4966667+00:00
vincent manzari 41 Reputation points
edited the question 2024-09-09T12:45:11.38+00:00
SadiqhAhmed-MSFT 44,591 Reputation points Microsoft Employee
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,695 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.
15 questions
asked 2024-07-12T15:57:37.2466667+00:00
Lewis, Frances 0 Reputation points
edited a comment 2024-08-27T05:40:30.2666667+00:00
Mahesh Kurva 5 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

is there a describe or show function in SQL server 2022?

I have a query in the SQL 2005 server we use for archive retrieval and a similar query in our 2019 box works with no issue. Declare @POnumber varchar(max) = '6801415970' SELECT * FROM dbo.SA15 WHERE PONO = /*'6801415970'*/ @POnumber SELECT * FROM…

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.
15 questions
asked 2024-08-08T13:47:29.87+00:00
Jonathan Brotto 400 Reputation points
edited the question 2024-08-10T19:00:18.55+00:00
pnaroju 3,125 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

can I declare a variable after the query

I have a variable that is a list that I will split and but not anting to put it on top of the SQL file as I like to see my query before.

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,695 questions
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.
92 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,626 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.
15 questions
asked 2024-08-08T15:13:00.9633333+00:00
Jonathan Brotto 400 Reputation points
accepted 2024-08-09T14:24:15.3333333+00:00
Jonathan Brotto 400 Reputation points
1 answer One of the answers was accepted by the question author.

declare a variable with multiple items like an in for a where clause?

Is it possible to declare a variable with multiple items like an in for a where clause?

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,695 questions
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.
92 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,626 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.
15 questions
asked 2024-08-08T14:19:55.0666667+00:00
Jonathan Brotto 400 Reputation points
commented 2024-08-09T02:16:28.26+00:00
AmaranS 6,020 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Find duplicate rows in SQL

I don't mind the approach but was I was looking for a PO within my database and found duplicate rows. Like, have a way to catch these.

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.
15 questions
asked 2024-07-30T18:52:30.0133333+00:00
Jonathan Brotto 400 Reputation points
accepted 2024-08-02T13:10:04.3633333+00:00
Jonathan Brotto 400 Reputation points
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,695 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.
15 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 6,020 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.
92 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,626 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.
15 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.
15 questions
asked 2024-07-23T14:46:46.1766667+00:00
Jonathan Brotto 400 Reputation points
edited the question 2024-07-23T16:59:13.74+00:00
VarunTha 7,810 Reputation points Microsoft Vendor
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.
15 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.
250 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 28,091 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.
15 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 4,430 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.
15 questions
asked 2024-06-11T18:15:45.0166667+00:00
Jonathan Brotto 400 Reputation points
accepted 2024-06-13T14:19:17.6+00:00
Jonathan Brotto 400 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.
15 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 44,591 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.
15 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 6,020 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.
15 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 6,020 Reputation points Microsoft Vendor