How to Connect to an Analysis Services Database in Power BI
Learn how to work with SSAS data in Power BI in this article.
2022-07-18
5,541 reads
Articles
Taming Database Documentation with Flyway and MySQL
Database object documentation is essential for explaining to busy developers, and the wider business, the purpose of each object and how to use it. The solution presented in this article consists of a SQL script to allow developers to add comments to MySQL database objects, without affecting the database version, and a simple way to generate a documentation report, in JSON. The SQL script will execute automatically as a callback, during any Flyway Teams migration run, and the report will allow the team to spot any gaps quickly.
2022-07-18
T-SQL Comment Best Practices for SQL Server
Learn different ways to add comments to your T-SQL code when working with SQL Server along with several examples.
2022-07-18
Linked Servers: a Peek Behind the Curtain
Learn how a linked server caused an issue with Gallium Data.
2022-07-15
5,195 reads
[From the archives] Your guide to choosing the right monitoring tool [Video]
Join Grant Fritchey in this 35 minute video to learn his top tips for evaluating monitoring tools and vendors, the common pitfalls when implementing a new solution, and how you can demonstrate Return on Investment (ROI) to the business post-purchase.
2022-07-15
SQL Server 2022: Backup Database Options to AWS S3 Bucket - Part 2
In this article we look at how to backup a SQL Server 2022 database using AWS S3 storage along with all the supported backup options.
2022-07-15
How to Find the Start and End Dates for the Current Week (and more)
Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)
2022-07-13
33,655 reads
Cross-RDBMS Version Checks in Flyway
How does one check that a database is definitively at the version that Flyway says it is? Or that a test teardown procedure leaves no trace in the database? Or verify that an undo script returns a database's metadata to that state it should be in for the version to which you're rolling back? This article shows how to do high-level version checks, by comparing JSON models.
2022-07-13
SQL Server 2022: Backup and Restore database to AWS S3 bucket - Part 1
In this article we look at how to configure AWS to allow backup and restore from a SQL Server 2022 database using AWS S3 storage.
2022-07-13
Power BI Report Builder Parameters Tutorial
Learn how you can adjust the way users interact with reports and change font sizes as well as add parameters for filtering.
2022-07-11
15,353 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers