Power Bi, PowerShell and SQL Agent Jobs
Continuing my series on using Power Bi with my DBA Database I am going to show in this post how...
2015-10-01 (first published: 2015-09-28)
4,216 reads
SQL DBA With A Beard
Populating My DBA Database for Power Bi with PowerShell – Databases
Following my post about using Power Bi with my DBA Database I have been asked if I would share the...
2015-09-22
855 reads
Enterprise Strategies – A #TSQL2sDay post
This months TSQL2sDay blog post party is hosted by Jen McCown and is about Enterprise Strategy.
Adam Mechanic started TSQL Tuesdays...
2015-09-08
594 reads
Populating My DBA Database for Power Bi with PowerShell – SQL Info
Following my post about using Power Bi with my DBA Database I have been asked if I would share the...
2015-09-07
918 reads
Use Twitter to get #PowerShell help
A quick post today just to add some weight to something that Mike Fal b | t has kicked off. The #SQLHelp...
2015-09-06
493 reads
Populating My DBA Database for Power Bi with PowerShell – Server Info
Following my last post about using Power Bi with my DBA Database I have been asked if I would share...
2015-09-09 (first published: 2015-08-31)
2,497 reads
Using Power Bi with my DBA Database
Every good DBA should have a DBA database. A place to store information about all of their instances and databases.
I...
2015-08-21 (first published: 2015-08-16)
4,319 reads
Setting Up and Using Azure VM SQL Automated Backup (and Restore)
This weekend I was creating some Azure VMs to test and was required to use the GUI for some screenshots....
2015-07-24
1,493 reads
Installing and upgrading default scripts automation – part one – Introduction
First I must say thank you to all of the wonderful people who have put time and effort into providing...
2015-06-16 (first published: 2015-06-08)
1,760 reads
Scheduling Ola Hallengrens Maintenance Solution Default Jobs with Powershell
If you are a SQL Server DBA you should know about Ola Hallengren and will probably have investigated his Maintenance...
2015-05-20 (first published: 2015-05-06)
5,889 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers