Skip to content
  • Home
  • About
  • Contact Me
  • Resources
  • SQL Memes
  • Twitter
  • LinkedIn
Search
Close

MlakarTechTalk

All Things Data | InfoSec | Privacy | Technology

Category: SQL Server

SQL Server 2019 EOL – End of Life

SQL Server 2019 EOL – End of Life

March 31, 2025March 31, 2025 Jeff MlakarLeave a comment

Microsoft SQL Server 2019 has surpassed the end of mainstream support on Feb 28, 2025. It’s the end of an era and a new beginning for your SQL Server instances.

Feature Image Attribution (img/license)

Read More »
T-SQL Tuesday #182 – Integrity and Database Corruption

T-SQL Tuesday #182 – Integrity and Database Corruption

January 14, 2025January 14, 2025 Jeff MlakarLeave a comment

The topic for this month’s T-SQL Tuesday #182 hosted by Rob Farley (Blog) is integrity. Read on to see my thoughts on integrity in the world of databases – in particular database corruption.

Read More »
T-SQL Tuesday #177 – Managing Database Code

T-SQL Tuesday #177 – Managing Database Code

August 13, 2024August 13, 2024 Jeff MlakarLeave a comment

The topic for this month’s T-SQL Tuesday #177 hosted by Mala Mahadevan (Blog) is regarding how we manage our database repository. Read on to see my journey of using different repositories and source control for my code.

Read More »
T-SQL Tuesday #174 – My Favorite Job Interview Question

T-SQL Tuesday #174 – My Favorite Job Interview Question

May 14, 2024May 15, 2024 Jeff Mlakar5 Comments

The topic for this month’s T-SQL Tuesday #174 hosted by Kevin Feasel (Blog) is regarding our favorite job interview question. Read on to see my thoughts on job interview questions from both sides of the table…

Read More »
Maintaining Healthy SQL Server Hygiene: The Importance of Patching SQL Server

Maintaining Healthy SQL Server Hygiene: The Importance of Patching SQL Server

April 30, 2024April 30, 2024 Jeff Mlakar1 Comment

Last November marked the 20 year anniversary of Microsoft’s Patch Tuesday. Like brushing your teeth or taking showers, keeping your SQL Server patched is good hygiene and a best practice. Let’s explore why in this post.

Feature Image Attribution

Read More »
T-SQL Tuesday #171 – Describe the Most Recent Issue You Closed

T-SQL Tuesday #171 – Describe the Most Recent Issue You Closed

February 13, 2024February 14, 2024 Jeff Mlakar3 Comments

The topic for this month’s T-SQL Tuesday #171 hosted by the great and powerful Brent Ozar (Blog) is about our most recent closed issue.

Read More »
T-SQL Tuesday #167 – Encryption and Data Protection

T-SQL Tuesday #167 – Encryption and Data Protection

October 10, 2023October 10, 2023 Jeff Mlakar2 Comments

The topic for this month’s T-SQL Tuesday #167 hosted by Matthew McGiffen (Blog / Twitter) is about encryption and data protection in SQL Server.

Read More »
Working with the SQL Server STRING_AGG Function

Working with the SQL Server STRING_AGG Function

August 31, 2023August 31, 2023 Jeff Mlakar1 Comment

Often when generating dynamic sql we must add some separator values in the string(s) we build. A function delivered way back in 2017 called STRING_AGG is a simple way to do this. Let’s look at some examples.

Feature image / license

Read More »
How to Monitor Windows Event Log for Reboots

How to Monitor Windows Event Log for Reboots

May 12, 2020May 11, 2020 Jeff MlakarLeave a comment

When was my server last rebooted? Who shutdown my machine? Read on to see how easy it is to find out using the Windows Server Event Logs.

Feature Image / License

Read More »
How to Load SQL Server Error Log into Table for Analysis

How to Load SQL Server Error Log into Table for Analysis

February 14, 2020February 14, 2020 Jeff Mlakar1 Comment

A while ago I wrote a post about the SQL Server error log. Today I will show how to load the SQL error log into a table for analysis via T-SQL.

Read on to see a couple of ways to traverse all the error logs and load into a table for analysis.

Read More »

Posts navigation

Older Posts

Subscribe to MlakarTechTalk

Just enter your email below and you're part of the club. I promise not to spam you.

Join 66 other subscribers

Recent Posts

  • SQL Server 2019 EOL – End of Life March 31, 2025
  • Top Passwords in 2024 February 28, 2025
  • T-SQL Tuesday #182 – Integrity and Database Corruption January 14, 2025

Top Posts & Pages

  • My Project: Wired House for Ethernet Cat 6
    My Project: Wired House for Ethernet Cat 6
  • My Amateur Backyard Fireworks Show - 2021
    My Amateur Backyard Fireworks Show - 2021
  • MSDTC Troubleshooting - Basic Guide
    MSDTC Troubleshooting - Basic Guide
  • How to Survive the Office Bully
    How to Survive the Office Bully
  • How to Load SQL Server Error Log into Table for Analysis
    How to Load SQL Server Error Log into Table for Analysis
  • What is the Difference Between the Internet and the World Wide Web?
    What is the Difference Between the Internet and the World Wide Web?
  • MSDTC Troubleshooting – Basic Guide Part 2
    MSDTC Troubleshooting – Basic Guide Part 2
  • SQL Server 2019 EOL - End of Life
    SQL Server 2019 EOL - End of Life
  • How to Move and Configure tempdb Files
    How to Move and Configure tempdb Files

Archives

  • March 2025 (1)
  • February 2025 (1)
  • January 2025 (1)
  • October 2024 (1)
  • September 2024 (1)
  • August 2024 (1)
  • July 2024 (1)
  • June 2024 (1)
  • May 2024 (1)
  • April 2024 (1)
  • March 2024 (1)
  • February 2024 (1)
  • January 2024 (1)
  • December 2023 (1)
  • November 2023 (1)
  • October 2023 (1)
  • September 2023 (1)
  • August 2023 (1)
  • July 2023 (1)
  • June 2023 (1)
  • May 2023 (1)
  • April 2023 (1)
  • March 2023 (1)
  • February 2023 (2)
  • August 2021 (1)
  • January 2021 (1)
  • November 2020 (1)
  • September 2020 (1)
  • May 2020 (2)
  • February 2020 (1)
  • January 2020 (1)
  • November 2019 (1)
  • October 2019 (3)
  • August 2019 (1)
  • July 2019 (1)
  • June 2019 (1)
  • May 2019 (4)
  • April 2019 (5)
  • March 2019 (4)
  • February 2019 (2)
  • January 2019 (3)
  • December 2018 (3)
  • November 2018 (5)
  • October 2018 (6)
  • September 2018 (4)
  • August 2018 (4)
  • July 2018 (3)
  • June 2018 (2)
  • May 2018 (2)
  • March 2018 (3)
  • February 2018 (3)
  • January 2018 (2)
  • December 2017 (2)
  • November 2017 (1)
  • October 2017 (3)
  • September 2017 (3)
  • August 2017 (3)
  • July 2017 (4)
  • June 2017 (1)
  • April 2017 (1)
  • March 2017 (2)
  • January 2017 (2)
  • December 2016 (1)
  • October 2016 (2)
  • September 2016 (2)

Categories

  • Databases (4)
  • Other (5)
  • Privacy (15)
  • Security (16)
  • Soft Skills (11)
  • SQL Server (64)
    • Admin (18)
    • Certification (1)
    • PowerShell (1)
    • SQL Saturday (13)
    • SQL Server 2005 (1)
    • t-sql (6)
    • tsql2sday (17)
    • Virtualization (2)
    • Windows Server (4)
  • Technology (15)
    • Network (4)
  • Uncategorized (1)

Tags

#tsql2sday ACM blogiversary bullet journal database corruption data privacy Data Privacy Day death march diagnostic DMCA DML dtc EFF encryption environmental Environmental Troubleshooting ethernet fireworks GDPR Hour of Code Internet interview management memes msdtc network password manager performance Privacy project Project Management Raleigh Security by Obscurity Signal speaking SQL PASS SQL Saturday sql server t-sql troubleshooting virtualization VMware VPN Windows Server wired

RSS MlakarTechTalk RSS Feed

  • SQL Server 2019 EOL – End of Life April 1, 2025
  • Top Passwords in 2024 March 1, 2025
  • T-SQL Tuesday #182 – Integrity and Database Corruption January 15, 2025
  • Today is Halloween! November 1, 2024
  • Password Madness! October 1, 2024
  • T-SQL Tuesday #177 – Managing Database Code August 14, 2024
  • My Journey 2024 August 1, 2024
  • Running a Successful Meeting – Don’t Punish the Punctual June 30, 2024
  • T-SQL Tuesday #174 – My Favorite Job Interview Question May 15, 2024
  • Maintaining Healthy SQL Server Hygiene: The Importance of Patching SQL Server May 1, 2024
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Subscribe to MlakarTechTalk

Enter your email address to subscribe to MlakarTechTalk and receive an email notifications of new posts.

Join 66 other subscribers
Nord VPN
PIA Award Winning VPN
Dreamhost
Proudly powered by WordPress | Theme: Nucleare by CrestaProject.
Back to top