blog.sqlxdetails.com
SqlClient – Vedran Kesegic Blog
http://blog.sqlxdetails.com/tag/sqlclient
Darr; Skip to Main Content. CommandTimeout – How to handle it properly – code example. 2 Comments ↓. Properly closing a connection to Sql Server in DotNet is more challenging than one might think. Classic code looks something like this MSDN example:. Using (SqlConnection connection = new SqlConnection(connectionString) { connection.Open(); Console.WriteLine("ServerVersion: {0}", connection.ServerVersion); }. Read more ›. Posted in Sql Client Code. Tagged with: Error handling. 7 Comments ↓.
blog.sqlxdetails.com
Speaking at SQL Saturday Budapest #sqlsatbudapest – Vedran Kesegic Blog
http://blog.sqlxdetails.com/sql-saturday-376-budapest
Darr; Skip to Main Content. Speaking at SQL Saturday Budapest #sqlsatbudapest. Speaking at SQL Saturday Budapest #sqlsatbudapest. No Comments ↓. 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 least no one was sleeping 😉. The speaker’s dinner the day before was really really fun. Page Life Expectancy and 300 sec limit.
blog.sqlxdetails.com
PowerShell – Vedran Kesegic Blog
http://blog.sqlxdetails.com/tag/powershell
Darr; Skip to Main Content. CommandTimeout – How to handle it properly – code example. 2 Comments ↓. Properly closing a connection to Sql Server in DotNet is more challenging than one might think. Classic code looks something like this MSDN example:. Using (SqlConnection connection = new SqlConnection(connectionString) { connection.Open(); Console.WriteLine("ServerVersion: {0}", connection.ServerVersion); }. Read more ›. Posted in Sql Client Code. Tagged with: Error handling. Training for your experts.
blog.sqlxdetails.com
CommandTimeout – How to handle it properly? – Vedran Kesegic Blog
http://blog.sqlxdetails.com/commandtimeout-how-to-handle-it-properly
Darr; Skip to Main Content. CommandTimeout – How to handle it properly? CommandTimeout – How to handle it properly? 7 Comments ↓. ADONet Data Provider for SQL Server (System.Data.SqlClient namespace in System.Data.dll assembly) has two common classes we often use: SqlConnection. SqlCommand class has CommandTimeout. Property (do not mix it with the ConnectionTimeout which stops long login process). But, do we handle it properly? And what exactly is happening when the command timeout occurs? The session wi...
blog.sqlxdetails.com
Security and encryption – Vedran Kesegic Blog
http://blog.sqlxdetails.com/category/security-and-encryption
Darr; Skip to Main Content. Archive for Security and encryption. Category: Security and encryption. Procedure with Execute as login? 5 Comments ↓. Sometimes we need a low-privileged user to do a specific administration task or task that require some server-level permissions (such as VIEW SERVER STATE, ALTER TRACE etc). Of course, we do not want to give that account server-level privilege, because …. Read more ›. Posted in Security and encryption. Database Consultant Vedran Kesegić M.Sc.
blog.sqlxdetails.com
Speaking at SQL Saturday Vienna conference – Vedran Kesegic Blog
http://blog.sqlxdetails.com/speaking-at-sql-saturday-vienna-conference
Darr; Skip to Main Content. Speaking at SQL Saturday Vienna conference. Speaking at SQL Saturday Vienna conference. No Comments ↓. 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 data and retrieve the “lost” part later, even when the database is in SIMPLE recovery model and no backups exist. 8249; CHECKPOINT vs LAZY WRITER.
blog.sqlxdetails.com
Sql Client Code – Vedran Kesegic Blog
http://blog.sqlxdetails.com/category/sql-client
Darr; Skip to Main Content. Archive for Sql Client Code. Category: Sql Client Code. CommandTimeout – How to handle it properly – code example. 2 Comments ↓. Properly closing a connection to Sql Server in DotNet is more challenging than one might think. Classic code looks something like this MSDN example:. Using (SqlConnection connection = new SqlConnection(connectionString) { connection.Open(); Console.WriteLine("ServerVersion: {0}", connection.ServerVersion); }. Read more ›. Posted in Sql Client Code.
blog.sqlxdetails.com
Error handling – Vedran Kesegic Blog
http://blog.sqlxdetails.com/tag/error-handling
Darr; Skip to Main Content. Posts tagged Error handling. CommandTimeout – How to handle it properly – code example. 2 Comments ↓. Properly closing a connection to Sql Server in DotNet is more challenging than one might think. Classic code looks something like this MSDN example:. Using (SqlConnection connection = new SqlConnection(connectionString) { connection.Open(); Console.WriteLine("ServerVersion: {0}", connection.ServerVersion); }. Read more ›. Posted in Sql Client Code. Tagged with: Error handling.
blog.sqlxdetails.com
Uncategorized – Vedran Kesegic Blog
http://blog.sqlxdetails.com/category/uncategorized
Darr; Skip to Main Content. RCSI and LOB data – how tempdb version store is used? 2 Comments ↓. 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 …. Read more ›. Page Life Expectancy and 300 sec limit. 4 Comments ↓. Read more ›. CHECKPOINT vs LAZY WRITER. 5 Comments ↓. Read more ›. Sort records without ORDER BY?
blog.sqlxdetails.com
Sort records without ORDER BY? – Vedran Kesegic Blog
http://blog.sqlxdetails.com/sort-records-without-order-by
Darr; Skip to Main Content. Sort records without ORDER BY? Sort records without ORDER BY? No Comments ↓. How often you see some smartie “optimizes” the query by removing ORDER BY, justifying that query always goes by that index, and index is in desired order for the result? Or they say: “I executed this query thousands of times and always got the result in order of that index”. We will populate a table with 100 rows, where Id is identity (1-100), clustered key:. The query returns all 100 rows despite the...
SOCIAL ENGAGEMENT