100 Blog Posts Milestone
Good morning dear reader, Long time no talk. It has been a jam-packed and chaotic first half of 2023 for my family and me. The first quarter of the...
2023-07-25
43 reads
Good morning dear reader, Long time no talk. It has been a jam-packed and chaotic first half of 2023 for my family and me. The first quarter of the...
2023-07-25
43 reads
I am humbled that many posts were submitted for T-SQL Tuesday #157. There is such a wide range of plans to wind down 2022. So enjoy the posts below...
2022-12-30 (first published: 2022-12-20)
231 reads
This month’s T-SQL Tuesday is being hosted by ME. The subject I chose is “What are your year-end activities?” My post for T-SQL Tuesday #157 will outline some examples...
2022-12-21 (first published: 2022-12-13)
128 reads
Welcome to the final T-SQL Tuesday for 2022. My ask is, what do you have planned for end-of-year activities for your SQL environment? Do you have annual processes or...
2022-12-06
2 reads
Hello, again reader… Today, I will discuss a gotcha I ran across with SQL Server Temporal Tables. In my day-to-day environment, we do not use Temporal Tables widely. However,...
2022-11-21 (first published: 2022-11-01)
676 reads
Happy Tuesday, blog reader. Have you ever come across a database you had not seen before or was in a different naming convention than you are used to seeing?...
2022-10-31 (first published: 2022-10-18)
556 reads
Good day reader. This post is coming to you from a busy week in Texas, where the heat is starting to subside. The week’s topic will cover two options...
2022-10-17 (first published: 2022-10-04)
864 reads
Good morning dear blog reader. Today’s episode is fresh from a great weekend with the family. It is always fun to go on a road trip with my wife...
2022-09-27
1,402 reads
This month’s T-SQL Tuesday is being hosted by Glenn Berry , and the subject he chose is “SQL Server 2022.” Microsoft has recently released the RC0 version of SQL...
2022-09-26 (first published: 2022-09-13)
353 reads
This blog comes to you from the home office after three days of caring for my sick six-year-old son. Yay for stomach bugs… Have you ever needed to install...
2022-09-20
22 reads
By DataOnWheels
Over the past couple of months, I have started losing my ability to talk...
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
I am trying to set a date filter on several large transaction tables to...
Comments posted to this topic are about the item Do you listen to music...
I have a job running each night starting at 4:30AM and usually finishing at...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers