#sqlserver — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlserver, aggregated by home.social.
-
Dew Drop – May 14, 2026 (#4668)
https://www.alvinashcraft.com/2026/05/14/dew-drop-may-14-2026-4668/
#dotnet #windowsdev #ai #webdev #csharp #cloud #visualstudio #vscode #appdev #sqlserver #dewdrop
-
If I'm remembering correctly, the primary SQL Hosts at my employer date back to May 2023 when new hardware was purchased.
We have not run Windows Updates or installed a Cumulative Update for SQL Server on these machines. Not ever.
I've done extensive testing in our non-PROD environments, and scheduled dozens of maintenance windows for the PROD environment. But something (and it's never me) always 'gets in the way'.
-
If I'm remembering correctly, the primary SQL Hosts at my employer date back to May 2023 when new hardware was purchased.
We have not run Windows Updates or installed a Cumulative Update for SQL Server on these machines. Not ever.
I've done extensive testing in our non-PROD environments, and scheduled dozens of maintenance windows for the PROD environment. But something (and it's never me) always 'gets in the way'.
-
If I'm remembering correctly, the primary SQL Hosts at my employer date back to May 2023 when new hardware was purchased.
We have not run Windows Updates or installed a Cumulative Update for SQL Server on these machines. Not ever.
I've done extensive testing in our non-PROD environments, and scheduled dozens of maintenance windows for the PROD environment. But something (and it's never me) always 'gets in the way'.
-
If I'm remembering correctly, the primary SQL Hosts at my employer date back to May 2023 when new hardware was purchased.
We have not run Windows Updates or installed a Cumulative Update for SQL Server on these machines. Not ever.
I've done extensive testing in our non-PROD environments, and scheduled dozens of maintenance windows for the PROD environment. But something (and it's never me) always 'gets in the way'.
-
If I'm remembering correctly, the primary SQL Hosts at my employer date back to May 2023 when new hardware was purchased.
We have not run Windows Updates or installed a Cumulative Update for SQL Server on these machines. Not ever.
I've done extensive testing in our non-PROD environments, and scheduled dozens of maintenance windows for the PROD environment. But something (and it's never me) always 'gets in the way'.
-
#sqlserver #azure #ai #git #copilot #devops
After 8 months working intensively with AI as a cloud DBA, I see it less as a magic tool and more as a powerful amplifier. With context, versioning, instruction files, agents, and human supervision, AI can greatly improve automation, documentation, and troubleshooting. -
How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide) This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS. What is Microsoft SQL Server? Microsoft SQL ... Continued 👉 #apache #selfhosting #mssql #freetds #selfhosted #sqlserver
-
How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide) This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS. What is Microsoft SQL Server? Microsoft SQL ... Continued 👉 #apache #selfhosting #mssql #freetds #selfhosted #sqlserver
-
Dew Drop Weekly Newsletter 482 - Week Ending May 8, 2026
#dewdrop #newsletter #javascript #css #azure #blazor #cpp #xaml #windev #csharp #dotnet #ai #mcp #agile #devops #dotnetmaui #appdev #podcasts #m365 #data #sqlserver #powershell #cli
-
How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)
This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #sqlserver #apache #selfhosted #selfhosting #mssql #freetds -
How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)
This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #sqlserver #apache #selfhosted #selfhosting #mssql #freetds -
How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)
This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #sqlserver #apache #selfhosted #selfhosting #mssql #freetds -
How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)
This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #sqlserver #apache #selfhosted #selfhosting #mssql #freetds -
How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)
This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #mssql #selfhosting #selfhosted #freetds #sqlserver #apache -
How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)
This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #mssql #selfhosting #selfhosted #freetds #sqlserver #apache -
How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)
This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #mssql #selfhosting #selfhosted #freetds #sqlserver #apache -
Blog post from the past:
In which I go over potential reasons for why some special characters end up corrupted and displayed as question marks, squares or something completely different in SQL Server.
https://vladdba.com/2024/10/04/characters-question-marks-squares-sql-server/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba -
Blog post from the past:
In which I go over potential reasons for why some special characters end up corrupted and displayed as question marks, squares or something completely different in SQL Server.
https://vladdba.com/2024/10/04/characters-question-marks-squares-sql-server/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba -
Dew Drop Weekly Newsletter 481 - Week Ending May 1, 2026
#dewdrop #newsletter #aspnetcore #css #azure #javascript #xaml #cpp #windowsdev #dotnet #csharp #mcp #ai #agile #devops #gamedev #appdev #dotnetmaui #podcasts #m365 #data #sqlserver #powershell #devtools
-
How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide) This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS. What is Microsoft SQL Server? Microsoft SQL ... Continued 👉 #mssql #selfhosting #apache #freetds #sqlserver #selfhosted
-
How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)
This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #freetds #apache #sqlserver #selfhosting #mssql #selfhosted -
How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)
This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #freetds #apache #sqlserver #selfhosting #mssql #selfhosted -
How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)
This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #freetds #apache #sqlserver #selfhosting #mssql #selfhosted -
Sweet lord...
Started asking a few questions of my coworkers today. Here's what I've determined: a data analyst is going to build a 3,000 line stored procedure that brings our primary SQL host to its knees, which will be used to generate a horrific SSRS report for a C-level type, who will print it out and most likely put it on their desk and never even look at it.
-
Sweet lord...
Started asking a few questions of my coworkers today. Here's what I've determined: a data analyst is going to build a 3,000 line stored procedure that brings our primary SQL host to its knees, which will be used to generate a horrific SSRS report for a C-level type, who will print it out and most likely put it on their desk and never even look at it.
-
Sweet lord...
Started asking a few questions of my coworkers today. Here's what I've determined: a data analyst is going to build a 3,000 line stored procedure that brings our primary SQL host to its knees, which will be used to generate a horrific SSRS report for a C-level type, who will print it out and most likely put it on their desk and never even look at it.
-
Sweet lord...
Started asking a few questions of my coworkers today. Here's what I've determined: a data analyst is going to build a 3,000 line stored procedure that brings our primary SQL host to its knees, which will be used to generate a horrific SSRS report for a C-level type, who will print it out and most likely put it on their desk and never even look at it.
-
Sweet lord...
Started asking a few questions of my coworkers today. Here's what I've determined: a data analyst is going to build a 3,000 line stored procedure that brings our primary SQL host to its knees, which will be used to generate a horrific SSRS report for a C-level type, who will print it out and most likely put it on their desk and never even look at it.
-
New blog post:
My guideline on how to handle and test SQL Server backups to ensure their viability and avoid a "Schrödinger's backup" scenario.
https://vladdba.com/2026/04/23/test-sql-server-backups-schrodingers-backups/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #azure -
New blog post:
My guideline on how to handle and test SQL Server backups to ensure their viability and avoid a "Schrödinger's backup" scenario.
https://vladdba.com/2026/04/23/test-sql-server-backups-schrodingers-backups/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #azure -
How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)
This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #selfhosting #freetds #mssql #sqlserver #apache #selfhosted -
How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)
This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #selfhosting #freetds #mssql #sqlserver #apache #selfhosted -
How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)
This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #selfhosting #freetds #mssql #sqlserver #apache #selfhosted -
How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)
This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #selfhosting #freetds #mssql #sqlserver #apache #selfhosted -
Recently updated post:
In which I discuss the risks of improperly configured SQL Server linked server connections and provide recommendations for securing them.
Now with a query to identify improperly configured linked server connections.
https://vladdba.com/2023/07/10/securing-sql-server-linked-servers/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #security -
Recently updated post:
In which I discuss the risks of improperly configured SQL Server linked server connections and provide recommendations for securing them.
Now with a query to identify improperly configured linked server connections.
https://vladdba.com/2023/07/10/securing-sql-server-linked-servers/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #security -
Dew Drop Weekly Newsletter 480 - Week Ending April 24, 2026
#dewdrop #newsletter #javascript #azure #aspnetcore #css #xaml #windowsdev #cpp #dotnet #csharp #ai #mcp #gamedev #appdev #devops #agile #agents #podcasts #m365 #powershell #data #sqlserver
-
Dew Drop – April 24, 2026 (#4654)
https://www.alvinashcraft.com/2026/04/24/dew-drop-april-24-2026-4654/
#dotnet #ai #webdev #m365 #sqlserver #visualstudio #windowsdev #cloud #vscode #csharp #appdev #xbox #dewdrop
-
Today's SQL Server oddity: is a PERSISTED column really persisted? Execution plans cast some doubt.
🔹 Create a #temp table with one VARCHAR column
🔹 Add a computed column that casts the VARCHAR to an INT (specify the computed column is PERSISTED).
🔹 Query the #temp table.
🔹 Notice the execution plan warning: "Type conversion in expression (TRY_CAST..."Is SQL CAST-ing the VARCHAR to INT every time the computed column is queried?
I do not know what to think of this.
-
Today's SQL Server oddity: is a PERSISTED column really persisted? Execution plans cast some doubt.
🔹 Create a #temp table with one VARCHAR column
🔹 Add a computed column that casts the VARCHAR to an INT (specify the computed column is PERSISTED).
🔹 Query the #temp table.
🔹 Notice the execution plan warning: "Type conversion in expression (TRY_CAST..."Is SQL CAST-ing the VARCHAR to INT every time the computed column is queried?
I do not know what to think of this.
-
Today's SQL Server oddity: is a PERSISTED column really persisted? Execution plans cast some doubt.
🔹 Create a #temp table with one VARCHAR column
🔹 Add a computed column that casts the VARCHAR to an INT (specify the computed column is PERSISTED).
🔹 Query the #temp table.
🔹 Notice the execution plan warning: "Type conversion in expression (TRY_CAST..."Is SQL CAST-ing the VARCHAR to INT every time the computed column is queried?
I do not know what to think of this.
-
Today's SQL Server oddity: is a PERSISTED column really persisted? Execution plans cast some doubt.
🔹 Create a #temp table with one VARCHAR column
🔹 Add a computed column that casts the VARCHAR to an INT (specify the computed column is PERSISTED).
🔹 Query the #temp table.
🔹 Notice the execution plan warning: "Type conversion in expression (TRY_CAST..."Is SQL CAST-ing the VARCHAR to INT every time the computed column is queried?
I do not know what to think of this.
-
Today's SQL Server oddity: is a PERSISTED column really persisted? Execution plans cast some doubt.
🔹 Create a #temp table with one VARCHAR column
🔹 Add a computed column that casts the VARCHAR to an INT (specify the computed column is PERSISTED).
🔹 Query the #temp table.
🔹 Notice the execution plan warning: "Type conversion in expression (TRY_CAST..."Is SQL CAST-ing the VARCHAR to INT every time the computed column is queried?
I do not know what to think of this.
-
1st time installing SQL Server 2025. The feature for R, Python, and Java is now called "AI Services and Language Extensions".
The feature name has changed a few times over the years/versions. It's discouraging to see AI Services lumped in with it. I would have preferred it be broken out into its own, separate feature.
For years, folks have evangelized about not installing features you don't need...surface attack area and all that. This choice is antithetical to that stance.
