Author Archives: Martin Surasky

About Martin Surasky

Full-time time daddy, part time DBA, and guitar player (only if I'm not administering a databases or with my daughter) and part time Coffee Crisp addict (thanks Nestle)...

Learning from Index Fragmentation Woes


The 2 sides of Index Maintenance Sometimes good old re-index does make a difference… Advertisements

Posted in Performance and Troubleshooting | Tagged , , | Leave a comment

Encryption in transit


What’s the story today? I have been tasked with coming up with the implementation for “in transit” data encryption of all the communication flowing back and forth from the web servers to the database servers. Even though I have been … Continue reading

Posted in Simple Tricks and How To's | Tagged , , , | Leave a comment

Email Alerts with Performance Monitor


Not everything must be revolutionary, some great tips to better manage your systems are a simple matter of thinking in small easy evolutionary steps.

Posted in Simple Tricks and How To's | Leave a comment

SQL Server 2016 Series – High Availability


Time to look at higher availability, another area with a few improvements in SQL Server 2016

Posted in New Features, SQL Server 2016 | Leave a comment

SQL Server 2016 Series – Security Features


Back with more from SQL Server 2016. Today is the turn of new security features: Always Encrypted, Row Level Security and Dynamic Data Masking. Let’s dive into these right away!

Posted in New Features, SQL Server 2016 | Leave a comment

SQL Server 2016 Series – In Memory OLTP Enhancements


I promised I will write with some tips about the new SQL Server 2016 features so here is my first post related to “In-Memory OLTP tables” (known to some ask Hekaton tables).

Posted in New Features, SQL Server 2016 | Leave a comment