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,153 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
850 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
590 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
914 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
491 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,493 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,269 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,487 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,753 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,888 reads
Blogs
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
T-SQL Tuesday #190–Mastering a New Technical Skill
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Forums
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Change Tracking Data Retention Options
Comments posted to this topic are about the item Change Tracking Data Retention Options
Requiring Technical Debt Payments
Comments posted to this topic are about the item Requiring Technical Debt Payments
Question of the Day
Change Tracking Data Retention Options
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);What are the possible choices for xxx? See possible answers