Limitation of In-Memory OLTP in SQL Server 2016 – LOB datatypes not supported
Hi friends, Wish you all a very Happy New Year. This is my first blog of 2016 and starting it...
2016-02-01
554 reads
Hi friends, Wish you all a very Happy New Year. This is my first blog of 2016 and starting it...
2016-02-01
554 reads
Proper configuration of the TempDB system database is crucial for optimal performance of a SQL Server instances during heavy loads. The recommended...
2016-02-04 (first published: 2016-01-31)
8,357 reads
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-01-31
724 reads
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-02-08 (first published: 2016-01-31)
1,784 reads
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-01-31
859 reads
This error caught me out. I am putting this post here firstly to remind me if I do it again...
2016-02-04 (first published: 2016-01-31)
1,717 reads
When I was about 7 years old and got my first computer during the early nineties,
I said “This is...
2016-01-31
852 reads
I’m proud to announce that I will be speaking at SQLSaturday Chicago on March 5th 2016! This will be my first SQLSaturday event and I’m really excited that I...
2016-01-29
17 reads
I’m proud to announce that I will be speaking at SQLSaturday Chicago on March 5th 2016! This will be my...
2016-01-29
861 reads
Quick reminder that the call for speakers for Orlando Code Camp is open through Feb 6 (next week!).
2016-01-29
1,096 reads
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,...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor, Jawa Barat...
Jl. Yos Sudarso No.155, Taba Jemekeh, Kec. Lubuk Linggau Tim. I, Kota Lubuklinggau, Sumatera...
Wa:083849450961 Jl. Sulawesi No.34, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan 90174
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