Contents tagged with SQL Server
-
SQLPort em Aveiro
(Portuguese only, sorry!)
-
Profiling SQL Server in .NET
The main tool for profiling SQL Server is, of course, SQL Server Profiler. You can, however, achieve more or less the same results using .NET, I'll show you how.
-
Freetext Extension in Entity Framework Code First
I posted before a solution for adding custom SQL functions to Entity Framework Code First as extension methods. This time I am going to show how we can do something similar for the FREETEXT function of SQL Server. Please note that this example will only work if you have the Fulltext Search component installed and your table is indexed.
-
Entity Framework Pitfalls: Command Interceptors and Identity Keys
The IDbCommandInterceptor (sorry, no official documentation) interface was introduced in Entity Framework 6 as part of the new interception and logging API, and allows the interception of the SQL and its parameters that are sent to the database as the result of DbContext CRUD operations.
-
SQL Server Auditing
Probably the best mechanism for auditing changes to tables in SQL Server is Change Data Capture, which I already covered here. Unfortunately, it only works with the Enterprise editions of SQL Server, something that not everyone has access to.
-
Broadcasting Database Changes Through SignalR
There are several posts out there on using SignalR to signal changes in a database, but because I really didn’t quite like any of them, I decided to write my own.
-
Registering SQL Server Built-in Functions to Entity Framework Code First
It is possible to register custom functions that exist in the database so that they can be called by Entity Framework Code First LINQ queries.
-
Getting the Topmost Hierarchical Parent in T-SQL
It is normal in databases to have hierarchical tables, that is, tables that are related with themselves, forming a parent-child relation. For example, consider this:
-
NHibernate Pitfalls: Eager Loading Multiple Collections
Updated on July 19. Thanks, Hazzik!
-
Table and Column Checksums
Following my last posts on Change Data Capture and Change Tracking, here is another tip regarding tracking changes: table and colum checksums.