New Job -> Week 3 -> Creating Alerts
This is part of a series of new job blog posts. You can find them all here. The main goal for week 3: setup much needed alerts on DTU...
2023-03-31 (first published: 2023-03-30)
184 reads
Blog Posts
SQL Bits 2023 Recap
I had an amazing time adventuring to Wales with other members of the data community last week! It was my first international conference, and I had heard so many...
2023-03-31 (first published: 2023-03-23)
254 reads
The AI T-SQL Tuesday–#160
It’s time for T-SQL Tuesday again, and this time there is an interesting invitation. Damien Jones reached out and wanted to host, so he gets to pick the topic...
2023-03-31 (first published: 2023-03-14)
264 reads
My personal experience using kubecost in Kubernetes environment
What is Kubernetes? Kubernetes which is also referred to as k8. k8 is an open-source container orchestration platform that automates deployment, scaling, and management of the containerized application. k8...
2023-03-29 (first published: 2023-03-19)
159 reads
WIT/DEI Mental Health and Wellness Day Challenge to Present
Back in December 2019, I started presenting my session on mental health with lots of fear as to how the community was going to take
The post WIT/DEI Mental Health...
2023-03-29 (first published: 2023-03-24)
103 reads
Tales From The Field Weekly Wrap Up for the Week of 03-20-2023 & Kiddos Growing Up
William, right, 11 years ago the morning of our college tour Hello Dear Reader! When I got off the plane from SQLBits I wasn't feeling great. To be honest, I...
2023-03-28
47 reads
Building, Deploying, Sharing a Remote Jupyter Book in Azure Data Studio
When working with Azure Data Studio and its support of Jupyter books, you will find there is an option for remote Jupyter books. As shown in the image below,...
2023-03-27 (first published: 2023-03-16)
373 reads
KQL Series – ingesting data with Azure Data Factory
Background: Azure Data Explorer is a powerful analytics service that allows us to quickly ingest, store, and analyze large volumes of data from various sources. Azure Data Factory is...
2023-03-27 (first published: 2023-03-19)
357 reads
SQL Server 2022 Administration Inside Out
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This book is far more than a quick update. We've rewritten and refreshed large portions of...
2023-03-25 (first published: 2023-03-24)
123 reads
Creativity in Technology
I was planning to write a blog post on how you can find ways to be creative in any technical pursuit. Then, I found out from a friend that...
2023-03-24 (first published: 2023-03-15)
179 reads
Blogs
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
An Unusual Identity
Comments posted to this topic are about the item An Unusual Identity
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers