2021-10-08
1,794 reads
database
Building blocks of Extended Events data collection
Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of Extended Events data collection.
2021-10-04
What Do You Want to Know Before Negotiating Salary?
It's almost time for Brent Ozar's annual salary survey. Steve reminds you that you can influence the questions, but more importantly, take the survey and provide data for all of us.
2021-10-02
202 reads
Connect to SAP HANA Data as a Linked Server
The SQL Gateway enables you to configure a TDS (SQL Server) remoting service and set up a linked server for SAP HANA data. After you have started the service, you can use the UI in SQL Server Management Studio or call stored procedures to create the linked server. You can then work with SAP HANA data just […]
2021-09-29
1,251 reads
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,196 reads
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
361 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
Blogs
So You Want to Deploy Power BI Project files (PBIPs)?
By Angela-Henry
Have you heard the news about the new Power BI Project files? Okay, maybe...
DBAs, Organizing Your SQL Scripts in Git
By Steve Jones
I wrote an article that was published on SQL Server Central on how to...
Only Capture Extended Events For a Given Time
It’s a great question. Let’s say you want to capture stored procedure completions. But,...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers