T-SQL Tuesday #142–What is Bicep?
It’s time for the monthly blog party, and this month the host is Frank Geisler. I was reaching out to various people last year to find hosts, and also...
2021-09-24 (first published: 2021-09-14)
303 reads
Blog Posts
Daily Coping 23 Sept 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-09-23
36 reads
Accessibility in font choice
Choosing the right typeface for your presentation (or for that matter anything you create that contains words) is fraught. In a previous post I wrote about the difference between...
2021-09-22
36 reads
Daily Coping 22 Sep 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-09-22
32 reads
Data Platform products for Microsoft gaps
Microsoft has a ton of data platform-related products, but there are certain areas where they either don’t have a product or what they have is limited and you need...
2021-09-22
1 reads
Database Sizes
Quick query today. I needed a list of database sizes so came up with this: Nothing exciting, but I figure ... Continue reading
2021-09-22 (first published: 2021-09-14)
433 reads
Persist Sample Percent in SQL Server IS Fixed!
Hi Everyone, this is John Sterrett. I am a SQL Server Consultant in Austin, TX. Last year I blogged about a feature called Persist Sample Percent. It had a...
2021-09-22 (first published: 2021-09-14)
714 reads
Daily Coping 21 Sep 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-09-21
38 reads
Changing the Connection for Data Masker
Data Masker for SQL Server is a great tool ensuring the data you use in non-production environments is compliant with any regulations by obfuscating and changing sensitive data. This...
2021-09-20 (first published: 2021-09-13)
199 reads
Containers: A Short Rant
I find myself doing more and more work with containers. Yet, I also find that a lot of people seem to be resistant to the concept. I’m always surprised...
2021-09-20
Blogs
Making a PostgreSQL Backup in a Container
By Steve Jones
I needed to back up a PostgreSQL database as a part of the repro...
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
Forums
RLS Causing RBAR
Hi all, First I want to ask just a generic question. Does RLS in...
SQL2019 STANDARD max memory is 128Gb yet my Bufferpool exceeds this value
Reading the Microsoft documentation it says SQL2019 STANDARD EDITION has a max memory of...
Having issues installing SSIS extension for VS 2022 Community
I have installed the SSIS extension for VS 2022 community. When I go into...
Question of the Day
A Simple Choice
I have this data in a table?
CatIDCatName 3MonitorsWhat is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS cSee possible answers