Agent Phases in VSTS Deployment
VSTS (Visual Studio Team Services) continues to grow and change over time. It seems every few months I see some...
2017-04-17
1,675 reads
The Dead Tree Database
“We have all of that information. It’s in a database in my office.” This phrase was music to my ears....
2017-04-27 (first published: 2017-04-17)
1,552 reads
Normal approximation to binomial distribution using T-SQL and R
In the previous post I demonstrated the use of binomial formula to calculate probabilities of events occurring in certain situations....
2017-04-17
1,469 reads
Making VSTS Deployment Changes to Databases without Breaking Your Application
One of the things that I do a lot is demo changes to databases with CI/CD in a DevOps fashion....
2017-04-17
806 reads
DBA 101: Comparing two SQL plans
Simple post today: How to compare two plans in SSMS.
This task is a task that is often done by a...
2017-04-18 (first published: 2017-04-14)
2,053 reads
Way Off-topic: Why cutting the cord was right for me
FYI: This one is way off topic so don’t expect to find any fancy SQL tips here.
I did it. I...
2017-04-14
498 reads
Power BI and Data Security – Row Level Security (RLS)
As Power BI becomes more prevalent in data analytics and visualization within the enterprise, data security becomes a significant concern....
2017-04-25 (first published: 2017-04-14)
1,949 reads
Microsoft Data Platform – MVP 2017!!!
I’m very pleased and delighted to share that I have been awarded Microsoft Most Valuable Professional (MVP) award 2017. This...
2017-04-14
451 reads
SQL Saturday Christchurch 2017
Dear All,
Last week, I had travelled to the beautiful city of Christchurch, for speaking in SQL Saturday South Island. This is by far the farthest I have travelled for...
2017-04-14
18 reads
SQL Saturday Christchurch 2017
Dear All,
Last week, I had travelled to the beautiful city of Christchurch, for speaking in SQL Saturday South Island. This is by far the farthest I have travelled for...
2017-04-14
30 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers