Part 3 of the analysis of the SQLServerCentral database cluster by MVP Brad McGehee. Follow along as he talks about some SQL Server settings and gives reasons why they should or should not be changed.
2011-05-11
3,789 reads
Reprinted from my editorial in Database Weekly.
When I was a junior DBA many years ago (even before the company I...
2011-05-10
558 reads
SQLServerCentral.com will be offering SQL Server tracks at both the upcoming DevConnections in Germany and the UK this June.
The Germany...
2011-05-10
887 reads
SQLServerCentral.com will be offering a SQL Server track at the upcoming DevConnections in Germany this June.
The Germany DevConnections will be...
2011-05-10
1,081 reads
This week Brad McGehee asks if your company is a 100% Microsoft software shop or if you are allowed to use third party software with your SQL Server.
2011-05-02
206 reads
As DBAs, one of our biggest responsibilities is to protect our data with backups. So, for this month’s question, “What’s...
2011-05-01
443 reads
Most of the time when I run a poll on my blog, I run it for at least a month...
2011-04-25
2,486 reads
In part 2 of our best practices clinic, Brad McGehee looks at a couple of the items that were misconfigured on the SQLServerCentral database instances.
2011-04-13
5,066 reads
How many people can you identify in the above photo from the closing party at SQLBits? Can you find Ola...
2011-04-11
1,350 reads
As DBAs, we are responsible for the protection of our organization’s data, and we have many different options to protect...
2011-04-01
591 reads
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
I wanted to figure out how big (or approximately how big) my dump file...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers