The Invisible Disk
Steve sees disk drives as shrinking to the point of being invisible to most of us.
Steve sees disk drives as shrinking to the point of being invisible to most of us.
Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or semi-structured data. Because of its heavy usage in applications today, it inevitably will make its way into databases where it will need to be stored, compressed, modified, searched, and retrieved.
I used to think I knew everything. I felt like I had the world all figured out. But then, when I went to kindergarten, I realized that I didn't know much at all. As I grew older and finished college, I regained confidence in my knowledge and again felt like I knew everything about the […]
I got a new laptop recently and instead of installing SQL Server, I decided to try and use containers to see how well this works. This article looks at how I got this working relatively quickly. The short list of things I did is: Install Docker Desktop Create a location for data/logs/etc. Create a docker-compose […]
Learn about rounding values using T-SQL and how the ROUND function works compared to creating a user-defined function for bankers rounding.
This level looks in detail at what happens when we update or delete data from a clustered columnstore index, the impact it has on concurrent data access, and how without careful maintenance the efficiency of columnstore indexes can degrade over time.
I don’t get it. I’ve given this feature one chance after another, and every time, it takes a smoke break rather than showing up for work.
I would like to share my recent experience with Azure Data Factory (ADF) where AutoResolveIntegrationRuntime become corrupted and how did I recover it. I still don't know how the Integration Runtime (IR) was corrupted. However, if it happens, then this article will help you to solve the issue. Problem In general, the ADF AutoResolveIntegrationRuntime should […]
I'm excited to tell you about the "SQL from A to Z" learning track....
The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.
By Steve Jones
feresy – n. the fear that your partner is changing in ways you don’t...
Comments posted to this topic are about the item The Cloud Security Problem, which...
I have a table like below ID Ident source val opendate closedate IsActive --------------------------------------------------------...
Good Afternoon, We recently procured a service management software for our company, which uses...
In SQL Server 2022, what does this statement do?
CREATE STATISTICS CustomerStats1 ON DimCustomer (CustomerKey, EmailAddress) WITH AUTO_DROP = ONSee possible answers