Setting up WebStorm to debug grunt with TypeScript
It’s possible to use the WebStorm editor to debug grunt tasks if you are using TypeScript and generating .map files. ...
2014-11-28
1,685 reads
Blog Posts
Virtualization Virtual Chapter Webinar – Open Q&A
On December 10 at 11am CST I will be presenting the next PASSVirtualization Virtual Chapter monthly webinar, where you can ask...
2014-11-28
945 reads
Beware the defaults! (in windowing functions) – The Movie!
I was recently contacted by the fine gents of Webucator, an online training services provider. In order to promote their...
2014-11-27
1,086 reads
In-memory OLTP Part 1: Introduction to In-memory OLTP
SQL Server 2014 introduced probably one of the biggest changes to the SQL Server engine since years, “In-memory OLTP” (or...
2014-11-27 (first published: 2014-11-21)
8,438 reads
Parameterization Part 6: Simple vs. Forced Parameterization
This is the sixth post in the “Parameterization” series. In the previous posts I explained what parameterization is, how plan...
2014-11-27
7,763 reads
Use -eq in Powershell
I was writing a quick script to work with files and I only wanted to process one file for each...
2014-11-27 (first published: 2014-11-17)
6,049 reads
Audit Database File Size Changes
Recently I shared an article on how to track the growths and shrinks that occur within database files. I shared...
2014-11-26
2,597 reads
Audit Database File Size Changes
If you just so happen to be running on SQL Server 2012 or later, you will need to change your event sessions that were tracking file changes. It is...
2014-11-26
35 reads
Exam Prep 70-463: More about Dimensions
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2014-11-26 (first published: 2014-11-20)
7,031 reads
How to burn down your house while frying a turkey
It’s an odd query, yes, but in preparation to write this post I actually typed the above phrase into my...
2014-11-26
1,269 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...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
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