SQL Server on Linux Series: Additional Drives
One of the biggest differences with managing SQL Server Linux is with drive presentation. With Windows, we’d all scream if...
2017-08-09 (first published: 2017-07-24)
1,655 reads
Blog Posts
SQL Server vs Oracle: Top N rows
In today’s continuation of the SQL / Oracle series, I thought it’d be nice to show how different the two are...
2017-08-09
299 reads
SQLCLR vs. SQL Server 2017, Part 2: “CLR strict security” – Solution 1
As mentioned in Part 1 of this “SQLCLR vs. SQL Server 2017” series, the new clr strict security server-level configuration...
2017-08-09
971 reads
Statistics and the Ascending Key Problem
I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at...
2017-08-09 (first published: 2017-07-25)
7,704 reads
This is how I recovered from a catastrophic failure
I was fresh off the boat* from South Africa, working in a small computer store in an equally small town...
2017-08-09
155 reads
Using PowerShell to check if your password has been in a breach
We know that we need to keep our credentials secure. We know that we should not re-use our passwords across...
2017-08-09
1,596 reads
#TSQL2sday: Interviewing Patterns
This T-SQL Tuesday is hosted by Kendra Little.
I’ve been told interviewing is an art. Perhaps it is. I view it...
2017-08-08
323 reads
A Quick Start Guide to Managing SQL Server 2017 on CentOS/RHEL Using the SSH Protocol
This article details the following
How to get PuTTY and SQL ServerHow to install/uninstall SQL 2017 CTP2.1How to Upgrade to SQL...
2017-08-08
471 reads
Capturing Perfmon Counters With Telegraf
Setting up Telegraf to Capture Metrics I had a lot of issues with getting the GO enviroment setup in windows, this time and previous times. For using telegraf, I'd...
2017-08-08
50 reads
Capturing Perfmon Counters With Telegraf
InfluxDb & Grafana Series
Running InfluxDb As A Service in WindowsSetting Up InfluxDb, Chronograf, and Grafana for the SqlServer Dev
InfluxDB And AnnotationsCapturing...
2017-08-08
796 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