T-SQL Tuesday 163: Best piece of career advice
This month’s T-SQL Tuesday is hosted by Gethyn Ellis(t). Gethyn’s Invite to us is to write about the best piece of career advice you’ve received. One of the most...
2023-06-20
30 reads
Blog Posts
What Do You Look for in an Execution Plan?
Say, you have a query having performance issues and you decide to look it's graphical execution plan in SSMS (or other tools). If you are lucky, right off the...
2023-06-20 (first published: 2023-06-19)
188 reads
Flyway with Multiple Folders
A customer asked about how they could organize their migration scripts in different ways to manage them and worried about it being complex. I decided to test a few...
2023-06-19 (first published: 2023-05-31)
149 reads
Power BI – Empowering Users to Disable Tooltips
Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your stakeholders with a variety of tooltips that offer deeper insights. They love the tooltips, and...
2023-06-19 (first published: 2023-06-05)
241 reads
Tales From The Field Weekly Wrap Up for the Week of 06-12-2023 Cooking, Father's Day, & the Shrinking Household
Hello Dear Reader! This past week was a busy one. As we've started to settle into the new house we are transitioning from eating out or having meals delivered,...
2023-06-19
36 reads
Under Promise and Overdeliver
If you under promise and overdeliver then you will always have happy clients.
2023-06-19
26 reads
A New Word: Astrophe
astrophe n the feeling of being stuck on Earth. Us geeks are supposed to love space, right? Science Fiction? The Moon is a Harsh Mistress? Star Trek/Star Wars/Lost in...
2023-06-16
39 reads
Have You Reviewed Your Azure Storage Bill Lately?
At the end of 2021, I started using the new SFTP preview feature on Azure Data Lake Storage Gen 2. It was a great new addition to the...
2023-06-16
1 reads
Heading to That Conference
I’ve been working with Ryan Booz a bit more and as we’ve talked over the last few weeks, he has asked me a few times if I’ve booked travel...
2023-06-16
17 reads
Masking Columns in Azure SQL and SQL Server: Safeguarding Sensitive Data
Information security and privacy are key in today’s data-driven world. Sensitive data needs to be protected from unauthorized access. With column masking in SQL Server and Azure SQL, you...
2023-06-16 (first published: 2023-06-01)
357 reads
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers