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
GarryBargsley
T-SQL Tuesday #157- “End of Year Activity” – RECAP
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)
226 reads
T-SQL Tuesday #157 – Closing out 2022
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)
124 reads
T-SQL Tuesday #157 – “End of Year Activity”
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
SQL Temporal Tables — Gotcha!!!
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)
632 reads
Where did this database come from??
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)
551 reads
Restore HEADERONLY and FILELISTONLY
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)
852 reads
SQL Server In Place Upgrades
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,161 reads
“Done in 7 minutes” -SQL Server 2019 Install
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
21 reads
T-SQL Tuesday #154 – SQL Server 2022
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)
347 reads
Blogs
Using ThinOptics to Read Data
By Steve Jones
As I’ve aged, I find myself struggling to read many things in my life....
PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014
For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...
Set-Based vs Row-Based Database Code
By Kevin3NF
In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...
Forums
The Fake Speakers
Comments posted to this topic are about the item The Fake Speakers
Stairway to Database DevOps Level 3: Managing Code as a Team in Git
Comments posted to this topic are about the item Stairway to Database DevOps Level...
Reduction of installation time of sql server 2008 R2 Express
The installation of SQL Server 2008 R2 Express on a virtual machine takes around...
Ask SSC