Model database
Most DBAs have at least some idea what the system databases are for. Master has the list of databases & logins,...
2013-01-28
930 reads
SQLStudies
IsMSShipped
I just wanted to do a brief highlight of a handy little object property. For those of you who aren’t...
2013-01-23
1,481 reads
My view isn’t reflecting changes I’ve made to the underlying tables.
Problem: You’ve added columns to the base table of one of your views, but the view isn’t reflecting the change.
Over...
2013-01-29 (first published: 2013-01-21)
3,838 reads
Using New Horizontal/Vertical Tab Groups
This isn’t really one of those features of SSMS that I’ve used a great deal. At least didn’t until recently....
2013-01-17 (first published: 2013-01-14)
3,287 reads
What port is my instance listening on?
I just had the interesting task of finding the port number that one of the instances I deal with is...
2013-01-08
1,694 reads
How I like to learn a t-sql command
Recently I received a security request and realized I wasn’t comfortable in my ability to script out the t-sql commands...
2013-01-07
840 reads
Red errors in the results pane
Most DBAs have seen those nice clear red errors in the results pane. And I’m sure most DBAs have noticed...
2012-12-27 (first published: 2012-12-19)
2,088 reads
Generating multiple SQL statements from a query
Dynamic SQL is one of my favorite tools in the DBA toolbox. I’m big on automation and dynamic SQL can...
2012-12-17
1,133 reads
Where is my backup?
We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working...
2012-12-19 (first published: 2012-12-12)
2,023 reads
Copying Connection Managers in SSIS
Did you know you can copy and paste connection managers in SSIS? While I haven’t found this a huge benefit...
2012-12-10
1,540 reads
Blogs
A field note: AI Ambition vs. Operational Reality in 2025
Ivan Jelić, Group CEO at Joyful Craftsmen, reflects on what separates AI success from...
Redefining Tech Leadership in the Age of Microsoft AI
By Chris Yates
AI is no longer a niche capability – it is a leadership catalyst. As...
Sample Data with GenAI in Seconds
By Steve Jones
A friend was asking for help with some data analysis. This was in PowerBI,...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
do i lose "what this object depends on" etc when moving sprocs to etl server
Hi i was surprised to see the approach my coworkers used to sunset talend...
People Make Odd Choices
Comments posted to this topic are about the item People Make Odd Choices
Question of the Day
Query Plan Regressions --
For the Question of the day, I am going to go deep, but try to be more clear, as I feel like I didn't give enough info last time, leading folks to guess the wrong answer... :) For today's question: You’re troubleshooting a performance issue on a critical stored procedure. You notice that a previously efficient query now performs a full table scan instead of an index seek. Upon investigating, you find that an NVARCHAR parameter is being compared to a VARCHAR column in the WHERE clause. What is the most likely cause of the query plan regression?
See possible answers