SQL Server – Kill all sessions using database
Before an existing database can be restored, there should be connections using the database in question. If the database is...
2013-11-25
261 reads
Before an existing database can be restored, there should be connections using the database in question. If the database is...
2013-11-25
261 reads
Before an existing database can be restored, there should be connections using the database in question. If the database is...
2013-11-25
1,462 reads
Stuff function: - This function is used to replace string from the given start position, passed as 2nd argument with string...
2013-11-25
34,580 reads
Case Statement/ Expression in SQL server
Sometimes we need to get one result output from multiple possible outcomes based on the...
2013-11-25
1,803 reads
Quick script just to give you an idea of how your databases are being used. Mainly useful for exploring.
select db.name...
2013-11-25
8,912 reads
AdvertisementsRecently one of my application website went down.
I checked all the basic connectivity troubleshooting and seem everything was looking and...
2013-11-25
1,396 reads
Introduction
A few days ago, I did a presentation for a Virtual Chapter meeting where I discussed SQL Server Data Access...
2013-11-24
968 reads
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Today I have...
2013-11-23
1,675 reads
Backing up SQL Server Databases
Backing up your SQL Server database is essential for protecting your data. The word Backup refers...
2013-11-23
3,229 reads
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-11-22
834 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Telp/Wa 628218200233 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
In SQL Server 2025, can I alter a fixed server role?
See possible answers