Query Store and Log Backups
A question that came up recently around Query Store is what happens when there are log backups in use on...
2018-09-17
224 reads
How do I grant permissions to view users and their permissions?
tl;dr; VIEW DEFINITION
Every now and again you’ll have a user that needs to be able to see what permissions other...
2018-09-17
366 reads
Batching data manipulation is great as long as you do it correctly
As Sinatra was fond of singing, “regrets, I’ve had a few.” And one of those came this week immediately after my presentation. This isn’t to say the presentation didn’t...
2018-09-15
25 reads
New Pluralsight Course – Provisioning Microsoft Azure Virtual Machines
My new course “Provisioning Microsoft Azure Virtual Machines” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right...
2018-09-15
21 reads
New Pluralsight Course – Provisioning Microsoft Azure Virtual Machines
My new course “Provisioning Microsoft Azure Virtual Machines” in now available on Pluralsight here! If you want to learn about the course, check...
2018-09-15
314 reads
Steps for SQL DB Geo Replication
Unless you are living under a rock, you have most likely heard of the hurricane that is bearing down on...
2018-09-26 (first published: 2018-09-14)
2,589 reads
A Quick Intro to DevOps in Azure
Today, I’d like to discuss DevOps in Azure and tell you why you should consider using DevOps when you start...
2018-09-14
957 reads
Them Con+cat+enatin’ Blues
We ran into a funny problem not long ago, revolving around a stored procedure that was building up a dynamic...
2018-09-24 (first published: 2018-09-13)
3,226 reads
Customer Roadblocks to Azure
When I speak with customers, I often find they share common roadblocks to using Azure. I recently sat down with...
2018-09-13
734 reads
SQL Server string functions for Data Munging (Wrangling)
In this article, you’ll learn the tips for getting started using SQL string functions for data munging with SQL Server....
2018-09-13
369 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