Take the SQLChallenge: Tuning a Stored Procedure
I’ve just published a new SQLChallenge course for subscribers, and I think it’s one of the best ones yet. Your mission is to: Identify which statement is slowing down...
2018-08-16
I’ve just published a new SQLChallenge course for subscribers, and I think it’s one of the best ones yet. Your mission is to: Identify which statement is slowing down...
2018-08-16
I’m excited to announce that I’m joining the evangelist team at Redgate. Starting next Monday, I’ll be working with Steve Jones, Grant Fritchey, and Kathi Kellenberger — plus the whole...
2018-08-15
2 reads
When you take a new job in software engineering or in IT, within the paperwork there often lurks an employee agreement: a contract between you and your employer. In...
2018-08-13
Last week’s quiz was on Table Value Constructors in TSQL. Essentially, table value constructors let you create a dataset on the fly. These can occasionally be useful in writing...
2018-08-07
16 reads
I’ve just scheduled two new podcast recording sessions! These are live, half hour sessions – you can join in listen, or share comments. Here’s what we’ll be talking about…....
2018-08-03
2 reads
What makes a person a DBA Hero? In this episode, I talk about how Robert Davis made a huge impact on the SQL Server community, and the traits that...
2018-08-02
6 reads
Last week I posted a quiz on SQL Operations Studio, a free, multi-platform tool from Microsoft. This tool is under active development and the features are improving by the day...
2018-07-31
1 reads
I’ve been enjoying working with SQL Operations Studio lately – a new, free, cross-platform editor from Microsoft. The tool is under active development and it’s a great time to...
2018-07-25
1 reads
I recently received my seventh “Most Valuable Professional” award from Microsoft. Oddly, I don’t think I’ve ever written about what this award means to me until this point. In...
2018-07-11
2 reads
In the last year, developers and DBAs have heard a lot about the General Data Protection Regulation (GDPR) law passed by the European Union. These regulations not only impact...
2018-07-05
1 reads
How can you achieve good enough without compromising the process/product? In the world of...
By Patrick
One of my customers recently wanted to rename each of the SQL audit files...
The post The pros and cons of self-service BI: What every industry leader should...
The report that I want to open has an "ExamDate". I am trying to...
Morning all, I've inherited a small (on prem) SQL estate. I'm a DBA, used...
Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)
See possible answers