Differences In Native Compiled Procedures Execution Plans
All the wonderful functionality that in-memory tables and natively compiled procedures provide in SQL Server 2014 is pretty cool. But, changes to core of the engine results in changes in things that we may have developed a level of comfort with. Grant Fritchey explains.
Apology for today's article
We'd like to apologize to Gavin Draper who was plagiarized in an article published today.
Bad Meetings or Meeting Badly
Meetings are a part of modern corporate work that many of us despise. However is that because
But, but, but, my data is clean!
Gail Shaw on the challenges of trying to extract meaningful data from a database containing customers who have the name 'Dummy **DO NOT USE**''.
Introduction to SQL Server in Microsoft Azure
The convenience, competitive pricing, resiliency, and ease of maintenance of the SQL Database Platform as a Service (PaaS) offering hosted on the Microsoft Azure platform are partially offset by a lack of support for some of the features. These limitations can be eliminated by taking advantage of the Microsoft Azure IaaS capabilities and installing a SQL Server instance in an Azure-hosted VM.
Support The Boss
Providing support for your manager or boss in getting his or her job is a good thing. Steve Jones comments on what benefits you might get and why this could enhance your career.
Unwelcome posts on our forums
As you may have noticed, we have been suffering recently from increased spam posts on the forums. This is something we're currently working to resolve.
My month with Release!
Alex and his team are developing a game about software and some of the people who make it. He looks at how games affected his office culture, what he’s learned about designing games to do more than just be fun, and how his team are hoping to share their passion with the developer community.
Using DBCC DROPCLEANBUFFERS When Testing Performance
Over the years I've had many discussions with other SQL Server Database Administrators as to whether or not you should have the database buffer pool loaded with data pages or empty when testing queries for performance. This tip will take a look at the effects on query performance for both cases by using the DBCC DROPCLEANBUFFERS statement to empty the buffer pool.
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 Pasar Puri Indah,Telpon/Wa 0821-8200-239
Blok A, Jl. Puri Indah Raya 20-22, Kembangan Sel., Kec. Kembangan, Kota Jakarta Barat,...
BCA KCP Sanur Raya. Tlp:08218168235
Jl. Raya Jl. Bypass Ngurah Rai No.287, Sanur, Denpasar, Kota Denpasar, Bali 80227
BCA KCP Jatinegara Timur Telpon/WA:087768193341
BCA KCP Jatinegara Timur Telpon/WA:087768193341.Jl. Jatinegara Timur No.37 Pav, RT.8/RW.4, Bali Mester, Kecamatan Jatinegara,...
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