AWE Adventures

Joseph recently had to upgrade a server from 4g to 8g of memory. Read how he did it and learn about some interesting aspects of AWE. For example, if you have 6.5g configured for use by SQL, how will task manager show used by sqlserver.exe?

Building Communities with Software

Steve Jones found this link that has some great thoughts on how software should be used to help build a community. Read this if you have time and post some comments. One thing in particular we liked (read the article!) were the comments about emailing responses. Your comments on this one will help us plan as we continue to try to build a better site/community.

What's In A Review?

Expanding on the issue of reviewing software for SQL Server, Steve Jones proposes some standards for reviews in this article. Please take a moment to read and comment on this proposal to better help SQL Server Central.com provide you with the information that you need.

The SQL Server Black Box

Have you ever had the problem where a user ran a query against your SQL Serer and crashed it or made the server unusable since the CPU was spiked at 100%? A SQL Server black box is the equivalent of a flight data record. The black box records all queries being passed to your SQL Server and other useful information like errors.

Standards Are a Good Thing

This week we have another article from Andy that discusses some changes he made at work in conjunction with clustering all his database servers. Not a how-to, just comments about what was changed and why. Worth reading just for the reminder about the potential gotcha that @@ServerName can represent.

Blogs

An All Star Lineup for EightKB

By

An online conference is coming on June 17, 2020 that is full of high...

How should I store currency values in SQL Server?

By

On Twitter, Michael Dyrynda writes: ?? Never ever ever ever ever ever ever ever...

What happens if your SQL Server editions are out of support? – a MinionWare snippet

By

The more your SQL Server is out of date, the more things become vulnerable,...

Read the latest Blogs

Forums

Daily 3 Coping

By Steve Jones - SSC Editor

Today’s tip is find three good reasons to be hopeful for the future. http://voiceofthedba.com/2020/06/03/daily-coping-3-jun-2020/

Daily Coping 2 Jun 2020

By Steve Jones - SSC Editor

Today’s tip is to think about how your actions make a difference for others....

Changing Connection Managers with the Configuration Manager

By Thom A

OK, this actually not a question, this is in response to a question I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers