loading...
👋 Sign in for the ability sort posts by top and latest.

My .NET Core Setup for MacOS/Linux

Reactions 141 Comments 26
4 min read

Understanding SQL Server Deadlocks

Reactions 71 Comments 1
5 min read

How to work with stored procedures and not die trying

Reactions 30 Comments 11
8 min read

SQL Server Running on a Mac?!

Reactions 24 Comments 4
5 min read

Name your Constraints

Reactions 20 Comments 1
2 min read

Using C# LINQ API to perform SQL IN logic at WHERE clause

Reactions 19 Comments 9
1 min read

Using Docker for local SQL Server development

Reactions 18
4 min read

Checking if the column was updated inside SQLServer update trigger

Reactions 18 Comments 1
1 min read

Automating restoration of production databases into test using AWS RDS

Reactions 18 Comments 4
4 min read

SQL Server Transactions and Isolation Levels

Reactions 17
3 min read

Reference Tables and Many Too Many Relationships

Reactions 16
2 min read

Microsoft SQL Server 2017 on Debian

Reactions 14
2 min read

SQL Server Locking

Reactions 13
3 min read

Open source tools for SQL Server on Linux

Reactions 13
3 min read

The best and easy way to handle database migrations (version control)

Reactions 13
2 min read

The do’s and don’ts of dynamic SQL for SQL Server 

Reactions 13
2 min read

Azure Data Studio: Initial thoughts and walk-through

Reactions 12
4 min read

SQL Server: cuáles son las diferencias entre @@identity y Scope_identity

Reactions 11
3 min read

SQL Server Set Operators: UNION, INTERSECT, and EXCEPT

Reactions 11
1 min read

Exporting scripts from SQL Server for use with DBUp

Reactions 10 Comments 3
2 min read

Youtube Video: ASP.NET Core Web API (Rest API) with Entity Framework Core, SQL Server and Visual Studio Code

Reactions 10
2 min read

Review: SQL Operations Studio (Preview) for SQL Server

Reactions 10
1 min read

Failure is always an option

Reactions 9
5 min read

Microsoft SQL Server Client on Debian

Reactions 9 Comments 5
2 min read

Sql Server Multi Column Index Improvements

Reactions 9
2 min read

Use the Serverless Cloud for ETL Scenarios

Reactions 9
2 min read

Visualizing Merge Join Internals And Understanding Their Implications

Reactions 8
4 min read

Use the right tool to get identity values back after an insert

Reactions 8 Comments 2
3 min read

Bug Report #1 - GETUTCDATE() In Longer Queries

Reactions 8
2 min read

SQL Server’s [N]VARCHAR(MAX) and How to Wield It

Reactions 8
1 min read

SSIS: Change Encryption on a Project and Packages

Reactions 8
1 min read

Add a unique nullable index to an entity property

Reactions 8 Comments 4
2 min read

Working with JSON in an RDBMS – Part 1, MS SQL Server

Reactions 8
12 min read

SQL Server’s identity column misconceptions

Reactions 8
3 min read

Getting Starting With Python For Data Exploration

Reactions 7
7 min read

Bert & Pinal Troubleshoot a Slow Performing SQL Server

Reactions 7
1 min read

Marketing Automation Made Easy with Devart SSIS Data Flow Components for Marketo

Reactions 7
1 min read

Using PowerShell to tidy up CSV files

Reactions 7
3 min read

How to Run SQL Server on a Mac

Reactions 7
2 min read

How to create date buckets in T-SQL

Reactions 7
5 min read

New Formatting Profiles in SQL Complete v6.3

Reactions 7
2 min read

MS SQL Server Backups to S3 – On Linux!

Reactions 7
3 min read

Testing as another user…without their password

Reactions 7
5 min read

Tools | Data Tools and Software

Reactions 7
4 min read

SQL Server 2016’s STRING_SPLIT

Reactions 7
1 min read

Reinventing SSIS scripting with JavaScript - COZYROC

Reactions 7
1 min read

Data Blogger Resource Kit

Reactions 7
3 min read

Using Python to create SqlServer tables with random schema

Reactions 6
1 min read

How To Work With Memory Optimized Objects in SQL Server

Reactions 6
6 min read

How does a database RESTORE affect plan cache?

Reactions 6
7 min read

A Huge Update of dbForge Compare Bundle for SQL Server

Reactions 6
2 min read

What the heck is the dbcreator role?

Reactions 6
3 min read

Purging data with batched deletes

Reactions 6
5 min read

Tales from Technological Backwaters

Reactions 6
3 min read

Recovery of database is 0% complete (approximately 1000000 seconds remain)

Reactions 6
4 min read

Experimenting Flyway with SQL Server

Reactions 6
2 min read

Running SQL Server in Docker

Reactions 6
4 min read

Querying MySQL from SQL Server using linked server

Reactions 6
5 min read

Why does ALTER let me DROP?

Reactions 6
4 min read

Using data from MSSQL linked server with EF Core

Reactions 6
4 min read
loading...