Who should own the database?
TL;DR; SA, or if you are really paranoid then you can create a disabled SQL login with minimal permissions and...
2018-01-25 (first published: 2018-01-15)
2,715 reads
SQLStudies
Fun with sp_rename
Currently the only way to rename objects in SQL Server is to use sp_rename. Although that may be changing in...
2018-01-11
1,528 reads
A Solution for Squirrely SQL Server Security: TSQL Tuesday #98
It’s the first T-SQL Tuesday of the year! Arun Sirpal (b/t) is our host this month. Thanks, Arun! The subject...
2018-01-09
308 reads
SQL Homework – January 2017 – Inspect an Execution Plan
It’s a new year and yet education never ends. So this month let’s take a look at an important part...
2018-01-10 (first published: 2018-01-03)
2,501 reads
What is impersonation for?
I was doing some research on impersonation the other day, and among other things, I ran across a forum question...
2017-12-27
800 reads
Making music with Powershell
Happy holidays everyone! Ok, this isn’t even remotely related to SQL Server but it sounded fun. I found someone playing...
2017-12-20
967 reads
When do usernames and passwords belong in connection strings
tl;dr: When using a windows or active directory authenticated id you do not put the username or password into your...
2017-12-18
716 reads
How to: Create an Azure VM with SQL Server using a default template
One of the really cool things about the cloud is how quickly you can spin up a new machine to...
2017-12-14
530 reads
T-SQL Tuesday #97 – Setting learning goals for 2018
T-SQL Tuesday. Each month a different blogger hosts Adam Machanic’s (b/t) blog party. The host comes up with a topic...
2018-01-01 (first published: 2017-12-12)
1,699 reads
Restrict the usage of a SQL Server Authenticated Application Id
SQL Server login ids may not be the most secure thing in the world but they are likely to be...
2017-12-18 (first published: 2017-12-06)
1,724 reads
Blogs
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
Forums
Alamat Kantor BCA KCP Cyber 2 Telp/Wa:0821-8200-203
Hub/Cs 62 8218200203 Gedung Cyber 2 Ground Floor, Jl. H. R. Rasuna Said 5...
Alamat Kantor BCA KCP Bintaro Telp/Wa:0821-8200-233
Hub/Cs 62 8218200233 Jl. RC. Veteran. 9, dan No.9A, RT.9/RW.3, Bintaro, Kec. Pesanggrahan, Kota...
Alamat BCA KCP Gedung Hijau Telp/Wa:0821-8200-203
Hub/Cs 62 8218200203 Jl. Gedung Hijau Raya No.41, RT.1/RW.13, Pondok Indah, Kec. Kebayoran Lama,...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers