Monitor User Connections in SQL Server
This article explores the causes and remedies for applications failing due to too many open connections to SQL Server.
How Do You Work When You are Not at Work?
Things have evolved since the days of essential pagers and landline connections. Or have they? Brad ponders how the nature of remote working is evolving, and invites you help others learn from your experiences.
iPads for Christmas
A contest from Red Gate and Steve Jones could get you a copy of SQL Monitor and an iPad for Christmas. Steve Jones talks about how you can enter, and perhaps win an iPad for yourself this holiday season.
TSQL Challenge 45 - Evaluate mathematical expressions presented using
This challenge involves evaluating mathematical expressions presented using Roman Numerals and return the result of each expression.
The DELETE statement in SQL Server
Of the big four DML statements in SQL Server, the DELETE is the one least written about. This is odd considering the extra power conferred on the statement by the addition of the WITH common_table_expression; and the OUTPUT clause that essentially allows you to move data from one table to another in one statement.
What’s Going on with SQL Server Service Account Changes?
For years we’ve been told you should use Enterprise Manager in SQL Server 2000 or SQL Server Configuration Manager in...
Hierarchies in SQL
One very common structure that needs to be handled in T-SQL is the hierarchy. One of our prominent members of the community discusses how you can handle hierarchies in SQL Server.
Put Your Thinking Caps On
Three contests from Red Gate Software are coming next week. Get a hint about what might be coming and set a reminder on your calendar.
Shrinking Databases
One piece of advice that is often given to new SQL Server administrators is not to shrink their databases. But they seem to do it often enough anyway. For this Friday's poll, Steve Jones asks if we should do away with shrink.
Facebook and E-Mail Security for a New Teenager
Cross-posted from a Goal Keeping DBA blog:
Just recently, my oldest son entered the ranks of the teenagers. I shouldn’t actually...
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers