Author Power BI Reports on Real-Time ServiceNow Data
This article shows in detail how to use the Power BI Connector to create real-time visualizations of ServiceNow data in Microsoft Power BI Desktop.
2021-09-20
1,636 reads
database
Our Top Findings from The State of Database Monitoring Survey
Over 2500 global database professionals answered questions on their experiences with database monitoring in our annual survey earlier this year. We’re creating four reports from the findings and in our first, The real-world challenges of growing server estates, you’ll discover both insights and trends along with advice for how to tackle the most common challenges.
2021-09-13
Create, Populate, and Subset a Pandas Dataframe from a CSV File
In this article we demonstrate how to transfer data via a CSV file from a SQL Server database to a Pandas dataframe and then subset the dataframe in Python.
2021-09-03
Connect to MySQL Through SSH Using the CData MySQL Driver
Learn how to use the CData MySQL connector to access data across SSH.
2021-08-18
909 reads
Testing Flyway Migrations Using Transactions
When you are using Flyway, how can you test your database migration script first to make sure it works exactly as you intended before you let Flyway execute it? Phil Factor explains.
2021-08-16
Overcoming Database DevOps challenges - Part 1
When integrating database changes into a DevOps process, the biggest challenge is to standardize and coordinate the different approaches to application and database development. Discover the key tools & training resources to help you and your team.
2021-08-02
Much Ado about nothing: missing data
Joe Celko explains how missing data is handled from the printing press to databases.
2021-07-26
Peering into and Parsing Application Log Files
How to use PowerShell cmdlets, such as Select-String, to glance at the contents of the application logs, or use them in conjunction with Regular Expressions to sift through log files in detail looking for particular types of error.
2021-07-23
SQL Server Database Mirroring Inventory
In this article we look at a PowerShell script that can quickly retrieve information about all databases from all servers that are configured to use database mirroring.
2021-07-19
What is Redgate Deploy?
How Redgate Deploy will help you ensure that databases and applications can grow and develop in step, and to implement a workflow for delivery of database changes that is resilient, repeatable, fast and visible.
2021-07-19
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers