Daily Coping 27 Jan 2023
Today’s coping tip is to try something new to get out of your comfort zone. I did two things here. First, I’ve been participating in a Jan American Cancer...
2023-01-27
17 reads
Blog Posts
Getting Started Connecting to a Database with Flyway
In a previous post, I got Flyway installed as a CLI utility (command line interface). This post will look at the first connection to a database. If you need...
2023-01-27 (first published: 2023-01-11)
416 reads
Impact of Eliminating Implicit Conversions in JDBC Driver
Problem Recently I had a situation where I was looking at a SQL Instance due to a contractor who controls the system wanting to drop
The post Impact of Eliminating...
2023-01-27 (first published: 2023-01-18)
284 reads
Join Denny Cherry and Associates at SQL Bits 2023
I am very excited and lucky to be speaking once again at SQLBits along with my DCAC colleagues. SQLBits, the largest Data Platform conference in Europe, held this year...
2023-01-27
70 reads
Things to look out for while TDE is encrypting existing data
Monitoring for Problems The encryption of your existing data occurs as a background process referred to as the encryption scan, but it will consume resources while it runs, so...
2023-01-27
194 reads
Daily Coping 26 Jan 2023
Today’s coping tip is to focus on what’s good, even if today feels tough. Yesterday was a tough day. I got busy, distracted, had some bad news come up,...
2023-01-26
16 reads
Working With Tags in FlashArray using PowerShell
Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and Cloud Block Store. Starting in Purity 6.0, you can assign tags to objects. This post...
2023-01-26
78 reads
Daily Coping 25 Jan 2023
Today’s coping tip is to be gentle with yourself when you make mistakes. I forgot about a commitment. I had agreed to do a webinar and prepare some content....
2023-01-25
9 reads
Encryption, Comparing your Options in SQL Server
The question of encryption seems to be coming up a lot recently. I’ve had a number of people asking me about how to go about encrypting SQL Server. SQL...
2023-01-25 (first published: 2023-01-17)
454 reads
You can run a SQL Server Docker container on Apple M1 and M2 Silicon
Previously the only way to run SQL Server on Apple Silicon was via QEMU emulation or Colima (hat tip to Anthony Nocentino). Docker released beta support today for Apple’s...
2023-01-25 (first published: 2023-01-12)
198 reads
Blogs
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...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
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...
Alamat Kontak BCA KCP Comal Tlp,Cs:0821-8154-393
WA:08218154393 Grand Comal Residence, Jl. Raya Ahmad Yani No.20 Blok EA A19, Dusun II,...
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...
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