An auditing mind set
I little while back I presented at Pass Data Community Summit. Specifically the presentation was Auditing your data and data ... Continue reading
2022-06-15 (first published: 2022-05-31)
229 reads
SQLStudies
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
32 reads
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
37 reads
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-06-24 (first published: 2022-05-24)
240 reads
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
5 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-06-10 (first published: 2022-05-19)
571 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
58 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
186 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
2 reads
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-06-03 (first published: 2022-05-12)
403 reads
Blogs
SQL Saturday Baton Rouge 2025
By DataOnWheels
SQL Saturday Baton Rouge is a great event hosted on LSU’s campus that has...
Responsible AI: Why Leaders Need More Than Just Guardrails
By Chris Yates
In the rush to adopt artificial intelligence, many organizations have quickly built ethical frameworks,...
TempDB Performance Tuning in SQL Server 2022 vs 2016 vs 2019
By Rohit Garg
What Is TempDB and Why It Matters TempDB is a shared system database in SQL...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
When DBAs Should Consider Using SQL Server to Store Vector Data and If It Makes Sense
Comments posted to this topic are about the item When DBAs Should Consider Using...
Row Count task in data flow fails with "unspecified error"
Hi all, I have a data flow task with: Flat File Source (csv) ->...
Question of the Day
Capacity Planning for an Existing SQL Server Workload?
You're tasked with planning capacity for a new SQL Server database workload. Which of the following is the most accurate way to determine how much CPU, memory, and I/O throughput your workload requires? What single or multiple tools would you use to answer the questions around resource needs?
See possible answers