The hidden security of msdb
To be fair it’s not actually hidden, just not so well known.
Have you ever wondered how to grant permissions...
2015-04-20
1,506 reads
Blog Posts
The MERGE Statement – One Statement for INSERT, UPDATE and DELETE
Starting with SQL Server 2008, we can use the MERGE statement to solve some every day scenarios in more elegant...
2015-04-20
2,294 reads
T-SQL HOST_ID and HOST_NAME
HOST_ID and HOST_NAME
Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL...
2015-04-20
3,518 reads
Clustered Columnstore Indexes – part 51 (“SSIS, DataFlow & Max Buffer Memory”)
Continuation from the previous 50 parts, the whole series can be found at http://www.nikoport.com/columnstore/
This post is dedicated to usage of...
2015-04-19
1,111 reads
How CONCAT_NULL_YIELDS_NULL behave with computed columns In Sql Server
Hi friends, in this blog I am going to tell you about effect of CONCAT_NULL_YIELDS_NULL for computed columns while creating...
2015-04-18
227 reads
How index gets dropped in Views in SQL Server
Hi Friends, In this blog I am going to tell about dropping of indexes in view in SQL Server. Views...
2015-04-18
272 reads
Heraflux is Hiring
I’m proud to announce my company, Heraflux Technologies, is looking to fill the position for Vice President of Business Development....
2015-04-17
452 reads
On Failure: On Being a Screw-Up
“He’s a screw-up. Always trying things that don’t work.”
I’ll be honest: I used to be afraid of being the person...
2015-04-17 (first published: 2015-04-09)
5,687 reads
On Software and OS Lifecycle Management
An Important Rule:
If you’re trying to convince someone to your viewpoint, insulting them generally doesn’t work. If it does anything,...
2015-04-17
300 reads
Overview of the data visualization books by Stephen Few
I recently finished the book Now You See It: Simple Visualization Techniques for Quantitative Analysis by Stephen Few of Perceptual...
2015-04-17 (first published: 2015-04-07)
7,371 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers