Trying to persuade developers to follow best practices is a joyless endeavor.
Sure, go ahead and store formatted data as strings in a relational database.
I have no experience in this matter and I'm just being difficult for no reason.
Trying to persuade developers to follow best practices is a joyless endeavor.
Sure, go ahead and store formatted data as strings in a relational database.
I have no experience in this matter and I'm just being difficult for no reason.
#FediHire If anyone needs a database developer around the end of this year or early next year, I’ll be available around then! I can work in #SQL, #VB, #C#, #SQLServer and #Snowflake.
My current contract comes to an end in mid-November and I’m very good at remote working.
On the other hand, if your role is in Gloucestershire, I’m more than happy to work onsite.
Let’s make things happen for you!
But you can't have a "Last man standing" configuration as in #SQLServer Availability Groups, where only the Primary Replica is online and serves your workload...
Gah! I should have quit working at 5p.
Instead, I found two database tables that store phone numbers-formatted phone numbers. And guess what? The format is different between tables.
So what does a developer do? They join the tables on phone number columns, both wrapped in a user-defined function that strips out non-digit characters.
Folks, this is all so wrong.
Running the TPC-C workload against #PostgreSQL. I really like the flexibility of HammerDB - because I'm doing the same thing with #SQLServer.
Sign up now for a full day of training on using Blazor, CSLA .NET, SQL Server to build maintainable enterprise apps. This is live in St. Paul, MN on Sept 26.
Free SQL Server training this month from Brent Ozar.
I highly recommend the "How to Think Like the SQL Server Engine" class, especially for developers.
https://www.brentozar.com/archive/2025/09/free-live-sql-server-classes-this-month/
Dew Drop Weekly Newsletter #447 - Week Ending September 5, 2025
Dew Drop Weekly Newsletter #447 - Week Ending September 5, 2025
buff.ly/YSsFDfk
#dewdrop #newsletter #javascript #aspnetcore #blazor #winui #xaml #csharp #dotnet #ai #mcp #devops #agile #IoT #appdev #database #sqlserver #data #m365 #windows
Dew Drop Weekly Newsletter 447...
I'm giving a full day presentation on #blazor**, **#cslanet**, and **#sqlserver** on Friday September 26, in St. Paul, Minnesota. This is a pre-con for the **#sqlsaturday event.
Here's a brief video about what I'll be covering:
You can register here:
Cách Sử Dụng Hàm TRY_CAST trong SQL Server
Cách Sử Dụng Hàm TRYCAST trong SQL Server #SQLServer #TRYCAST #ChuyểnĐổiKiểuDữLiệu #Database #Programming Trong SQL Server, việc chuyển đổi kiểu dữ liệu là thao tác vô cùng phổ biến. Tuy nhiên, nếu gặp lỗi trong quá trình chuyển đổi (ví dụ như cố gắng chuyển đổi chuỗi không hợp lệ thành số), truy vấn sẽ bị dừng đột ngột và báo lỗi.
https://maychu.top/2025/09/01/cach-su-dung-ham-try_cast-trong-sql-server/
️ T-SQL Script Assistant Using SQL Server AI and Python
New blog post:
In which I demo two PoCs for SQL injection vulnerabilities fixed in SQL Server 2022 CU20 GDR KB5063814.
https://vladdba.com/2025/08/29/poc-sql-injection-sql-server-2022-cu20-gdr-kb5063814/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #security #sqli #sqlinjection
.NET Aspire 4: Integrations | by Dave Brock.
buff.ly/uZ9bFRE
#dotnet #aspire #dotnetaspire #cloud #cloudnative #telemetry #redis #sqlserver
.NET Aspire 4: Integrations
Dew Drop Weekly Newsletter 446 - Week Ending August 29, 2025.
zc.vg/jErvZ?m=0
#dewdrop #newsletter #aspnetcore #azure #javascript #windev #xaml #csharp #dotnet #agile #ai #devops #appdev #podcasts #m365 #sqlserver #data #terminal
Dew Drop Weekly Newsletter 446...
Dew Drop Weekly Newsletter 446 - Week Ending August 29, 2025.
Presenting T-SQL Analyzer - live best practices analysis of your SQL scripts in Visual Studio | by Erik EJ.
https://erikej.github.io/sql/dacfx/visualstudio/2025/08/25/dacfx-visx-rules.html
Presenting T-SQL Analyzer - live best practices analysis of your SQL scripts in Visual Studio | by Erik EJ.
buff.ly/uryQcgx
#sqlserver #tsql #visualstudio #database #productivity
Presenting T-SQL Analyzer - li...
Blog alert!
This time on my first experiences with SQL Server 2025, and my take on some new features!
http://sqlreitse.com/2025/08/25/my-top-features-of-sql-server-2025-for-business-intelligence/