Reblog from Brent Ozar: Designing a Data Model for Gender and Sexuality (Oh And Also, I’m Pansexual)
This is a repost of a blog by Brent Ozar. I seriously doubt anyone reading this post hasn’t seen Brent’s ... Continue reading
2022-05-25
19 reads
Kenneth Fisher
TSQL Tuesday #150: Your first technical job. Rollup.
This months subject for T-SQL Tuesday was Your first technical job. I have to say I really really enjoyed reading ... Continue reading
2022-05-24
1 reads
My job managing a calling list. : T-SQL Tuesday #150
I’m actually hosting this month and I was wondering about your first technical job. Mine was kind of interesting. I ... Continue reading
2022-05-23 (first published: 2022-05-10)
171 reads
SQL Homework – May 2022 – Books on Line
No one knows everything. Ask any senior level person in IT and they’ll tell you that they spend plenty of ... Continue reading
2022-05-20 (first published: 2022-05-05)
421 reads
Running dynamic SQL in a different database
This is one of those things that on hindsight was a stupid problem, but still cost me hours and a ... Continue reading
2022-05-19
23 reads
Getting a list of the articles in a publication.
The other day I was asked to supply a list of all of the tables being replicated into a given ... Continue reading
2022-05-17
17 reads
Getting a list of the articles in a publication.
The other day I was asked to supply a list of all of the tables being replicated into a given ... Continue reading
2022-05-17
How can I use the identity column, without knowing identity column’s name.
One of the most fun parts of blogging is when you learn something completely unexpected while writing a blog. The ... Continue reading
2022-05-12
1 reads
My job managing a calling list. : T-SQL Tuesday #150
I’m actually hosting this month and I was wondering about your first technical job. Mine was kind of interesting. I ... Continue reading
2022-05-10
4 reads
SQL Homework – May 2022 – Books on Line
No one knows everything. Ask any senior level person in IT and they’ll tell you that they spend plenty of ... Continue reading
2022-05-05
5 reads
Blogs
A New Word: Ghough
By Steve Jones
ghough – n. a hollow place in your psyche that can never be filled;...
T-SQL Tuesday: Encryption and Data Protection
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Parameterize your Databricks notebooks with widgets
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
Forums
Need help on query within 2 column, generate another column
Hi, This is my table and data CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_100]( [Id] [int] IDENTITY(1,1) NOT...
SELECT blocking DML and DDL
Hi All. I am seeing a scenario where SELECT is blocking a TRUNCATE statement...
query filling up tempdb
Hi All, Need some help in tune a function which is reading TB's of...
Ask SSC