#sql-server — Public Fediverse posts

Headline: Red Flags in Your Query

Me: Great list of 'code smells'. I see a lot of these myself when I'm reviewing code. They're all red flags for me too.

https://straightforwardsql.com/posts/tsql-tuesday-200-red-flags/

#SQLServer
#SQL
#Databases

Headline: Red Flags in Your Query

Me: Great list of 'code smells'. I see a lot of these myself when I'm reviewing code. They're all red flags for me too.

https://straightforwardsql.com/posts/tsql-tuesday-200-red-flags/

#SQLServer
#SQL
#Databases

Learn how to use #vscode effectively with your #sqlserver DBs with Carlos Robles at #techbash 2026.

Register by July 31st and save with code SUMMERSALE. Check out the schedule at https://techbash.com/schedule

#devconference #developers #dba #database #devcommunity

Learn how to use #vscode effectively with your #sqlserver DBs with Carlos Robles at #techbash 2026.

Register by July 31st and save with code SUMMERSALE. Check out the schedule at https://techbash.com/schedule

#devconference #developers #dba #database #devcommunity

Last day to register to Brent Ozar's 2026 Live Online Classes with a 50% discount.
And you can stack an extra 10% off on top of that.
Find out how to claim the exra discount: https://vladdba.com/2026/06/23/extra-10-off-brent-ozars-live-classes/
#SQLServer #DBA #BrentOzar #DatabasePerformance #TechTraining #sql #performance #mssql #sqldba

Dew Drop Weekly Newsletter 491 - Week Ending July 10, 2026

https://zc.vg/0lGDM?m=0

#dewdrop #newsletter #javascript #azure #aspnetcore #blazor #cpp #xaml #windowsdev #msix #csharp #visualstudio #vscode #githubcopilot #ai #mcp #dotnetmaui #python #devops #agile #IoT #appdev #podcasts #sqlserver #data #m365 #terminal

Dew Drop Weekly Newsletter 491 - Week Ending July 10, 2026

https://zc.vg/0lGDM?m=0

#dewdrop #newsletter #javascript #azure #aspnetcore #blazor #cpp #xaml #windowsdev #msix #csharp #visualstudio #vscode #githubcopilot #ai #mcp #dotnetmaui #python #devops #agile #IoT #appdev #podcasts #sqlserver #data #m365 #terminal

Blog alert!

This time on some experimenting with the JSON data type and index inside SQL Server.

#SQLServer
#AzureSql
#DBA

http://sqlreitse.com/2026/07/08/sql-server-2025-testing-the-json-index/

Blog alert!

This time on some experimenting with the JSON data type and index inside SQL Server.

#SQLServer
#AzureSql
#DBA

http://sqlreitse.com/2026/07/08/sql-server-2025-testing-the-json-index/

New blog post:
My third contribution to T-SQL Tuesday, about things that make me instantly think a query is bad.
https://vladdba.com/2026/07/07/t-sql-tuesday-200-things-that-make-a-query-bad/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #tsql2sday #azure #azuresql #mvpbuzz

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 #selfhosted #selfhosting #apache #mssql #sqlserver #freetds

I once had a very large personal project a long time ago. It was in the 10s of thousands of lines of code. Lots of #T4 transforms, big database, so many files with large footprints (controllers, DTOs, etc.). My big test of #Rider is seeing if I can get this #VS2017 project fully converted to a .NET 10 solution in Linux. Migrating from #Azure hosing and #SQLServer to #Docker self hosting + #postgres. Using #Codex to help migrate some things like T4 templates and documentation.

I once had a very large personal project a long time ago. It was in the 10s of thousands of lines of code. Lots of #T4 transforms, big database, so many files with large footprints (controllers, DTOs, etc.). My big test of #Rider is seeing if I can get this #VS2017 project fully converted to a .NET 10 solution in Linux. Migrating from #Azure hosing and #SQLServer to #Docker self hosting + #postgres. Using #Codex to help migrate some things like T4 templates and documentation.

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 👉 #selfhosted #freetds #selfhosting #sqlserver #apache #mssql

How to Install Microsoft SQL S...

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 👉 #selfhosted #freetds #selfhosting #sqlserver #apache #mssql

How to Install Microsoft SQL S...

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 #apache #mssql #sqlserver #selfhosting #selfhosted #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 #apache #mssql #sqlserver #selfhosting #selfhosted #freetds

Dew Drop Weekly Newsletter 490 - Week Ending July 3, 2026

https://zc.vg/KjGcr?m=0

#dewdrop #newsletter #aspnetcore #azure #javascript #css #cpp #xaml #windowsdev #dotnet #csharp #ai #mcp #github #githubcopilot #m365 #python #devops #agile #IoT #appdev #podcasts #sqlserver #data #powershell #cli

Dew Drop Weekly Newsletter 490 - Week Ending July 3, 2026

https://zc.vg/KjGcr?m=0

#dewdrop #newsletter #aspnetcore #azure #javascript #css #cpp #xaml #windowsdev #dotnet #csharp #ai #mcp #github #githubcopilot #m365 #python #devops #agile #IoT #appdev #podcasts #sqlserver #data #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 #freetds #mssql

Denny Cherry Blogged: Denny Cherry https://www.dcac.com/?p=87808 Someone Might Be Sending Email From Your Domain Right Now #sqlserver

Denny Cherry Blogged: Denny Cherry https://www.dcac.com/?p=87808 Someone Might Be Sending Email From Your Domain Right Now #sqlserver

8 days left to take advantage of Brent Ozar's 2026 Live Online Classes 50% discount (ends July 10).
And you can stack an extra 10% off on top of that.
Find out how to claim the exra discount: https://vladdba.com/2026/06/23/extra-10-off-brent-ozars-live-classes/
#SQLServer #DBA #BrentOzar #mssql #mssqlserver #sql #DatabasePerformance #TechTraining

Today I'll be installing SQL Server 2008 R2 on a Windows Server 2012 virtual machine...all because we have a customer/vendor with a database backup from SQL 2000 that we need.

I wish I was kidding. 🤦‍♂️

#SQLServer
#DBA

Today I'll be installing SQL Server 2008 R2 on a Windows Server 2012 virtual machine...all because we have a customer/vendor with a database backup from SQL 2000 that we need.

I wish I was kidding. 🤦‍♂️

#SQLServer
#DBA

Denny Cherry Blogged: Denny Cherry https://www.dcac.com/2026/07/01/someone-might-be-sending-email-from-your-domain-right-now/ Someone Might Be Sending Email From Your Domain Right Now #sqlserver

Denny Cherry Blogged: Denny Cherry https://www.dcac.com/2026/07/01/someone-might-be-sending-email-from-your-domain-right-now/ Someone Might Be Sending Email From Your Domain Right Now #sqlserver

"Developers want to add a new column every day. VARCHARs"

"The integrity of our data is very important, not to me personally (I couldn't care less), but for our company to survive."

This clip got a good chuckle out of me 😅

#sql #mssql #sqlserver #dba
https://www.youtube.com/watch?v=5KyfW79Ld4g

Azure SQL Database container

https://microsoft.github.io/azure-sql-database-container/

#azure #cloud #sql #sqlserver #azuresql

Azure SQL Database container

https://microsoft.github.io/azure-sql-database-container/

#azure #cloud #sql #sqlserver #azuresql

Denny Cherry Blogged: Denny Cherry https://www.dcac.com/?p=87788 SSMS Tools in VS Code #sqlserver

Denny Cherry Blogged: Denny Cherry https://www.dcac.com/?p=87788 SSMS Tools in VS Code #sqlserver

@DarkWebInformer Got a shudder down my spine. I started out as a SQLSEVER and MYSQL DBA in 1998.

Managing log shipping and DTS packages were my last straw and switched to cyber security.

This would have been me after 25 years.

#dba #sqlserver #mysql #cybersecurity

@DarkWebInformer Got a shudder down my spine. I started out as a SQLSEVER and MYSQL DBA in 1998.

Managing log shipping and DTS packages were my last straw and switched to cyber security.

This would have been me after 25 years.

#dba #sqlserver #mysql #cybersecurity

Denny Cherry Blogged: Denny Cherry https://www.dcac.com/2026/06/30/ssms-tools-in-vs-code/ SSMS Tools in VS Code #sqlserver

Denny Cherry Blogged: Denny Cherry https://www.dcac.com/2026/06/30/ssms-tools-in-vs-code/ SSMS Tools in VS Code #sqlserver

Blog Alert!

This time on my experience preparing for, and taking the Microsoft DP-800 exam.

#certicace
#startel
#DP800
#SQLServer
#AI
#MCP
#QueryStore
#MicrosoftLearn

http://sqlreitse.com/2026/06/30/dp-800-exam-experiences/

Blog Alert!

This time on my experience preparing for, and taking the Microsoft DP-800 exam.

#certicace
#startel
#DP800
#SQLServer
#AI
#MCP
#QueryStore
#MicrosoftLearn

http://sqlreitse.com/2026/06/30/dp-800-exam-experiences/

#SQLJobCommander (SJC) has been approved for the #Microsoft store here:

https://apps.microsoft.com/detail/9n2vfrz1c29m?hl=en-US&gl=CA

SJC is a SQL Server® Agent job management tool that delivers familiar SSMS functionality while adding unique capabilities for enhanced job manipulation and control.

This availability makes me happy as a single hobbyist developer, since I could not justify spending hundreds of $$ on a yearly code signing certificate. Being in the store, Microsoft signs the application so that Smart App Control is not triggered or requiring it to be disabled on a client system.

Boosts welcome and appreciated.

I already have plans for the next version.

#sqlserver #database #DBA

#SQLJobCommander (SJC) has been approved for the #Microsoft store here:

https://apps.microsoft.com/detail/9n2vfrz1c29m?hl=en-US&gl=CA

SJC is a SQL Server® Agent job management tool that delivers familiar SSMS functionality while adding unique capabilities for enhanced job manipulation and control.

This availability makes me happy as a single hobbyist developer, since I could not justify spending hundreds of $$ on a yearly code signing certificate. Being in the store, Microsoft signs the application so that Smart App Control is not triggered or requiring it to be disabled on a client system.

Boosts welcome and appreciated.

I already have plans for the next version.

#sqlserver #database #DBA

NEW POST:
✍ Fast in SSMS, Slow in the App

🔎 Your SQL Server query is fast when you run it in SSMS. It's slow in your application. But why?

👤 Dave Mason

https://www.davemason.me/2026/06/28/fast-in-ssms-slow-in-the-app

#SQLServer
#DBA
#SQL
#Database
#TSQL

NEW POST:
✍ Fast in SSMS, Slow in the App

🔎 Your SQL Server query is fast when you run it in SSMS. It's slow in your application. But why?

👤 Dave Mason

https://www.davemason.me/2026/06/28/fast-in-ssms-slow-in-the-app

#SQLServer
#DBA
#SQL
#Database
#TSQL

Recently updated blog post:
In which I demonstrate why using heaps in SQL Server for anything other than staging tables comes with real, measurable costs.
If you didn't get a chance to attend my session at Data Saturday Croatia 2026, then this is the next best thing.
https://vladdba.com/2025/12/30/the-hidden-costs-of-heaps-in-sql-server/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba

Dew Drop Weekly Newsletter 489 - Week Ending June 26, 2026

https://zc.vg/evcbp?m=0

#dewdrop #newsletter #javascript #azure #aspnetcore #blazor #css #cpp #windowsdev #xaml #csharp #dotnet #efcore #ai #mcp #agile #devops #python #appdev #podcasts #IoT #m365 #data #sqlserver #powershell #cli

Dew Drop Weekly Newsletter 489 - Week Ending June 26, 2026

https://zc.vg/evcbp?m=0

#dewdrop #newsletter #javascript #azure #aspnetcore #blazor #css #cpp #windowsdev #xaml #csharp #dotnet #efcore #ai #mcp #agile #devops #python #appdev #podcasts #IoT #m365 #data #sqlserver #powershell #cli

Today was one of those days that made me consider looking for a new job. 🙁

I hope your day was better than mine.

#SQLServer
#DBA

Current mood.

#SQLServer
#DBA
#Databases

jdanton1 Blogged: jdanton1 https://www.dcac.com/2026/06/25/microsoft-fabric-why-are-you-so-down/ Microsoft Fabric–Why Are You So Down? #sqlserver

I've also submitted #SQLJobCommander to the #Microsoft store and it is currently in the certification phase... fingers crossed.

Boosts appreciated.

#SQLServer #Database #DBA #software