Create Azure Data Factory inventory using Databricks
Learn how to build a catalog of your different Azure Data Factory objects such as pipelines, activities, datasets and more.
2020-08-17
Learn how to build a catalog of your different Azure Data Factory objects such as pipelines, activities, datasets and more.
2020-08-17
Learn How to Get Started with SQL Server Management Studio with Brent Ozar.
2020-08-14
The first part of this article focuses on using an R program to find a linear regression equation and the second part is devoted to simple linear regression analysis.
2020-08-13
In this article we continue our series of using PowerShell to monitor SQL Server by collecting the last run information for SQL Server Agent Jobs.
2020-08-12
Check out this article to see how to quickly import into SQL Server many files with the same structure using T-SQL.
2020-08-11
No discussion about storage is complete without thinking about security of the data. In this article, Robert Sheldon explains what must be considered to protect data in today's world.
2020-08-10
SQL Multi Script can easily be persuaded to run queries at the server level rather than the database level. It is also able to combine results from many databases even if the results aren't identical but have some different columns. Phil Factor demonstrates how this works, when collecting a set of performance counters from all databases on a distribution list of servers.
2020-08-07
Microsoft provides Azure DevOps for hosting your repos, setting up pipelines and more. In this article, Diogo Souza shows you how to get started using Azure DevOps.
2020-08-07
In the final article of this series, Edward Pollack demonstrates the maintenance of columnstore indexes. He also takes a look at nonclustered columnstore and memory-optimized columnstore indexes.
2020-08-06
Redgate have assembled a small development team to research and build a capability that not only records your deployments over time, but provides a window into past trends and insights. To achieve the best results we need to understand from you what deployment value should be recorded and displayed. Please help us by completing our short two-page survey.
2020-08-06 (first published: 2020-07-27)
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
Please, let me reiterate: The only valid test of a backup is a restore....
This prominent casino in Canada prioritizes the safety and enjoyment of its guests. It...
We are trying to update a sqlservice account from a user account to a...
Hi there! This should make some eyes roll for some of you DBA's out...
If I run the Data Migration Assistant to check for an upgrade from SQL Server 2008 to SQL Server 2022, which categories of issues are pointed out as potential items that can affect an upgrade? (choose 3)
See possible answers