SQL Server Database Experimentation Assistant - How to Run a Capture
DEA
Very basic look at the setup as I couldn’t find much documentation on this when I last tried this out in 2018. Maybe it will help you get started...
2019-02-07
1 reads
Sheldon Hull
Dedupe Google Drive with RClone
An issue with duplicates
I migrated from Amazon Cloud Drive to a paid Google Drive account. To facilate this move, I used a paid service called MultCloud. For me, Comcast...
2018-08-19
4 reads
NTFS Compression and SQL Server Do Not Play Well Together
Wanted to be proactive and move a database that was in the default path on C: to a secondary drive as it was growing pretty heavily.
What I didn’t realize...
2018-08-08
18 reads
NTFS Compression and SQL Server Do Not Play Well Together
Wanted to be proactive and move a database that was in the default path on C: to a secondary drive as it was growing pretty heavily.
What I didn’t realize...
2018-08-08
1 reads
SQL .NET Requirements
SQL Server Install Requirements
SQL Server Installation requirements indicate .NET 3.5, 4.0, or 4.6 depending on the version. This is not including SSMS. At this point you shouldn’t use SSMS...
2018-07-12
82 reads
SQL .NET Requirements
SQL Server Install Requirements
SQL Server Installation requirements indicate .NET 3.5, 4.0, or 4.6 depending on the version. This is not including SSMS. At this point you shouldn’t use SSMS...
2018-03-30
1 reads
Ultrawide Monitor - Samsung CF971 - First impressions
As a developer, I’ve been a big fan of multiple monitors for a long time. I moved to a triple...
2017-08-15
223 reads
Fixing VirtualBox Only Showing 32bit Windows OS Options
Original help was identified from this article Why is VirtualBox only showing 32 bit guest versions on my 64 bit...
2017-08-10
119 reads
Exploring SQL Server With Powershell And SMO Basics
SqlServer Powershell Cmdlets 2017 - Initialize Look
Diving into the Sql Server Management Objects library can be a pretty interesting process. You...
2017-08-09
1,090 reads
Exploring SQL Server With Powershell And SMO Basics
SqlServer Powershell Cmdlets 2017 - Initialize Look Diving into the Sql Server Management Objects library can be a pretty interesting process. You get to work with database objects as...
2017-08-09
3 reads
Blogs
Microsoft Build event announcements
By James Serra
There were a number of data platform announcements at Microsoft Build yesterday that I...
Data is not immutable
Information — in the form of data — usually stored as binary 1s and...
Daily Coping 25 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SQL Server Data Discovery and Classification - times out...
The powers that be have commanded that we implement data classification because... well, to...
How to Navigate through folders to find .zip file
Is there any script task in SSIS to find the zip files under each...
Ask SSC