Fail to cycle errorlog
sometime we observed that errorlog recycle is failed this happens when we monitor/read errorlog using our monitoring tool or monitoring application/scripts during this task if we want to recycle...
2019-10-29
30 reads
Blog Posts
I’m Speaking at SQL Saturday Oregon
I am honored to have been selected to speak at SQL Saturday Oregon this year. They always have so many sessions submitted with only 40 slots available. I was...
2019-10-29
13 reads
Last Week Reading (2019-10-27)
Hello and good morning! We have Tuesday morning, which means I experienced a delay in this post. But finally, it is out and have a look at how much...
2019-10-29
21 reads
Preparing for PASS Summit - Odds and Ends
This is the final installment in my series of posts which I hope will help you (and me!) prepare for the upcoming PASS Summit November 4-8, 2019 in Seattle,...
2019-10-29
3 reads
SQL Server 2019 Feature Power Rankings
Watch this week's video on YouTube
With the release of SQL Server 2019 imminent, I thought it'd be fun to rank which features I am most looking forward to in...
2019-10-29
8 reads
SQL Server 2019 Feature Power Rankings
Watch this week's video on YouTube
With the release of SQL Server 2019 imminent, I thought it'd be fun to rank which features I am most looking forward to in...
2019-10-29
6 reads
SQL Server 2019 Feature Power Rankings
Watch me comment on all of the features in this week’s video. With the release of SQL Server 2019 imminent, I thought it’d be fun to rank which features...
2019-10-29
546 reads
Switch activity in Azure Data Factory: Container with many IFs
(2019-October-16) Developing conditional logic of your Azure Data Factory control flow has been simplified with introducing of the Switch activity - https://docs.microsoft.com/en-us/azure/data-factory/control-flow-switch-activity. Official documentation resource states, this new data factory activity "provides...
2019-10-29 (first published: 2019-10-16)
8,569 reads
The FAST number_rows Query Hint
Query hints are always about tradeoffs—typically you are giving up something, such as flexibility, to achieve more consistency, or very specific performance characteristic. One example of this migt when...
2019-10-29 (first published: 2019-10-16)
1,013 reads
What to Pack for PASS Summit
In checklist form! Absolute I-probably-won’t-survive-without-this ESSENTIALS Wallet Prescriptions Glasses/contacts Phone and cord Laptop and cord (okay, maybe this is just me) A jacket (after all, Seattle) Generally A GOOD IDEA...
2019-10-29
23 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers