Clustered Column Store Load Pitfalls – Magic number 64 when using WHERE IN clause
The Problem
During our workload we have recognized a difference in performance for queries using IN clause. We are building query...
2018-12-18
181 reads
MongoDB – Docker Install
Docker and Container making my life great. these days I can explore every thing using this. I have installed MongoDB...
2018-12-18
311 reads
SSIS Catalog Execution Parameter Values
When doing any new development or major overhaul of existing SSIS architecture, I almost always recommend to clients that they deploy those packages to the SSIS catalog. Using the...
2018-12-18
28 reads
SSIS Catalog Execution Parameter Values
When doing any new development or major overhaul of existing SSIS architecture, I almost always recommend to clients that they...
2018-12-18
349 reads
How to automatically Discover SQL Server instances
DBAs have plenty of day-to-day tasks to do as part of the administration, but one overarching task is managing the...
2018-12-17
254 reads
The Data Catalog from Redgate
One of the important tasks that is needed for any organization that wants to better protect their sensitive data is...
2018-12-17
358 reads
Azure Data Factory Data Flow
Azure Data Factory v2 (ADF) has a new feature in public preview called Data Flow. I have usually described ADF as an orchestration tool instead of an Extract-Transform-Load (ETL)...
2018-12-17
85 reads
Azure Data Factory Data Flow
Azure Data Factory v2 (ADF) has a new feature in public preview called Data Flow. I have usually described ADF...
2018-12-17
548 reads
Why do we think water and databases are similar?
It’s 20 years since Google was launched, the Euro was agreed, and the Three Tenors sang at the World Cup opening ceremony. That was also the year (1998) when...
2018-12-17
23 reads
Why do we think water and databases are similar?
It’s 20 years since Google was launched, the Euro was agreed, and the Three Tenors sang at the World Cup...
2018-12-17
232 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers