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
8 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
20 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
34 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
10 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
129 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
14 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
259 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
131 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,123 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
25 reads
Blogs
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers