Getting Started with Mssql-cli tool
A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements and business...
2018-06-12
262 reads
I’m published at Simple-Talk!
My first article has gone live at Simple-Talk! Thanks to Aunt Kathi for the opportunity!
Detecting Data Breaches
I’m also still writing...
2018-06-12
337 reads
Moving to Azure: A change in processes – TSQL Tuesday 103
For this month’s t-sql Tuesday our host Bjoern Peters (b/t) wants us to describe our experiences with Azure SQL Database...
2018-06-22 (first published: 2018-06-12)
2,402 reads
Prioritizing Index Performance Pains – What I Learned From Brent Ozar’s Master Index Tuning Class
I love continuing my education in SQL Server. Recently I was fortunate enough to take Brent Ozar’s 3-day live online...
2018-06-21 (first published: 2018-06-12)
2,491 reads
Prioritizing Index Performance Pains - What I Learned From Brent Ozar's Master Index Tuning Class
Watch this week's video on YouTube
I love continuing my education in SQL Server.
Recently I was fortunate enough to take Brent Ozar's 3-day live online Master Index Tuning training class.
Since...
2018-06-12
25 reads
Prioritizing Index Performance Pains - What I Learned From Brent Ozar's Master Index Tuning Class
Watch this week's video on YouTube
I love continuing my education in SQL Server.
Recently I was fortunate enough to take Brent Ozar's 3-day live online Master Index Tuning training class.
Since...
2018-06-12
14 reads
Changing the Collation of the Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?
Demystifying What “sqlservr -q” Actually Does
(last updated: 2019-01-07 @ 02:25 EST / 2019-01-07 @ 07:45 UTC )
For various reasons, people sometimes find themselves...
2018-06-19 (first published: 2018-06-12)
8,784 reads
More Changes to PoshSSDTBuildDeploy - DeployReport Information
Hello!
This is going to be a short one because I’ve been working hard all evening on this, and frankly I’m a little tired. But I’ve made a change to...
2018-06-12
23 reads
Notes on the May 2018 SQLOrlando Meetup
Late writing notes!
55 registered, 28 attended. Not bad, and about on track for expected 50% drop. Really, 28 made for...
2018-06-11
287 reads
Analyzing Feedback From Music City Tech 2018
I recently presented two sessions at Music City Tech and just received my feedback. I got great feedback and looks...
2018-06-22 (first published: 2018-06-11)
1,471 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