DBA Definitions: FILLFACTOR
It was recently brought to my attention that not everyone knows everything. This was a shock. Everyone is born knowing...
2017-11-06
567 reads
Azure SQL Database Compatibility Levels
Let’s start off with a quick overview of SQL Server versions and compatibility levels.
100 = SQL Server 2008 and Azure SQL...
2017-11-06
525 reads
Getting Query Execution Statistics
If you hate things that are slow, I bet you certainly want to know the reason for the slowness. So,...
2017-11-17 (first published: 2017-11-06)
6,180 reads
SSDT How To Fix Error SQL17502
TLDR:
If you build an SSDT project you can get an error which says:
"SQL71502: Function: [XXX].[XXX] has an unresolved reference to...
2017-11-06
1,095 reads
SSDT How To Fix Error SQL17502
TLDR: If you build an SSDT project you can get an error which says:
“SQL71502: Function: [XXX].[XXX] has an unresolved reference to object [XXX].[XXX].”
If the code that is failing is...
2017-11-06
35 reads
SSDT How To Fix Error SQL17502
TLDR: If you build an SSDT project you can get an error which says:
“SQL71502: Function: [XXX].[XXX] has an unresolved reference...
2017-11-06
118 reads
SSDT How To Fix Error SQL17502
TLDR: If you build an SSDT project you can get an error which says:
“SQL71502: Function: [XXX].[XXX] has an unresolved reference...
2017-11-06
43 reads
SSISDB for SQL Server Integration Services
Microsoft introduced some major changes in SQL Server Integration Services with SQL Server 2012.
Brand new “SSISDB” database launched as SSIS...
2017-11-16 (first published: 2017-11-06)
24,119 reads
dbatools at PASS Summit 2017
I registered for Summit about a month before getting actively involved in the dbatools project, so when I saw the team was running a pre-con and I was going...
2017-11-06
14 reads
PASS Summit 2017 – the best ever
I have been a PASS summit attendee for 14 years now. This year is my 15th. Every year is different...
2017-11-05
712 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