Foundational Material: Microsoft SQL Server Book and Blogs From The Past
Erik Darling dusts off his favorite archival-quality bloggers and books.
2018-09-07
2,958 reads
SQL Server
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,583 reads
Placing a Mark in SQL Server's Transaction Log for Fall Back
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
What to Do When SQL Server is Slow
Brent Ozar's session for the PASS DBA Fundamentals virtual chapter.
2018-07-13
6,099 reads
How to Tell If Your SQL Server Has Too Much Memory
Brent shows what Perfmon counter to watch after your SQL Server restarts.
2018-06-15
5,646 reads
SQL Server Graph Databases – Part 5: Importing Relational Data into a Graph Database
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
Scheduling a PowerShell Script Using SQL Server Agent
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
39,818 reads
SQL Server on Amazon RDS vs SQL Server on Amazon EC2
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)
19,123 reads
Avoiding Unexpected Results with DATEDIFF in Year Comparisons
Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.
2018-04-09
1,748 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Automating Export of PowerQuery to SQL Server using DAX Studio...?
I wrote a PowerQuery that parses a table from a PDF, and I want...
Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.
Comments posted to this topic are about the item Attaching an SQL Server database...
Superseded Indexes
Comments posted to this topic are about the item Superseded Indexes
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers