Author: Vedran

Speaking at Advanced Technology Days 2016

Congratulations! Your session Show me the cache! has been accepted for Advanced Technology Days 12! http://atd.mscommunity.hr/predavanja/#session_61 It will be interesting exploration of SQL Server’s caches, especially the most important ones: plan cache and buffer pool cache, Memory Optimized tables and

Posted in Conferences

Database Recovery from RAM

Introduction Recently I had a client who basically lost his SQL Server databases. I decided to share this experience with you, so you can use it if you ever find yourself in so tough situation. The client found out that

Posted in Transaction log and Recovery

Formatting TSQL code

How do I format my TSQL code? Everybody has it’s own preferences on formatting SQL or TSQL code. I follow few very simple rules to achieve better readability, less bugs and  – you wont’ believe – faster code execution! Code

Posted in TSQL and SQL Client Code

Speaking at conference Kulendayz 2015

4th of September I will hold a full-day preconference training about SQL Server 2016 performance tuning. It will be different, interesting, and hopefully funny. Real-life examples, way of thinking about the performance, and what are the ultimate limits of physical

Posted in Conferences

RCSI and LOB data – how tempdb version store is used?

Row Version Store We know RCSI (Read Committed Snapshot Isolation), as well as SI (Snapshot Isolation) use row versioning to store previous verions of rows in part of tempdb called “row version store”. If you are using default isolation level

Posted in Uncategorized

Page Life Expectancy and 300 sec limit

People blogged about it, including excellent Jonathan’s post here (highly recommended to read), but I will give a little more insight here. Basically, Microsoft says if PLE is below 300 seconds, we should worry about memory pressure (an old recommendation

Posted in Uncategorized

Speaking at SQL Saturday Budapest #sqlsatbudapest

I just returned from Sql Saturday 376 in Budapest (#sqlsatbudapest). It was really amazing. The conference room I held presentation was huge and to my pleasant surprise – fully packed! I got a lot of positive comments there, so at

Posted in Conferences

CommandTimeout – How to handle it properly – code example

Properly closing a connection to Sql Server in DotNet is more challenging than one might think. Classic code looks something like this MSDN example:

Posted in TSQL and SQL Client Code Tagged with: , ,

CommandTimeout – How to handle it properly?

ADO.Net Data Provider for SQL Server (System.Data.SqlClient namespace in System.Data.dll assembly) has two common classes we often use: SqlConnection and SqlCommand. SqlCommand class has CommandTimeout property (do not mix it with the ConnectionTimeout which stops long login process). But, do

Posted in TSQL and SQL Client Code Tagged with: ,

Speaking at SQL Saturday Vienna conference

I am pleased that I will speak at SQL Saturday conference in Vienna, 28th of February 2015 about how to solve the “recovery impossible” situation. It is quite advanced topic, but everyone who listens will be able to save the

Posted in Conferences
Visit Us On TwitterVisit Us On FacebookVisit Us On LinkedinVisit Us On YoutubeVisit Us On Google PlusCheck Our Feed