(Nakul Vachhrajani) I was recently contacted by a fellow team member who was interested in finding out the number of records in a temporary table which was being used as part of a long-running script.
Editorials
Bridges Between Servers
February 12, 2020Many times as you build out environments, you’re left pulling information from different SQL Servers and different sources, so you can assemble [...]Upgrades, Tuning and SQL Server
February 11, 2020One of the areas that is coming up more and more frequently with the ability to move from version to version of SQL Server pretty fluidly with the [...]
Complexities of "It Just Works"
January 17, 2020There is a lot of talk about technical debt – that thing where systems have been allowed to run because, well, they work. Why poke a sleeping [...]
- Selecting a Data Platform
- Data Drift, Data Maturation and Working With It
- Data Protection on Your (and Your User’s) Travel Times
Other News
Mocking Dependencies In Angular Unit Tests
(Neeraj Shende) There could be 3 different scenarios when it comes to mocking the dependencies in order to optimize the performance of unit tests cases and to reduce the development time of unit test cases.
Projections with JPA and Hibernate
(Thorben Janssen) Choosing the right projection when selecting data with JPA and Hibernate is incredibly important.
Practical RPG: Encapsulating Your Data with Extension Files, Part 2
(Joe Pluta) In my previous article, I explained how to use extension files to encapsulate a legacy database. This allows you to add new data points to the database without the impact of changing an existing master file.
Developing Mobile Applications in .NET
(Damir Arh) In this tutorial, I will describe the tools and frameworks available to .NET developers for all aspects of mobile application development i.e. front-end, back-end and operations.
Sequence Contains No Elements
(Thomas LaRock) I came across this “Sequence contains no elements” error when using Always Encrypted a while back and wanted to write a quick post. In this case, I was trying to encrypted a computed column.
SQL SERVER – Log Shipping Error: Only Members of the Sysadmin Fixed Server Role Can Perform this Operation
(Pinal Dave) Even though there are many disaster recovery solutions available in SQL Server as of today, few of my clients Still go with log shipping. In this blog, I would share my learning about one of the errors which I observed with one of my clients.
Using Function Monkey with MediatR
(James) There are a lot of improvements coming in v4 of Function Monkey and the beta is currently available on NuGet. As the full release approaches I thought it would make sense to introduce some of these new capabilities here.
Solving Access Denied in Crypto Machine Keys
(K. Scott Allen) Previously on OdeToCode I posted about tracking down an AspNetCore build error.
Getting the most out of in-memory – part 2
(Connor McDonald) In the previous post, I described the importance of checking V$IM_SEGMENTS to ensure that the in-memory store is populated to have confidence that you are indeed getting the benefit of the feature.