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
156 reads
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
896 reads
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
877 reads
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
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
Learn how to use the CData MySQL connector to access data across SSH.
2021-08-18
266 reads
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
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
Joe Celko explains how missing data is handled from the printing press to databases.
2021-07-26
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
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Well back at the end of 2019 I finished writing most of the checks...
By DesertDBA
I’m not sure how many of you use Change Data Capture (CDC) on your...
Comments posted to this topic are about the item A Key-value Cloud Database
Comments posted to this topic are about the item Working with Fail Activity in...
Comments posted to this topic are about the item Knowing When to Respond
Ask SSC