Filtering Logged Data
Over the course of the past couple of articles, I have shown some interesting if not useful functionality in the...
2016-01-07 (first published: 2016-01-01)
1,236 reads
Over the course of the past couple of articles, I have shown some interesting if not useful functionality in the...
2016-01-07 (first published: 2016-01-01)
1,236 reads
Let’s have some fun with operator precedence today. Specifically, logical operator precedence. Specifically, how is it evaluated when your where clause...
2016-01-06 (first published: 2015-12-31)
2,824 reads
Explore how to configure the XEvents GUI with specific views to suit your needs and tastes for data display by adding, removing or changing the column orders.
Related Posts:
Easy Open...
2015-12-31
21 reads
In the previous article I showed a couple of methods to merge Extended Event Log files. In that article I...
2015-12-31
1,035 reads
SQL Server is a database management system which enables to store and retrieve data from the database. Due to some reasons like virus infection, improper closing of the Server,...
2015-12-31
35 reads
SQL Server is a database management system which enables to store and retrieve data from the database. Due to some...
2015-12-31
1,414 reads
Sometimes one receives amazing gifts at the most unexpected moment. I was beyond thrilled to find out that I was...
2015-12-30
840 reads
Thanks to the December 2015 update released for Power BI, we can now use R to visualize our data in...
2016-01-05 (first published: 2015-12-30)
4,928 reads
I ran a twitter poll the other day Do you check for databases with trustworthy turned on when you do...
2016-01-06 (first published: 2015-12-30)
2,478 reads
While working with Extended Events, or with any sort of logging or tracing utility, it becomes critical to consume the data from disparate sources or even to consume the...
2015-12-30
19 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Comments posted to this topic are about the item Pay for Performance, which is...
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
Comments posted to this topic are about the item 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