How to Solve the Tail Insert Problem
In the previous post, we talked about when you should use identity/sequence as a clustered index key and when it’s...
2016-01-19
1,365 reads
Advent of Code – Day 1 – Parsing a variable
I have been following the series of posts written by my friend and SQL MCM Wayne Sheffield on some TSQL...
2016-01-19
285 reads
Name Your Defaults So SQL Server Doesn't
Something in SQL Server that isn’t always obvious to beginners is that when you create a default value for a column on a table, SQL Server creates a constraint...
2016-01-19
25 reads
SQL Saturday Melbourne (#464) – 20 Feb 2016
For those not aware SQL Saturday is coming to Melbourne on Sat 20 Feb 2016. SQL Saturday is an excellent free learning resource for all things SQL Server – all costs are...
2016-01-18
17 reads
SQL Saturday Melbourne (#464) – 20 Feb 2016
For those not aware SQL Saturday is coming to Melbourne on Sat 20 Feb 2016.
SQL Saturday is an excellent free learning...
2016-01-18
700 reads
Disabling SQL Server Network Protocols
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-01-18
1,117 reads
Q&A: Multiple SQL Server Instances on a VM
I recently received a great question through email. It was whether or not it is a good idea to have...
2016-01-18
1,141 reads
Five Years, A Quiet Quarter, A Look Ahead to 2016
Five Years of Blogging
From to My blogging story started on December 7, 2010. I have now had a blog for...
2016-01-18
526 reads
Removing All SQL Server Query Store Data
While setting up example code for my presentation at SQL Cruise (which is going to be a fantastic event), I...
2016-01-18
545 reads
To the page and back again
To the page
It’s not one of those things you have to do frequently but every now and again you need...
2016-01-18
551 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
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,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCU KUPANG (+62) 838-4945-0961
Wa:083849450961 Jl. Tompello No.23 A, Oetete, Kec. Oebobo, Kota Kupang, Nusa Tenggara Tim. 85119
Layanan BCA KCU PURWOKERTO (+62) 838-4945-0961
Wa:083849450961 Jl. Jend. Sudirman No.391 A, Brubahan, Purwanegara, Kec. Purwokerto Tim., Kabupaten Banyumas, Jawa...
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