When 140 characters aren't enough… (nor 280 :P)

Main menu

Filed under TSQL …

(This is a personal post, just a reminder) Damn! :/ Each time a new version of .NET Framework is installed (or upgraded) in our SQL Server I need to update some assemblies we’re using in some projects. Related posts HowTo: Send Notifications from SQL Server using SignalR HowTo: Redeploy CLR assemblies to SQL Server (Newtonsoft.Json version … Continue reading →

The Story Hi again, Some time ago I published a post about how to send notifications from SQL Server using SignalR. We are using SignalR self-hosted in a Windows Service in a separated server, and it had been running fine until now. This week I had to set up a new SQL server which will replace the … Continue reading →

Overview In our current project we’ve to push some notifications directly from the database server (SQL Server 2014) to different apps. For example, we’ve scheduled some SSIS (SQL Server Integration Services) projects that pre-calculates large amounts of data. And well, should be nice notify all the apps when new data is available without unnecessary round trips to database. And … Continue reading →

The scenario: Sometimes we forget SQL Azure is not SQL Server. This morning in the project I’m working, we needed to create a small ASP.NET membership database in SQL Azure. It seems easy! Would you expect troubles with this? Nope? Ok, me neither… until I tried to execute aspnet_regsql to create the database: An error … Continue reading →