Administering Database Master Keys in SQL Server
A short piece that gives you the basics of how to administer the database master keys that form the basis for encryption inside of your databases.
Calling Local Speakers
Steve Jones asks for more of the local people to help teach, train, and grow the community.
Cerebrata helps developers master Microsoft Azure with launch of new Just Azure resource
Just Azure, a new site from Cerebrata (part of Red Gate), provides essential technical resources and educational articles to support the Microsoft community in navigating and understanding the rapidly evolving Azure platform.
Just Enough know-how
As a professional, our knowledge of a given task should extend, at a minimum, one level deeper than is strictly necessary to perform the task. Anything deeper can be left to the ridiculously smart, or obsessive, or both
Restricting IO Using SQL Server 2014 Resource Governor
With the introduction of SQL Server 2014 the Microsoft team has enhanced the Resource Governor to now cover I/O. Greg Larsen shows you how to set up Resource Governor to limit the resources for those large I/O operations.
Backup Responsibility
Backups are important in most companies and today Steve Jones asks who has the responsibility in yours.
How to Receive Alerts When You Centralize Your SQL Server Event Logs
Learn how you can get alerts when you centralize the Event log. This is part 2 of the previous article "How to centralize your SQL Server Event Logs."
No Handwaving Away the DBA
Steve Jones doesn't think that companies can just do away with a DBA. Apparently there are people on the NoSQL platform that agree.
Improve SSIS data flow buffer performance
In this tip we have a very simple data flow using a source query with a predictable duration. The data flow takes longer to process all the rows and even larger buffers didn't make the problem go away. What can be the cause of this and how do we solve this? Koen Verbeeck explains.
Managers
Steve Jones thinks that the attitudes of managers need to change if we want to be more productive in the future.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Pondok Indah Telpon/WA:085188120691
BCA KCP Pondok Indah Telpon/WA:085188120691 Jl. Metro Pondok Indah No.60 & 61 UA, Pd....
BCA KCP Pasar Kebayoran Lama Telpon/WA:085188120691
BCA KCP Pasar Kebayoran Lama Telpon/WA:085188120691 Jl. Raya Kby. Lama No.174, Cipulir, Kec. Kebayoran...
BCA KCP Tebet Barat 2 Telpon/WA:085188120691
BCA KCP Tebet Barat 2 Telpon/WA:085188120691 Jl. Tebet Raya No.25 B Blok CI, Tebet...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers