T-SQL Tuesday #121: Gifts received for this year
At the end of 2019, Mala (b|t) invites us to write about the gifts we’ve gotten during the year. I’ve been gifted with a lot of things this year personally...
2019-12-10
5 reads
Blog Posts
T-SQL Tuesday #121: Gifts received for this year
At the end of 2019, Mala (b|t) invites us to write about the gifts we’ve gotten during the year. I’ve been gifted with a lot of things this year personally...
2019-12-10
5 reads
T-SQL Tuesday #121: Gifts received for this year
It’s T-SQL Tuesday time again! This edition is hosted by Malathi (blog|twitter) and the subject is looking back at the past year. So what do I have to be...
2019-12-10
13 reads
T-SQL Tuesday Gifts (#121)
It’s that time of month. I missed last month while traveling, but I wanted to get back in the party. This month, Mala has invited us to talk about...
2019-12-10
20 reads
Azure SQL Database – Automatic Tuning – Have you enabled it?
Do you enable this setting to allow automatic tuning to care of all your performance needs? Well not ALL your needs, more so: CREATE INDEX DROP INDEX FORCE LAST...
2019-12-09
69 reads
Building an Azure Sandbox – Part 1 – The Basics
I recently posted that I was doing my annual Azure sandbox rebuild but this time I wanted to do things a little differently…all in PowerShell. Unlike previous years when...
2019-12-09 (first published: 2019-11-25)
747 reads
SQLSaturday Orlando Notes – Large Printed Schedules
One of the things we’ve done most years in Orlando is to print poster sized schedules. This started out as a supplement to giving everyone a printed schedule and...
2019-12-09
16 reads
Upgrading Windows 10 Home to Pro
I use Hyper-V and a few other things that require Windows 10 Pro. When I got my new laptop, it had Windows 10 home on it. Not a big...
2019-12-09
96 reads
What would you say you do here?
The other day, I was looking back at an excellent blog post my colleague Jamie Wallis wrote about what Product Marketing Managers do at Redgate. I really like the...
2019-12-09
9 reads
When a SQL UPDATE Statement DELETES Rows
Watch this week’s episode on YouTube. At first I wasn’t going to write this post. I thought it would be too simple. Then I watched two experienced SQL developers...
2019-12-09 (first published: 2019-11-26)
2,108 reads
Blogs
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
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...
The Joyful Craftsmen and the Revolt BI join forces
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
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 Kantor BCA KCP Galuh Mas Telp:08218154398
WhatsApp:0821-8154-398 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
Alamat Kantor BCA KCU PONDOK INDAH Telp:08218154398
WhatsApp:0821-8154-398 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, Kec....
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