Attacks on Unsecured Databases
Unsecured databases are a problem, but someone is fighting this issue by wiping them out.
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 […]
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.
A Data Attack
A ransomware attack takes down Garmin, not just the company, but also Steve's data. He has a few thoughts about what this might mean for our data.
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 […]
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.
How to be an MVP
For those of you who haven’t heard of it, MVP stands for Most Valuable Professional. Microsoft gives this award to people in the community – not employees – who help teach the community at large about their products. The award can be given in one or more of the categories such as Data Platform, AI, […]
Finding Separation During WFH
Steve talks about working from home and finding ways to manage your work life balance.
Visualise SQL Server IO Stats
Visualise and compare the output of set statistics io on with Power BI to assist with performance tuning.
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.
Blogs
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Summer Speaking Summary 2025
By alevyinroc
In the blink of an eye, summer has passed. I don’t know about you,...
From Chaos to Clarity: How Microsoft Purview Streamlines Data Governance
By Chris Yates
In today’s digital landscape, data is both a strategic asset and a potential liability....
Forums
Change Tracking Data Retention Options
Comments posted to this topic are about the item Change Tracking Data Retention Options
Requiring Technical Debt Payments
Comments posted to this topic are about the item Requiring Technical Debt Payments
Using the FP-Growth Algorithm to Mine Useful Patterns in Data
Comments posted to this topic are about the item Using the FP-Growth Algorithm to...
Question of the Day
Change Tracking Data Retention Options
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);What are the possible choices for xxx? See possible answers