How to write an UPDATE query
My First UPDATE Statement Last week we covered how to put information into a table using an INSERT statement. This...
2017-06-07
152 reads
Born SQL with Randolph West
How to write an INSERT query
My First INSERT Statement Last week we covered how to get information out of a table, using a SELECT query....
2017-05-31
408 reads
How to write a SELECT query
My First SELECT Statement Microsoft SQL Server makes it really easy for us to query tables. In SQL Server Management...
2017-05-24
179 reads
Querying a Database
When we want to retrieve information from a database, we query the structure with language appropriate to the database. Remember...
2017-05-17
117 reads
SQL Server Management Studio v17.0
Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server,...
2017-05-10
258 reads
SQL Server 2017 Announced
By now you will have heard that the next version of SQL Server has been announced. There’s no release date yet,...
2017-05-03
108 reads
Something something Production something something you idiot
You’re reading this series of posts because you want to learn about databases and how to use them. What you...
2017-04-26
109 reads
Upcoming SQLSaturdays in Alberta, Canada
Taking a short break from the Database Fundamentals series of the last few weeks, I’d like to mention some upcoming...
2017-04-19
126 reads
So, like, what is a byte?
A friend of mine in the filmmaking business, who is exceedingly bright but has never worked with SQL Server before,...
2017-04-12
116 reads
Normalization, The Sequel
If there’s one thing that SQL Server is really good at, it’s relationships. After all, a relational database management system...
2017-04-05
128 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers