Delimiting Results
Recently, I came across the need to delimit some data in order to be able to test some procedures that...
2011-03-01
620 reads
Jason Brimhall
Delimiting Results
Recently, I came across the need to delimit some data in order to be able to test some procedures that I was writing. The procedures need to be able...
2011-03-01
17 reads
Memory Consumed By SQLServer
Have you wondered how much memory was being consumed by SQL Server? Have you wondered if there was a way...
2011-02-28
3,540 reads
Memory Consumed By SQLServer
Have you wondered how much memory was being consumed by SQL Server? Have you wondered if there was a way to find out that information from a tSQL command?...
2011-02-28
20 reads
Finding Compressed Tables
Have you been working with compression? Have you inherited a database that may or may not have some tables compressed?...
2011-02-25
1,994 reads
Finding Compressed Tables
Have you been working with compression? Have you inherited a database that may or may not have some tables compressed? On occasion you may want to know what the...
2011-02-25
26 reads
February 2010 S3OLV Recap
For the month of February, I conducted the S3OLV meeting virtually from the confines of home in Utah. As you...
2011-02-22
457 reads
February 2010 S3OLV Recap
For the month of February, I conducted the S3OLV meeting virtually from the confines of home in Utah. As you may know, I have moved from Vegas back to...
2011-02-22
10 reads
SQLServerPedia Blogger Awards
Several moons ago I learned that I had won one of the categories for the 2010 SQLServerpedia Blogger Awards. You...
2011-02-17
497 reads
SQLServerPedia Blogger Awards
Several moons ago I learned that I had won one of the categories for the 2010 SQLServerpedia Blogger Awards. You can read about that here. Of all of the...
2011-02-17
13 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
BCA KCU BOGOR Telp/Wa 085111887254
Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor, Jawa Barat...
BCA KCU LUBUK LINGGAU Telp/Wa 082371291690
Jl. Yos Sudarso No.155, Taba Jemekeh, Kec. Lubuk Linggau Tim. I, Kota Lubuklinggau, Sumatera...
Alamat Telp BCA KCP Sulawesi (+62) 838-4945-0961
Wa:083849450961 Jl. Sulawesi No.34, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan 90174
Question of the Day
The ##MS_DatabaseConnector## User
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