#sqlserver — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlserver, aggregated by home.social.
-
PSBlitz 6.1.0 is live
New checks for Backups (RPO/RPO est.) & Instance Security (beta).
ImportExcel support
Up to 70% faster Excel exports
Retry logic for transient errorsRead the full breakdown: https://vladdba.com/2026/05/28/psblitz-6-1-0-backup-security-checks-excel-performance/
Repo: https://github.com/VladDBA/PSBlitz#sqlserver #sqldba #powershell #microsoftsqlserver #mssqlserver #mssql #mssqldba #dba #PSBlitz #MVPBuzz
-
PSBlitz 6.1.0 is live
New checks for Backups (RPO/RPO est.) & Instance Security (beta).
ImportExcel support
Up to 70% faster Excel exports
Retry logic for transient errorsRead the full breakdown: https://vladdba.com/2026/05/28/psblitz-6-1-0-backup-security-checks-excel-performance/
Repo: https://github.com/VladDBA/PSBlitz#sqlserver #sqldba #powershell #microsoftsqlserver #mssqlserver #mssql #mssqldba #dba #PSBlitz #MVPBuzz
-
PSBlitz 6.1.0 is live
New checks for Backups (RPO/RPO est.) & Instance Security (beta).
ImportExcel support
Up to 70% faster Excel exports
Retry logic for transient errorsRead the full breakdown: https://vladdba.com/2026/05/28/psblitz-6-1-0-backup-security-checks-excel-performance/
Repo: https://github.com/VladDBA/PSBlitz#sqlserver #sqldba #powershell #microsoftsqlserver #mssqlserver #mssql #mssqldba #dba #PSBlitz #MVPBuzz
-
It's been said that experience is a comb life gives you after your hair has fallen out.
-
It's been said that experience is a comb life gives you after your hair has fallen out.
-
It's been said that experience is a comb life gives you after your hair has fallen out.
-
It's been said that experience is a comb life gives you after your hair has fallen out.
-
It's been said that experience is a comb life gives you after your hair has fallen out.
-
Another reason: object types sometimes change. For years my organization had a table named dbo.tbl_FooBar.
To overcome performance problems involved with populating & syncing the table, it was replaced with a VIEW. The old table was referenced in too many places to warrant changing the object name. So we didn't.
And now we have a VIEW named dbo.tbl_FooBar. And that's just messed up.
-
Another reason: object types sometimes change. For years my organization had a table named dbo.tbl_FooBar.
To overcome performance problems involved with populating & syncing the table, it was replaced with a VIEW. The old table was referenced in too many places to warrant changing the object name. So we didn't.
And now we have a VIEW named dbo.tbl_FooBar. And that's just messed up.
-
Another reason: object types sometimes change. For years my organization had a table named dbo.tbl_FooBar.
To overcome performance problems involved with populating & syncing the table, it was replaced with a VIEW. The old table was referenced in too many places to warrant changing the object name. So we didn't.
And now we have a VIEW named dbo.tbl_FooBar. And that's just messed up.
-
Another reason: object types sometimes change. For years my organization had a table named dbo.tbl_FooBar.
To overcome performance problems involved with populating & syncing the table, it was replaced with a VIEW. The old table was referenced in too many places to warrant changing the object name. So we didn't.
And now we have a VIEW named dbo.tbl_FooBar. And that's just messed up.
-
Another reason: object types sometimes change. For years my organization had a table named dbo.tbl_FooBar.
To overcome performance problems involved with populating & syncing the table, it was replaced with a VIEW. The old table was referenced in too many places to warrant changing the object name. So we didn't.
And now we have a VIEW named dbo.tbl_FooBar. And that's just messed up.
-
Why?
For probably 20 years or so, development tools (like SQL Server Management Studio and Visual Studio) have been sophisticated enough to indicate an object's type via tool tips (they usually pop up when you hover the mouse cursor/icon over the object's name).
You can see an SSMS example in the attached picture. Microsoft didn't use Hungarian notation, and it's not necessary--we clearly see the object is a VIEW.
-
Why?
For probably 20 years or so, development tools (like SQL Server Management Studio and Visual Studio) have been sophisticated enough to indicate an object's type via tool tips (they usually pop up when you hover the mouse cursor/icon over the object's name).
You can see an SSMS example in the attached picture. Microsoft didn't use Hungarian notation, and it's not necessary--we clearly see the object is a VIEW.
-
Why?
For probably 20 years or so, development tools (like SQL Server Management Studio and Visual Studio) have been sophisticated enough to indicate an object's type via tool tips (they usually pop up when you hover the mouse cursor/icon over the object's name).
You can see an SSMS example in the attached picture. Microsoft didn't use Hungarian notation, and it's not necessary--we clearly see the object is a VIEW.
-
Why?
For probably 20 years or so, development tools (like SQL Server Management Studio and Visual Studio) have been sophisticated enough to indicate an object's type via tool tips (they usually pop up when you hover the mouse cursor/icon over the object's name).
You can see an SSMS example in the attached picture. Microsoft didn't use Hungarian notation, and it's not necessary--we clearly see the object is a VIEW.
-
Why?
For probably 20 years or so, development tools (like SQL Server Management Studio and Visual Studio) have been sophisticated enough to indicate an object's type via tool tips (they usually pop up when you hover the mouse cursor/icon over the object's name).
You can see an SSMS example in the attached picture. Microsoft didn't use Hungarian notation, and it's not necessary--we clearly see the object is a VIEW.
-
As the saying in IT goes, "Naming things is hard". Coming up with a naming convention everyone agrees on is even more difficult.
For SQL Server database objects, one 'rule' I try to always follow is to *not* use Hungarian notation, which involves prefixing an object name to indicate the object type. For example a "tbl_" prefix for tables or "vw_" for views.
-
As the saying in IT goes, "Naming things is hard". Coming up with a naming convention everyone agrees on is even more difficult.
For SQL Server database objects, one 'rule' I try to always follow is to *not* use Hungarian notation, which involves prefixing an object name to indicate the object type. For example a "tbl_" prefix for tables or "vw_" for views.
-
As the saying in IT goes, "Naming things is hard". Coming up with a naming convention everyone agrees on is even more difficult.
For SQL Server database objects, one 'rule' I try to always follow is to *not* use Hungarian notation, which involves prefixing an object name to indicate the object type. For example a "tbl_" prefix for tables or "vw_" for views.
-
As the saying in IT goes, "Naming things is hard". Coming up with a naming convention everyone agrees on is even more difficult.
For SQL Server database objects, one 'rule' I try to always follow is to *not* use Hungarian notation, which involves prefixing an object name to indicate the object type. For example a "tbl_" prefix for tables or "vw_" for views.
-
As the saying in IT goes, "Naming things is hard". Coming up with a naming convention everyone agrees on is even more difficult.
For SQL Server database objects, one 'rule' I try to always follow is to *not* use Hungarian notation, which involves prefixing an object name to indicate the object type. For example a "tbl_" prefix for tables or "vw_" for views.
-
New blog post:
In which I cover and demo SQL Server roles and permissions that are viable avenues for privilege escalation to sysadmin.
https://vladdba.com/2026/05/22/sql-server-permission-privilege-escalation/
#sqlserver #sqldba #microsoftsqlserver #hashcat #cybersecurity #infosec #sql #mvpbuzz -
New blog post:
In which I cover and demo SQL Server roles and permissions that are viable avenues for privilege escalation to sysadmin.
https://vladdba.com/2026/05/22/sql-server-permission-privilege-escalation/
#sqlserver #sqldba #microsoftsqlserver #hashcat #cybersecurity #infosec #sql #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.raddemo.host #mssql #sqlserver #selfhosting #selfhosted #apache #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 #sqlserver #selfhosting #selfhosted #apache #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 #sqlserver #selfhosting #selfhosted #apache #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 ... Continued 👉 #selfhosted #apache #freetds #mssql #selfhosting #sqlserver
How to Install Microsoft SQL S... -
Dew Drop Weekly Newsletter 484 - Week Ending May 20, 2026
#dewdrop #newsletter #javascript #aspnetcore #azure #css #cpp #windowsdev #winui #dotnet #csharp #ai #mcp #devops #agile #gamedev #appdev #podcasts #m365 #sqlserver #data #powershell #python
-
Dew Drop Weekly Newsletter 484 - Week Ending May 20, 2026
#dewdrop #newsletter #javascript #aspnetcore #azure #css #cpp #windowsdev #winui #dotnet #csharp #ai #mcp #devops #agile #gamedev #appdev #podcasts #m365 #sqlserver #data #powershell #python
-
Dew Drop Weekly Newsletter 484 - Week Ending May 20, 2026
#dewdrop #newsletter #javascript #aspnetcore #azure #css #cpp #windowsdev #winui #dotnet #csharp #ai #mcp #devops #agile #gamedev #appdev #podcasts #m365 #sqlserver #data #powershell #python
-
Dew Drop Weekly Newsletter 484 - Week Ending May 20, 2026
#dewdrop #newsletter #javascript #aspnetcore #azure #css #cpp #windowsdev #winui #dotnet #csharp #ai #mcp #devops #agile #gamedev #appdev #podcasts #m365 #sqlserver #data #powershell #python
-
Dew Drop Weekly Newsletter 484 - Week Ending May 20, 2026
#dewdrop #newsletter #javascript #aspnetcore #azure #css #cpp #windowsdev #winui #dotnet #csharp #ai #mcp #devops #agile #gamedev #appdev #podcasts #m365 #sqlserver #data #powershell #python
-
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 #apache #mssql #freetds #selfhosting #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 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 #apache #mssql #freetds #selfhosting #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 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 #apache #mssql #freetds #selfhosting #sqlserver -
Oracleにも対応したNew Relicの新機能「Database 360」で実行計画からボトルネックを特定しよう！
https://qiita.com/nr_ishibashi/items/6ca02ac46fe274bd853e?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items#qiita #SQLServer #oracle #NewRelic #Database #observability
-
Oracleにも対応したNew Relicの新機能「Database 360」で実行計画からボトルネックを特定しよう！
https://qiita.com/nr_ishibashi/items/6ca02ac46fe274bd853e?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items#qiita #SQLServer #oracle #NewRelic #Database #observability
-
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 #selfhosting #mssql #freetds #apache #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 #selfhosting #mssql #freetds #apache #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 #selfhosting #mssql #freetds #apache #sqlserver #selfhosted -
John Morehouse Blogged: John Morehouse https://www.dcac.com/2026/05/18/using-ip4-me-for-dynamic-ips/ Using IP4.me For Dynamic IPs #sqlserver
-
John Morehouse Blogged: John Morehouse https://www.dcac.com/2026/05/18/using-ip4-me-for-dynamic-ips/ Using IP4.me For Dynamic IPs #sqlserver
