Representing XML data in SQL Server
In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.
2020-04-24 (first published: 2018-08-07)
6,541 reads
In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.
2020-04-24 (first published: 2018-08-07)
6,541 reads
How many times have you had a programmer come to you and say they want you (the DBA) to restore their database to sometime prior to when they accidentally corrupted it? If you are doing FULL transaction logging you can do a point in time recovery to restore the database to just prior to when the corruption occurred. But in order to do that you need to know exactly when the programmer corrupted the data, which in a lot of cases is not known down to the second.
2018-07-24
4,291 reads
2018-07-20
5,252 reads
Brent Ozar's session for the PASS DBA Fundamentals virtual chapter.
2018-07-13
6,099 reads
Brent shows what Perfmon counter to watch after your SQL Server restarts.
2018-06-15
5,646 reads
In the final article of this series, Robert Sheldon shows how to move from a relational structure to a graph structure using the Graph Database feature.
2018-05-23
3,068 reads
This article will give you insight to understand how you can schedule a powershell script you have written using SQL Server Agent.
2018-05-22
38,367 reads
Exploring briefly the difference between using Amazon Machine Images running SQL Server and using SQL Server instances on Amazon's Relational Database Service.
2020-09-18 (first published: 2018-04-12)
18,468 reads
Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.
2018-04-09
1,722 reads
Everyone needs to learn about these hardware bugs and apply patches as soon as possible.
2018-01-29 (first published: 2018-01-05)
8,421 reads
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers