Suggestions for PASS
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.
Working with PASS
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.
SQL Server 2005 Express Edition - Part 6 - Post Installation Configuration Tasks (Encryption)
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.
Understanding the Difference between Owners and Schemas in SQL Server
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.
An Hour in Time
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.
SQL 2000 Replication Architecture
New author! Mahesh presents a solid overview of the replication architecture of SQL 2000.
XML Workshop VIII - Custom Types and Inheritance
This is the 8th installment of my XML Workshop which aims at explaining the details of working with XML in TSQL.
A New (and Hopefully Better) Approach to Constants
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.
The College Experience
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.
Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4
This installment illustrates how to use PowerShell script to loop through the content of the file and connect to different servers.
Blogs
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
Forums
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Doing the Little Things
Comments posted to this topic are about the item Doing the Little Things
Question of the Day
Historical Data Tracking
If I want to track historical data values, which mechanism should I use?
See possible answers