T-SQL Tuesday #040: File and Filegroup Wisdom
Backstory
Each month the SQL community comes together for an important party. This is the blog party that was the brain...
2013-03-12
1,083 reads
Backstory
Each month the SQL community comes together for an important party. This is the blog party that was the brain...
2013-03-12
1,083 reads
Backstory Each month the SQL community comes together for an important party. This is the blog party that was the brain child of Adam Machanic (Twitter) known as T-SQL Tuesday....
2013-03-12
18 reads
Another month and we have another installment (meeting) for the Data Professionals of the Las Vegas area.
This month we will...
2013-03-11
906 reads
Another month and we have another installment (meeting) for the Data Professionals of the Las Vegas area. This month we will be getting back on schedule with the usual...
2013-03-11
11 reads
You have been doing a fantastic job of late. You have all of your databases being backed up on a...
2013-02-12 (first published: 2013-02-11)
1,657 reads
I know it is right in the middle of TSQL2SDAY when this post is to go live. If you don’t...
2013-02-12
619 reads
I know it is right in the middle of TSQL2SDAY when this post is to go live. If you don’t know what that is, you should go check out...
2013-02-12
13 reads
You have been doing a fantastic job of late. You have all of your databases being backed up on a regular schedule. Now you get an alert that your...
2013-02-11
13 reads
This is part I of III in a series on the physical join operators in SQL Server.
2013-02-01 (first published: 2011-01-04)
26,812 reads
Do you know the last time a Server Property was changed on your instances of SQL Server?
Are you wondering when...
2013-01-30 (first published: 2013-01-24)
4,261 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Suryakencana No.260 C & D, RT.01/RW.05, Babakan Ps., Kecamatan Bogor Tengah, Kota...
WhatsApp:0817819444 Blok A/3-4, Ketapang Indah, Jl. KH Zainal Arifin, RT.5/RW.7, Krukut, Kec. Taman Sari,...
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers