UK #dotnet #csharp #sqlserver lead/senior developer with over 15 years’ experience looking for new permanent role if possible. Would consider temporary contract.
#AspDotNet #mvc #blazor #entityframework #azure #tdd #agile #Git
Looking for hybrid role in London, Cambridge, Essex, or Hertfordshire. Also interested in fully-remote UK or European roles.
I wish #SQLServer had the COMMENT ON command to add descriptions/comments on database objects. It's pretty common on other RDBMS platforms. So I wrote a wrapper proc for you all to emulate it, and to make the syntax easier.
Go forth and document those database objects:
This is a common error folks encounter with SQL Server. When it happens to my end users, they often don't know what it means. Their minds begin to race. Wild, often ridiculous assumptions follow.
But at it's core, it really isn't that complicated: The connection attempt failed because the SQL Server you tried to connect to can't be found.
Why can't it be found is a larger discussion. This article covers it very well.
Patchday: Microsoft schließt 100.000-$-Lücke in SharePoint aus Hacker-Wettbewerb
Update-Sammlung veröffentlicht: Um Attacken vorzubeugen, sollten Admins sicherstellen, dass ihre Microsoft-Produkte auf dem aktuellen Stand sind.
#ChartDB: редактор діаграм баз даних з відкритим вихідним кодом.
Інструмент дозволяє швидко створювати діаграми і таблиці з вашої БД. Один запит - і ви отримуєте схему бази даних у форматі JSON.
Підтримує #PostgreSQL, #MySQL, #SQLServer, #MariaDB, #SQLite та інші.
#database 
GitHub https://github.com/chartdb/chartdb?tab=readme-ov-fileСайт https://chartdb.io/
Mettre le ".bat" dans le même répertoire que le script SQL ou mettre le chemin complet du Script SQL dans le ".BAT"
petit problème de réinitialisation de mot de passe anomyme d' #SQLServer
pas de solution mais un script BAT
- - - - - - - -
@Echo on
echo Reinitialise SA via le script: initialiseSA.sql
sqlcmd -S <nom de Serveur SQL> -E -i "initialiseSA.sql"
- - - - - - - -
qui lance 1 Script SQL: initialiseSA.sql
- - - - - - - -
use master
go
EXEC sp_password NULL, '<mot de pass>', sa ;
go
- - - - - - - -
remplacer <nom de Serveur SQL> par le nom de votre serveur SQL
et <mot de pass> par un mot de pass
PostgreSQL, we've generally heard, is "good enough" for most intents and purposes.
We'd love to know what YOU think. What's stopped you from using #PostgreSQL in the past, and what solution did you choose instead? When have you opted for #Postgres where it turned out better than expected? 
NEW POST:
Remove IDENTITY Property From a Column
A (mostly) simple option that doesn't require any I/O...or the need for a large maintenance window.
Dave Mason
https://www.davemason.me/2025/05/03/remove-identity-property-from-a-column
Sigh. My SQL Servers often feel like NoSQL data dumpsters.
An ASP.NET Core Web API of my authorship to access and manipulate project data using EF Core, and JWT on a PostgreSQL or SQL Server database.
An e-commerce web application of my authorship built using SQL Server, EF, ASP. NET Core MVC, C#, Javascript and an assortment of other libraries and web services.
Hey #sqlfamily , curious how everybody is doing Ci/CD. I want to do it. I’ve checked in everything in prod into GitHub. I have access to GitHub Actions. But what do people do to get from dev to prod? If I change a table and add a permission, what scripts out the changes from my dev DB? Looks like Sqlpackage and Flyway? If I can’t have the database look like prod (because of extra audit triggers, etc), how should I handle that? Is there a Recommended Best Practice somewhere? #sqlserver
What a weird start to my Wed morning.
A disk drive on a SQL host ran out of space. A database log file was quickly identified--it had grown to ~500GB. What did I find?
The recovery model was set to SIMPLE There were no open transactions on the db. log_reuse_wait in sys.databases showed 'REPLICATION' Replication was not in use. Both the SSMS GUI and DMVs showed 0% free space in the log file. Change Data Capture was not in use.
Mais comment c'est trop bien DbaTools pour SQL Server !
On a commencé à faire mumuse avec au boulot, et plus on avance, plus on voit à quel point c'est génial.
Pour ceux qui galèrent à déployer du SQL Server en prod, arrêtez de le faire à la main, et utilisez les. Une ligne de commande, et paf, c'est déployé.
Les manips casse pieds à faire à la main dans SQL Manager ? C'est de l'histoire ancienne ça! Une commande et paf, c'est réglé.
Maintenant, scriptez tout ça, et profitez de la vie...
#SqlServer #DbaTools #VisMaVieDeTech
SQL Server Management Studio has a 'Code Snippets' feature that is very handy. (It's also available in Visual Studio--it's probably more accurate to refer to it as a Visual Studio shell feature...but I digress.)
https://www.davemason.me/2020/11/21/transact-sql-code-snippets
Ever wish you could go back in time and see how your data looked yesterday, last week, or last year?
Temporal Tables in EF Core let you easily track changes, audit history, and recover deleted data. No more guesswork—just built-in time travel for your database.
Learn how it works: https://woodruff.dev/temporal-tables-in-ef-core-bringing-time-travel-to-your-data/
Need to store flexible data in SQL Server without creating endless tables?
JSON in SQL Server lets you store and query structured data while keeping your schema simple. EF Core makes it easy to work with JSON directly in your queries.
https://woodruff.dev/json-columns-in-sql-server-storing-querying-json-with-ef-core/
Yesterday I installed VSCodium on Debian Linux. But I couldn't get the mssql (SQL Server) extension to work.
Tonight I installed VSCode on Debian Linux. The mssql extension works just fine.
Why doesn't it work on VSCodium? IDK. 
