Here is the statements to get...

Thanks.

Sorry for the brief coverage of profiles. There is a more in depth profile discussion later in the Stairway, so hopefully it will help more later.

I will see about getting the example changed to not be redundant.

Glad things worked out.

You should be able to from a PowerShell window run the following and then do the notepad $profile thing.

New-Item $profile -force -type File

notepad $profile

Thanks. I will submit a change.

Thanks.

I will be posting some videos related to my stairway at my youtube channel http://www.youtube.com/dbaduck and at http://dbaduck.com as well.

I know Sean and have seen his...

Thanks. I have submitted to have the graphic re-added to the level.

The backup of the primary database is a backup of the secondary backup. You can get a backup of the Primary database with COPY_ONLY flag so that you don't...

Typically port 1434 UDP is the port that SQL Server listens on for requests to SQL Server about configuration. The other port is used to connect to SQL Server.

The...

;WITH CTE (Type, Code, Value)

AS (

SELECT [Type], [Code], [Value]

FROM dbo.A

UNION ALL

SELECT Type, Code, Value

FROM dbo.B

UNION ALL

SELECT Type, Code, Value

FROM dbo.C

)

SELECT Type,

[X], [Y], [Z], [V], [M], [N]

FROM (

SELECT Type, Code,...

Well, the client OLEDB is going to always be separate than the Server DLL, so it will not matter as much that the Server dll is newer. It will...

You should use SQL Configuration Manager and the nodes should be online. SQL Configuration Manager is the only way you should change SQL Server Service Account passwords.

I think that we all agree that this is something that can be important, but there are many ways to get at information that will tell you what has been...

This is one way: (has to be 2005 and above), and remember that there are other ways too.

ALTER PROCEDURE [dbo].[usp_GetClassScheduleForProgramNClass]

@ProgramID int

AS

BEGIN

SET...

Remember that statistics are telling SQL Server what kind of data exists in this column for the entire table. If you use DBCC SHOWSTATISTICS on the statistic set, you...