Setting up Cross Database Queries in Azure SQL Database
A question that I answer what seems like all the time is how to run cross-database queries against Azure SQL...
2017-06-12 (first published: 2017-05-30)
3,634 reads
Blog Posts
SQL Server 2017 – DMF – sys.dm_db_log_info
The release of Microsoft SQL Server 2017 brought a lot of very interesting new features. One of them is the...
2017-06-12
976 reads
SQL Server 2017 Graph Data Features In Action
The Wikipedia Graph Database page has the following definition…
In computing, a graph database is a database that uses graph structures...
2017-06-12
111 reads
SQLSaturday Houston 2017 - I'll be there, will you?
Looking forward to combining a work trip with a SQLSaturday trip to Houston this week!
Will be happy to see the...
2017-06-12
379 reads
SSDT: Unable to connect to master or target server.
Every now and then I come across this error in SSDT, normally when trying to publish and the odd thing...
2017-06-12
55 reads
SSDT: Unable to connect to master or target server.
Every now and then I come across this error in SSDT, normally when trying to publish and the odd thing...
2017-06-12
53 reads
SSDT: Unable to connect to master or target server.
Every now and then I come across this error in SSDT, normally when trying to publish and the odd thing...
2017-06-12
2,979 reads
SSDT: Unable to connect to master or target server.
Every now and then I come across this error in SSDT, normally when trying to publish and the odd thing is that the description never matches the actual cause...
2017-06-12
11 reads
VS Code – Automatic Dynamic PowerShell Help
VS Code is my coding tool of choice. I love that one lightweight editor can do so much and as...
2017-06-12
577 reads
VSTS–Changing the Default Build Queue
I wrote recently about the Release agent using the hosted queue as the default, which is sometimes a problem. The...
2017-06-12
547 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