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 as much as I did, and see if there is anything you can add to your end-of-year work. Blogger Post Rob Farley https://lobsterpot.com.au/blog/2022/12/13/happy-end-of-year/ Chad Callihan Read More …
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 of tasks I work on as the year draws to a close. Date Dimension Tables Several platforms in our organization each year need to add dates Read More …
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 procedures you run? Do you clean up documentation? Do you just take time off and hope someone else does the work? Some Examples: Purge log data Read More …
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, a few are in use, and a few are coming down the pipeline for new projects. If you have not heard of Temporal Tables, you can Read More …
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? Does this look familiar? Databases listed with 1, 2, 3, 4? What do those databases represent? Where did those databases come from? Would you believe me Read More …
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 for restoring a SQL database. Have you ever come across a BAK file or LOG file where you were unsure what data was contained in the Read More …
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 and son. Let’s talk more about SQL Server Installations since my previous post covered a similar topic. In this post, I felt I would stick with Read More …
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 SQL Server for a quick test of a feature, stand up a fresh instance for a team, or automation? Like anything with technology, there are multiple Read More …
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 Server 2022 and plans for the RTM release in calendar year 2022. My post for T-SQL Tuesday #154 is going to be a demo of the Read More …
Hello, dear blog reader. This week’s blog is coming to you from the home office. Finally, my son is back in school, and the house has some peace. For this blog, I thought I would write about a situation that I ran across recently. Problem Did you know that log shipped databases do not have Read More …
