CI and CD Aren't Magic
The techniques for Continuous Integration (CI) and Continuous Delivery (CD) don't make software better by themselves. It takes some investment and work by your staff as well.
Rolling up multiple rows into a single row and column for SQL Server data
Do you need a way to roll-up multiple rows into one row and one column. You know you can roll-up multiple rows into one row using Pivot, but you need all of the data concatenated into a single column in a single row. this tip looks at a simple approach to accomplish this.
Finding a String Anywhere in Another String
Optimize searching for a string within another string with this string storage and indexing technique.
Have You Been Hacked?
Security is a big deal, and Steve Jones wonders if most data professionals would be aware that they had been hacked.
Introduction to Azure Cosmos DB Global Distribution
Global distribution of updatable data stores is one of the more challenging goals that software designers and architects have been struggling with over the years. Addressing this challenge has become increasingly pressing as the rapid growth of cloud technologies increased the need for deployments capable of spanning multiple geographical areas. In this article, we will provide an introduction to global distribution-related functionality in Cosmos DB.
Building RESTful APIs using Node JS, Express JS, and MS SQL Server
This post covers the basic details that you need to know while developing a RESTful API using Node, Express and SQL Server.
When someone asks you what you do for work, how do you answer?
In many ways job titles matter, just not when telling a stranger what you do for work.
Why Volunteering May be a Bad Idea for You
Recently, as I was doing some work for the upcoming PASS Summit, a question popped in my head: “Why am I doing this?” It reminded me of the time when I was young (and idealistic). I went to the leader of a non-profit group asked about making it my permanent vocation. The leader looked at […]
Power BI Introduction: Working with SQL Server data in Power BI Desktop — Part 5
Data for Power BI can come from many sources, but often the data is hosted in SQL Server. In this article, the fifth of the series, Robert Sheldon demonstrates how to work with SQL Server data in Power BI Desktop, including relationships between tables.
Connect to Salesforce Data as a Linked Server
Use the TDS Remoting feature of the ODBC Driver to set up a linked server for Salesforce data.
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers