Phil Factor provides SQL routines to extract data from and load data into a SQL Server database, using BCP, and then a PowerShell automation script that uses Flyway to automatically build a database, from scratch and then fill it with data, ready for testing.
2021-03-10
In this article learn some TSQL tips and tricks working with CTEs, UPDATES, Window Functions, Duplicate Rows, Tally Tables and Concatenating string values in SQL Server
2021-03-10
Many devs and IT professionals looking for the next career wonder how to become a data scientist. Ashwin Thota matches up skills to job titles.
2021-03-09
Create a quick application that stores your favorite queries that you can use to quickly connect to any server and return the results.
2021-03-08
The latest State of Database DevOps report has been published and it’s packed with data from over 3000 IT professionals. You’ll learn about the latest DevOps trends, industry insights, and tips from contributors such as Pramod Sadalage and Kendra Little. Get your free copy.
2021-03-08
Did you miss the excellent presentations from DevOps experts Pramod Sadalage, Kellyn Pot’Vin Gorman, Samir Behara, and Kendra Little? Good news – all Redgate Summit sessions are available on-demand now. Choose from ‘the future of database DevOps’ keynote, latest DevOps trends, Q&A discussion, and demos.
2021-03-05
Power BI has a new feature which is the Power BI Small Multiples visual. In this article we cover how to enable this feature and also walk through an example of how to use this in a Power BI report.
2021-03-05
Since its initial release in 1989, SQL Server has come a long way from its base functionality as an enterprise level database platform. While the core of SQL Server is still it's database engine, it is now so much more than just a relational database plat
2021-03-04
Learn how to create a customizable calendar date table that can be used for Power BI reports using Power Query.
2021-03-03
There is no shortage of PowerShell editors and environments for developing and running scripts. Greg Moore explains some of his favorites.
2021-03-03
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers