Where to watch Ignite
In case you aren’t familiar with #MSIgnite, it’s a huge event where Microsoft debuts all the new shiny software that...
2018-09-24
275 reads
Prefixated
Are you a prefixer? And by that I mean a developer – or DBA – who uses prefixes on object names? [DISCLAIMER:...
2018-09-24
278 reads
Introducing Azure Data Studio
If you’re watching Microsoft Ignite or tracking the information coming out of it on social media, then you know that...
2018-10-02 (first published: 2018-09-24)
3,580 reads
Azure Cognitive Services – Search APIs
Throughout this week’s Azure Every Day blog posts, I’ll focus on different APIs available with Azure Cognitive Services. With Azure...
2018-09-24
284 reads
Extended Events and Stored Procedure Parameter Values
One complaint I’ve received frequently is that you can’t see stored procedure parameter values in Extended Events. That is patently...
2018-09-24
512 reads
More PowerShell for fun (and profit) – filter files by date
PowerShell provides an easy way to search for and/or delete just the files you want. Let's look at navigating in...
2018-09-24
746 reads
Escaping strings
No, I’m not talking about that nightmare everyone has where a bunch of strings are chasing you across a loom.
Not...
2018-09-24
899 reads
My upcoming Speaking Schedule
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-09-24
232 reads
Accidentally deleted an Azure SQL DB?
Okay honestly I have done this once. I have deleted Azure SQL Databases and then try and find the quickest...
2018-09-24
277 reads
A Day in the Life (3/?) - September 13, 2018
This is my third installment in a series responding to Steve Jones’s (blog|twitter) #SQLCareer challenge. I decided to jot down most of what I did through the day, filling...
2018-09-24
18 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...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
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