2011-09-22 (first published: 2009-10-21)
10,937 reads
Articles
Prepare for Disaster Recovery - Webinar #13
The SQLServerCentral webinar series continues with Steve Jones talking about the ways you can recover from disasters with a little preparation.
2011-09-22
1,990 reads
Temporary Tables in SQL Server
Temporary tables are used by every DB developer, but they're not likely to be too adventurous with their use, or exploit all their advantages. They can improve your code's performance and maintainability, but can be the source of grief to both developer and DBA if things go wrong and a process grinds away inexorably slowly. We asked Phil Factor for advice, thinking that it would be a simple explanation.
2011-09-22
6,511 reads
An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper
Jeff Moden has been elected as the Exceptional DBA of 2011. Here, Jeff talks to Bob Cramblitt about the life of an exeptional DBA.
2011-09-21
2,057 reads
2011-09-20 (first published: 2009-10-14)
10,010 reads
SQL Server Memory Management Explained
Author Craig Outcalt takes a deep dive into the SQL Server memory allocation and how it competes with OS memory.
2011-09-20
15,405 reads
Removing HTML tags from text data using PowerShell
There are situations when you may need to remove HTML tags from your character string data. PowerShell will let you "clean" the string data and export the result to a .csv file in a single step.
2011-09-20
2,143 reads
Catching Deadlock Information in SQL Logs
This article presents a handy way to retrieve deadlock information in an ordered way from the error log.
2011-09-19
24,013 reads
TSQL Challenge 65 - Solving the Running Total Problem
This challenge invites you to solve one of the most common calculation challenges seen in applications that deal with financial -transactions.
2011-09-19
1,646 reads
Come to the Charleston PASS SQL Server User Group
The Charleston, SC PASS chapter is looking for speakers and new members. Read more and come to the Sept 20 meeting if you are near the area.
2011-09-19
1,647 reads
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
SSoL Support on the OS
Comments posted to this topic are about the item SSoL Support on the OS
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers