In this LIDNUG webinar, Mitchel Sellers walks through performance tuning best practices, and investigates how developers can use ANTS Performance Profiler to explore their application code and the SQL queries and execution plans behind it.
Create a repository of all your database devices and stay informed about changes in their size and usage.
Have you learned anything new lately? Steve Jones asks the question after an interesting T-SQL Tuesday.
How can you get a list of columns that have changed within a trigger in T-SQL? How can you see what bits are set within a varbinary or integer? How would you pass a bitmap parameter to a system stored procedure? Phil Factor has answers.
SQL Azure Runbooks promise to be your “SQL Server Agent in the cloud” enabling automation of time consuming, repetitive tasks.
What's the value of code to your organization? Steve Jones thinks it's much larger than many people believe.
Phil Factor argues that as terrorists and criminals exploit the new opportunities that open up as technology develops, technologists must work with Governments to ensure thoughtful custodianship of data, and sensitivity towards legitimate privacy.
Interviewing people is hard to do well. Steve Jones talks about a technique that might help you better choose good employees for your organization.
When faced with a complex business application, Dwain's team chose to encapsulate and implement most of an application’s business logic in SQL Server, using an interface made up of stored procedures. Here's how they did it.
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item No Defaults Passwords Ever
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?