2019-01-16
149 reads
Editorial
Measuring Effectiveness
Being effective is important to Steve. Today he talks about the things you might consider when trying to determine if your group is being effective.
2019-01-15
60 reads
Where's that Snippet?
Phil Factor has tried many different ways to remember code and archive old code for reuse, but has yet to find the perfect solution. Does it exist?
2019-01-14
123 reads
Do you have a security to-do list?
Security is important, and Steve wonders if any of us have a list of things we do that improve security.
2019-01-11
86 reads
2019-01-10
117 reads
Is Failure Allowed?
Failure is one of the ways we get better as software developers. Does that apply to DBAs?
2019-01-09
65 reads
2019-01-07
141 reads
The Giving Back Workload
Volunteering is a good thing for us to do, but it can be overwhelming at times.
2019-01-04
78 reads
Lack of Memory
It seems that many SQL Servers can be lacking memory. Adding more is one way to improve performance, but Steve has other ideas.
2019-01-03
129 reads
2019-01-02
171 reads
Blogs
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Monday Monitor Tips: The MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
Forums
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries