Get SQL server database size, location and volume info using DMVs
SELECT * FROM sys.master_files AS f
CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.file_id) v;
2018-04-23
331 reads
Configure Min and Max memory in Reporting Services
As any of the available SQL Server services, Reporting Services will use all of the server memory if needed, in...
2018-04-23
15,289 reads
Power BI Custom Visuals Class (Module 100 – Flow Map)
In this module you will learn how to use the Flow Map. The Flow Map is useful for tracking direction...
2018-04-23
516 reads
Presentation Tools
Let’s face it, the core of a presentation is you. Your knowledge and your ability to share that knowledge through...
2018-04-23
300 reads
Command shell steps in SQL Agent jobs only process a single command.
I was working on a SQL Agent job recently that required a series of command shell commands. And it would...
2018-04-23
942 reads
How to Perform Database Hack-Attach
This blog demonstrates attaching a database on the SQL Server Instance which already has the same name database up and...
2018-04-23
1,821 reads
Is this command broken? I can't see some properties! - DefaultDisplayPropertySet, Get-Member and Select-Object *
Every now and again I see some people complaining about not getting the properties they want when using a PowerShell command.
For instance, someone was using the Get-Service command to...
2018-04-23
10 reads
SQL Tuning: Finding statements for missing indexes
Missing indexes are an important part of the indexing strategy. I usually start with sys.dm_db_index_usage_stats to find both inefficient and...
2018-04-20
614 reads
Checking Tempdb with dbatools
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2018-04-20
1,584 reads
Monitoring and Tuning Azure SQL Database at SQL Saturday Jacksonville and 24 Hours of Pass
I’m speaking at two upcoming events that I wanted to share with you! My topic is Monitoring and Tuning Azure...
2018-04-20
304 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