What I Wish I Had Known Sooner…as a DBA
Yesterday I took a minute and to review some posts by some Data Professionals and in doing so I came...
2014-08-28
1,096 reads
The SQL Professor
ISPACs – Got To Love Em
Being a DBA and working with various teams, I have become accustomed to deploying SSIS packages. I’ll even go back...
2014-08-20
574 reads
And Just Like That….Three Years
Time is a constant. Anything and everything requires time it seems, and with that said I received a reminder today...
2014-08-18
284 reads
T-SQL Tuesday #57 – SQL Family and Community
Maybe it is just me, but these monthly block parties seem to be coming around quicker and quicker as time...
2014-08-12
296 reads
SQL Prompt – The Power Within
*Photo by Red Gate
Come a little closer; no seriously come on over just a little closer as I don’t want...
2014-07-15
555 reads
T-SQL Tuesday #56 – Assumptions
Question: “What time is it?”
Answer: “T-SQL Tuesday time”
Question: “What time?”
Answer: “T-SQL Tuesday time”
“I can’t hear you?!?!?!”
That’s right; it’s that time...
2014-07-09
402 reads
Worst Day As A DBA
I remember the day pretty vividly, it was in the summer months and I was as green as green can...
2014-06-26
419 reads
PASS Summit – What Does It Mean To Me?
PASS Summit – what does it mean to me? So listen, I’m not perfect. I will never claim to be and...
2014-06-26
385 reads
Blogs
A Basic Update Trigger: #SQLNewBlogger
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
Apply for a 2025 PASS Summit Scholarship
By Brian Kelley
Redgate is offering 13 PASS Summit scholarships which not only includes the 3-day ticket...
SQL Server TempDB: The Most Overlooked Bottleneck
By Kevin3NF
Configuration, Performance, and Unnecessary Usage TempDB is the SQL Server equivalent of a junk...
Forums
Best/easiest way to import an SSIS package...
Folks, Looking for advice on the best way to import a package. I hope...
Measure duplicating its value when non-conformed dimension attribute is included
Hi, I have two fact tables (say FactA, and FactB), that are joined/shared...
balancing numa nodes
Can anybody advise on how i go about balancing threads to each node. As...
Question of the Day
How Many Nested Triggers?
I have DDL trigger code that I'm working on in SQL Server 2022, but I am concerned that we might end up with multiple triggers firing and the response to the user is delayed. If I want to check how many triggers have fired, or are nested, how can I do this in my code?
See possible answers