2018-05-11
674 reads
2018-05-11
674 reads
2018-04-24
698 reads
2018-04-23
722 reads
2017-10-10
765 reads
2017-09-14
744 reads
Identifying Performance Tuning Opportunities Using Extended Events: Part 3 Aggregate Report
2019-12-20 (first published: 2017-05-04)
6,104 reads
In this article, learn how to identify performance tuning opportunities using Extended Events.
2019-12-06 (first published: 2017-04-20)
18,341 reads
2015-11-23
1,155 reads
Erin Stellato of SQLskills shows how to use Extended Events to monitor for query plans with certain characteristics, such as joins missing predicates, columns missing statistics, and unmatched filtered indexes.
2015-11-13
2,571 reads
You may have cases where an ancient application is using an old login or the wrong password. SQL Server is great about auditing failed logins and recording that they happened; it is not so great, however, at providing enough information to locate them. Aaron Bertrand offers some help.
2014-05-02
3,423 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
WA:08218154393 Jl. Jenderal Sudirman No.74, Pati Kidul, Kec. Pati, Kabupaten Pati, Jawa Tengah 59114
Comments posted to this topic are about the item SSRS Reminded Me of the...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers