and other pointless query rewrites
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-09
162 reads
and other pointless query rewrites
In a similar vein to last week’s blog post… I heard an interesting comment recently. “Change that Column != 2 to...
2016-02-17 (first published: 2016-02-09)
1,939 reads
How Much Hospitals Charge For The Same Type Of Cases?
Update: For the KPI version of this report, please check Power BI KPI Report: Hospital Charge Data
How much hospitals charge...
2016-02-16 (first published: 2016-02-09)
2,224 reads
Spring Training: Developing SQL Queries for SQL Server
Just a short post for a Tuesday to let you that I will delivering Learning Tree’s 534 Developing SQL Queries...
2016-02-09
482 reads
Memory Fundamentals for SQL Server - Process-Thread Model, CPU execution model, CPU scheduling, CPU Architechture, SQLOS
Until now we have seen the windows memory addressing concepts.
http://sqlandmorewithkruti.blogspot.in/2016/01/memory-fundamentals-for-sql-server.htmlhttp://sqlandmorewithkruti.blogspot.in/2016/02/memory-fundamentals-for-sql-server-awe.html
So how exactly are user applications like SQL server assigned to...
2016-02-09
2,673 reads
Limitation of In-Memory OLTP in SQL Server 2016 – Seed and Increment value other than 1 not supported
Hi friends, in this blog we will discussed another limitation of In-Memory OLTP that seed and increment value other than...
2016-02-09
534 reads
Upcoming SQL Saturday Precon Sessions (Update!!!!)
Wow, Power BI is making a tidal wave in the BI industry. New features are being released regularly and blog posts...
2016-02-08
959 reads
Monday Morning SQL Break – February 8, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-02-08
349 reads
Introduction to SQL Server: The Main Components
There has been much talk recently in the SQL Server community about writing introductory level blog posts. Posts that a...
2016-02-08
896 reads
SQL Server 2016 Row-level Security and SSRS a perfect match
In this blog I will explain and demonstrate how to leverage a new feature in SQL Server 2016, Row Level...
2016-02-15 (first published: 2016-02-08)
9,110 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
Alamat Telp BCA KCP Poris Indah (+62) 838-4945-0961
Wa:083849450961 Ruko Poris Indah, Komp, Jl. Poris Indah Blok K No. 2-3, RT.003/RW.003, Cipondoh...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
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