Learning from Index Fragmentation Woes


The 2 sides of Index Maintenance

Sometimes good old re-index does make a difference… Continue reading

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 asked to implement “at rest” encryption many times before (all using TDE), this is the first time I have to implement such a request; without furter ado here is the full journey, hopefully it will save some people attemtping to do the same some time …

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.

Continue reading

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

Continue reading

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!

Continue reading

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).

Continue reading

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