Monday Coffee: Should I learn powershell?
This month’s T-SQL Tuesday’s topic was set by Rob Sewell (b|t) and entitled Let’s all get PoSH
It had a massive...
2017-09-18
814 reads
Generate Markdown Table of Contents based on files within a folder with PowerShell
Last week I was talking with Constantine Kokkinos (b | t) about generating a Table Of Contents (TOC) for a GitHub repository.
He wrote a cool blog post - Generating...
2017-09-18
14 reads
SQL Server database basics
So today I'll talk about some of the basic items for SQL server that helps to understand the reason of some performance recommendations. This first post will list and...
2017-09-16
18 reads
SQL Server database basics
So today I'll talk about some of the basic items for SQL server that helps to understand the reason of...
2017-09-16
143 reads
I want a new gadget with less features
Years ago I bought a Pebble smartwatch. I didn’t back the Kickstarter, but a few friends did and I liked...
2017-09-15
910 reads
PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed
PASS has continues to ramp up the plans for the PASS Summit in Seattle this October, and my precon session, “Virtual...
2017-09-15
165 reads
PASS Summit 2017 Precon – Virtual SQL Servers: Right to Ludicrous Speed
PASS has continues to ramp up the plans for the PASS Summit in Seattle this October, and my precon session, “Virtual...
2017-09-15
370 reads
The Code Coverage Report
I had someone that told me recently that they needed to find a way to get code coverage in T-SQL....
2017-09-15
868 reads
Friday Reading 2017-09-15
Excited for next week as I’m heading down to Cork to speak at the User Group there. Over 3 years...
2017-09-15
374 reads
Error Processing Tabular – Method Not Found
Very quick blog post today. While setting-up a development server at a client who is still using SQL Server 2012,...
2017-09-15
387 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers