Power BI - How to Download and Get Started
In this article learn how to download, install and get started building your first Power BI report using SQL Server data.
2022-07-22
In this article learn how to download, install and get started building your first Power BI report using SQL Server data.
2022-07-22
A brief history of the DevOps movement and a discussion of the pivotal role of a tool like Flyway in the DevOps toolchain, when developing and delivering database changes.
2022-07-20
PostgreSQL database performance is critical for application performance. EzzEddin Abdullah shows how to get information about a query’s performance from the execution plan.
2022-07-20
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
Learn different ways to add comments to your T-SQL code when working with SQL Server along with several examples.
2022-07-18
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
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 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
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
During Build 2022, Microsoft announced a new feature, Datamarts for Power BI. MVP Dennes Torres explains this new feature and provides and example.
2022-07-11
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have...
Comments posted to this topic are about the item Enable a Disabled Index
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers