sqlpassion.at sqlpassion.at

Speaking about Latches & Spinlocks at the EightKB Online Conference

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) This Wednesday I have the pleasure to speak about Latches, Spinlocks, and Latch Free Data Structures at the EightKB Online Conference. This year they are expecting more than 1500 attendees and they have a great lineup with well-known...

sqlpassion.at sqlpassion.at

SQLpassion Online Training about Statistics & Plan Caching

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) On January 28, 2021 I will run an SQLpassion Online Training about Statistics & Plan Caching in SQL Server. Statistics are used by SQL Server to estimate how many rows are returned for a given query. Based on that assumption, the Query...

sqlpassion.at sqlpassion.at

SQLpassion Black Friday Deal 2020

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) As we all know the Black Friday approaches quite fast, and therefore I want to offer you a great deal from my side. During the following 2 weeks I will offer you my available Online Trainings with a 60% (!) discounted price: Design,...

sqljana.wordpress.com sqljana.wordpress.com

SQL Server: Fix – The server principal “elevated_user_login” is not able to access the database “my_database” under the current security context

The Error: This error wasted my morning. Although I have solved this issue before, it took a while to google and fix it again. So, this post is for my own edification and reference if for no other reason! –Proc [MyProcedureName] started AT:2020-10-13 09:49:43.4632735Msg 916, Level 14, State 1, Procedure MySchemaName.MyProcedureName, Line 31 [Batch Start Line 6]The server principal “elevated_user_login” is not able to access the...

sqljana.wordpress.com sqljana.wordpress.com

PowerShell/dbatools Tip – Clone a login / database user

One of the more frequent requests that a SQL Server DBA receives is to “Clone a login” with all its permissions. For example a request could be Clone BILL_BLACK’s login and create a new login JACK_JOHNSON with exactly the same privileges in all databases. Clone AD group login BILLING_APP_ADMINS and create a login for new AD group BILLING_APP_CONSULTANTS with the same permissions as BILLING_APP_ADMINS in all databases Before...

debezium.io debezium.io

Debezium 1.3.0.CR1 Released

I’m very happy to announce the release of Debezium 1.3.0.CR1! As we approach the final stretch of Debezium 1.3 Final, we took this opportunity to add delegate converter support for the ByteBufferConverter and introduce a debezium-scripting module. In addition, there’s also a range of bug fixes and quite a bit of documentation polish; overall, not less than 15 issues have been resolved for this release. ByteBufferConverter...

debezium.io debezium.io

Debezium 1.3.0.Beta1 Released

It’s my pleasure to announce the release of Debezium 1.3.0.Beta1! This release upgrades to the recently released Apache Kafka version 2.6.0, fixes several critical bugs and comes with a renaming of the connector configuration options for selecting the tables to be captured. We’ve also released Debezium 1.2.2.Final, which is a drop-in replacement for all users of earlier 1.2.x releases. Revised Filter Options and...

debezium.io debezium.io

Debezium 1.2.1.Final Released

I am happy to announce the release of Debezium 1.2.1.Final! This release includes several bug fixes to different Debezium connectors, and we highly recommend the upgrade from 1.2.0.Final and earlier versions: The Debezium Postgres connector may have missed events from concurrent transactions when transitioning from snapshotting to streaming events from the WAL (DBZ-2288); this is fixed now when using the exported snapshotting...