Recommended Reading from mrdenny for January 3, 2014
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. Create a Dev & Test Environment in Minutes! SQL Server 2014: In-memory OLTP Engine, code-name: Hekaton SQL Server 2014: Columnstore Index improvements New version of Data-Tier Application framework is available Experiments with […]
Why would I want to use a non-durable in memory table?
With SQL Server 2014 we were introduced to in memory tables, and specifically the ability to use non-durable in memory tables. These non-durable tables, are special case tables. The schema will exist after the database engine is rebooted, however the table will be empty after the server is rebooted. These tables are great for filling […]
Blog Year 2013 In Review (Sort Of)
Welcome to 2014. For the last couple of years I’ve done a top posts of the last year post. This year will be no different. What is different between this year and prior years is that this year I’ve got really bad data compared to prior years. I’ve got great data starting 10/3/2013 to current, […]
Encryption and Compression
We have a variety of options when it comes to compression and encryption in SQL Server. When using both compression and encryption you have to understand how each of these work and when they wil lwork together and when they won’t be able to work together to make using both technologies useful. The trick to […]