The Pen Cap
This post is for all you up and coming data professionals out there. Over the course of the last week...
2017-03-21
413 reads
The SQL Professor
A Letter To A Younger Yates
Hello much younger Yates. Hope you’ve been doing well. Why don’t you pull up a chair and stay for a...
2017-01-31
683 reads
Backup/Restore–What’s My Status?
The day begins and you find yourself going through a list in your mind of things that need to be...
2017-02-02 (first published: 2017-01-26)
1,880 reads
5 Characteristics Every Leader Should Practice
The word leadership has many synonyms attributed to it. Something that can be learned early on in one’s career is that...
2017-01-24
718 reads
Why Use Red Gate’s SQL Multi Script?
Someone once told me at the shop that we have plenty of software utilities laying around that could be very...
2017-01-18
507 reads
Hold The Fort
Have you ever heard the phrase “Hold The Fort”? Long ago in battle supply routes were targeted by enemy regiments...
2017-01-12 (first published: 2017-01-05)
1,292 reads
Looking Back At 2016
When this blog started back in 2011 I had no idea that it would continue to grow to where it...
2016-12-29
674 reads
The New PASS Logo and More
Change is not always easy. In fact, change is hard.
“Change” is a word from which some people shy away, and...
2016-12-20
334 reads
A Data Professional’s Story – PASS Summit 2016
This year is different. Why? I’m not sure yet. There is a lot of reflection going on since my return...
2016-11-11 (first published: 2016-11-02)
1,225 reads
PASS Summit Keynote 2 – Release 2
Dr. David DeWitt is getting ready to take the stage to a huge ovation and is thrilled to be back...
2016-10-27
575 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers