PASS is the global users group for SQL Server DBAs, but there are a number of people who have never heard of it. Longtime author Andy Warren has a few suggestions for PASS and encourages you to submit your own.
2007-10-18
2,035 reads
In our new article, we will continue coverage of this topic by describing other activities that alter default connectivity settings applied during standard installation, focusing in particular on encryption.
2007-10-18
2,137 reads
SQL Server 2005 introduces the concept of schemas as opposed to object owners found in previous versions. This article will explain the differences between the two and, hopefully, clear up some of the confusion that still exists about schemas.
2007-10-18
5,547 reads
New author! Mahesh presents a solid overview of the replication architecture of SQL 2000.
2007-10-17 (first published: 2003-10-17)
45,489 reads
This is the 8th installment of my XML Workshop which aims at explaining the details of working with XML in TSQL.
2007-10-17
3,707 reads
A look at how constants are used in T-SQL and SQL Server in general along with some suggestions on how better to deal with them.
2007-10-16
7,945 reads
This installment illustrates how to use PowerShell script to loop through the content of the file and connect to different servers.
2007-10-16
2,744 reads
If you're in the Charlotte, NC area, the user group is meeting on October 16, 2007
2007-10-15
524 reads
A look at how one of our longtime members goes about hiring new DBAs.
2007-10-15
12,421 reads
Most DBAs dread hearing that they need to restore a database to a point in time, especially if the database is a production database. However, knowing how to do this is of the utmost importance for a DBA's skill set. I'll walk you through the steps of how to restore a SQL Server database to a point in time to recover a data table.
2007-10-15
4,024 reads
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers