Handling Inconvenient Requests
Brad gives a little guidance on how you might want to respond to inconvenient requests with an eye on doing yourself a favor.
Using a Derived Table to Compare Data with Values from a Previous Year
Comparing year on year sales is a fundamental requirement in much commercial analysis - here you learn how to do this in SQL
Understanding your Azure EA Billing Data and Building a Centralized Data Storage Solution
Many organizations are moving to Azure and other cloud providers. Understanding how resources are being used and what is spent is very important. In this article, Feodor explains his solution for automating the collection of the Enterprise Agreement billing from Azure into an Azure SQL Database where it can be analyzed.
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.
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers