Changing the default SQL Server backup folder
Is it possible to change the default directory for backups, so it does not need to be specified each time I run a backup?
Faking Arrays in Transact SQL
It is a simple routine that we all need to use occasionally; parsing a delimited list of strings in TSQL. In a perfect relational world, it isn't necessary, but real-world data often comes in a form that requires one of the surprising variety of routines that Anith Sen describes, along with sage advice about their use.
Prometheus
The myth of Prometheus has some relevance to technology workers. How? Read what Steve Jones thinks.
Prometheus
The myth of Prometheus has some relevance to technology workers. How? Read what Steve Jones thinks.
Prometheus
The myth of Prometheus has some relevance to technology workers. How? Read what Steve Jones thinks.
Execute an SSIS Package in SSMS - SQL School Video
This video shows how you can use Management Studio to execute your Integration Services packages.
Performance Implications of Database Snapshots
Books online mentions that performance may be reduced when using database snapshots. I decided to investigate how severe that reduction could be.
DLP Technology
Steve Jones isn't talking about his new television, but rather a new technology dealing with data and databases.
DLP Technology
Steve Jones isn't talking about his new television, but rather a new technology dealing with data and databases.
DLP Technology
Steve Jones isn't talking about his new television, but rather a new technology dealing with data and databases.
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
BCA KCU BLOK A CIPETE Telp:0821-8200-233
Telp/Wa 62 8218200233 PQHX+93W, Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete Sel., Kec....
Alamat Kantor BCA KCP Tebet Telp:0821-8200-203
Telp/Wa 62 8218200203 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N &...
Alamat BCA KCP Tebet Barat Telp:0821-8200-174
Telp/Wa:62 8218200174 Jl. Tebet Barat IX No.40, RT.6/RW.4, Tebet Bar., Kec. Tebet, Kota Jakarta...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers