Built My Presentation, Now What?
Over the course of several years, I have given many technical and non-technical presentations. It is fun for me to...
2017-06-07
436 reads
The SQL Professor
QA, Utility Databases, and Job Executions
Sometimes we, as data professionals, have to think outside the box. I know, crazy idea right? Each shop and situation...
2017-04-26
425 reads
Can a Data Professional Be Organized?
“One of the advantages of being disorderly is that one is constantly making exciting discoveries.” While this quote is true...
2017-05-05 (first published: 2017-04-25)
1,419 reads
SQL Doc by RedGate
I recently was on a call where a technical unit indicated they did not receive any form of documentation around...
2017-04-24 (first published: 2017-04-19)
1,294 reads
T-SQL Tuesday #89 Invitation – The times they are a-changing
This month’s topic by Koen Verbeeck (B|T) is based around times that are a changing. To break it down somewhat...
2017-04-11
343 reads
Don’t Duck On Responsibilities
Being a data professional you assume a certain amount of responsibility. It often requires having the right attitude and an...
2017-04-17 (first published: 2017-04-10)
1,379 reads
Are You Wasting Energy?
Often times we as leaders within our respective shops tend to waste our time focusing on the wrong things. Think...
2017-04-06
367 reads
Is There A Threat Inside?
If you’ve been involved in technology for any length of time you are aware of outside threats to your network...
2017-04-05
358 reads
How I Became A…SQL Server Data Professional
Last night I saw a tweet from Matt Gordon (b|t); the topic caught my eye – “How I Became A…SQL Server...
2017-04-04
384 reads
What Is SQL Saturday?
I was recently approached and asked, “What is SQL Saturday? I actually get asked that question more times than not...
2017-04-03
375 reads
Blogs
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
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...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
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