Using Simple Linear Regression to Make Predictions
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
Articles
SQL Server Agent Job Monitoring for Last Execution
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
Azure Data Factory : Your First Data Pipeline
Introduction Azure Data Factory is the cloud-based ETL and data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. We can create and schedule data pipelines which can move data between various supported data stores. We can also use for data transformation before loading it into […]
2020-08-11
11,375 reads
SQL Server Bulk Insert for Multiple CSV Files from a Single Folder
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
Protect SQL Databases with Dell EMC PowerProtect and DataDomain Under VMware
Introduction We are now in the data era – data is growing at rapid space, being processed in different ways, and becoming more distributed across data centers and clouds. Thus databases are also growing and they are stored and protected in various ways depending on business objectives. As more organizations continue to move application and […]
2020-08-10
2,322 reads
Storage 101: Data Security and Privacy
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
Visualise SQL Server IO Stats
Visualise and compare the output of set statistics io on with Power BI to assist with performance tuning.
2020-08-07 (first published: 2018-12-18)
6,146 reads
Gathering SQL Server Performance Counters for Multiple Servers
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
Getting Started with Azure DevOps
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
Hands-On with Columnstore Indexes: Part 3 Maintenance and Additional Options
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
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers