(Connor McDonald) Here’s a quirky one for you. It can happen when you are dealing with a partitioned table where the partition key is defined as RAW. To be honest,
Other News
Quick Tip: Spooling to ‘Excel’
(Jeff Smith) Problem: I have 3 queries I want to run. I want the end result to be a single spreadsheet that has all the query results included.
Azure Data Catalog Register Tabular Data Model and Enriching Data Assets – Part 4
(Haroon Ashraf) As a SQL Server Business Intelligence Developer, I have been tasked to centralize information about the data sources including a deployed tabular data model and its underlying source database so that they become understandable, discoverable and consumable for data users.
Yet Another Fluent JDBC Wrapper in 200 Lines of Code
(£ukasz Bownik) Those who are not convinced to use Hibernate to manage persistence are forced to use plain old JDBC API.
Troubleshooting problems with deadlock in SQL Server 2017
Troubleshooting problems with deadlock in SQL Server 2017 If you have problems with deadlock in SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. Keep transactions as short as possible. This can be used to reduce deadlock, because problems with locking typically occurs when several long-running transactions execute concurrently in the same database. The shorter the transaction,...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
SQL ISNULL function
(Rajendra Gupta) This article explores the SQL ISNULL function to replace NULL values in expressions or table records with examples.
Learning Containers
(Grant Fritchey) I find that I’m using containers more and more to get things done with SQL Server. They’re so easy to set up for testing, spin ’em up, do stuff, turn ’em off, done.
React Data Survival Kit
(Ryan Glover) Handling data in React can be treacherous if you don’t know your way around. Learn some common patterns for fetching, storing, and retrieving data in this guide to help you avoid messy code traps.
IBM Cloud Object Storage System Product Guide
(Bradley Leonard, Hao Jia, Johan Verstrepen, Jussi Lehtinen, Lars Lauber, Patrik Jelinko, and Vasfi Gucer) Object storage is the primary storage solution used in the cloud and on-premises solutions as a central storage platform for unstructured data.
Looking back at Some of the Changes in C# 6
(George Stocker) We’re currently on C# 7.4 and approaching C# 8 (Wow!); but C# 6 was the first version of C# post Roslyn (Compiler rewrite, to oversimplify it a bit). C# 6 was the first version of C# to coincide with .NET Core, and so it’s where the development of C# seemed to… skyrocket.