I joined PASS in 1999 and attended the inaugural Summit in Chicago. It was in the lower level of a hotel just on the river, I went to the last White Sox game of the year, and got to see Kalen Delaney speak about this newly released SQL Server 7.
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.
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.
Daylight Savings time switches a little later this year. In fact it's November 4th this year, after having been in October for all of my life. In case you don't remember which way we move the clocks, here's a saying: Spring forward, fall back.
New author! Mahesh presents a solid overview of the replication architecture of SQL 2000.
This is the 8th installment of my XML Workshop which aims at explaining the details of working with XML in TSQL.
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.
We published an article about how one DBA goes about hiring new DBAs and in the discussion that followed there was something that caught my eye. There were a few comment talked about how college degrees don't necessarily mean anything.
This installment illustrates how to use PowerShell script to loop through the content of the file and connect to different servers.
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
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...
Comments posted to this topic are about the item The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers