SQL 2012 Cluster, Windows 2012 R2 OS, Windows 2008 R2 Domains
Recently I was installing SQL Server 2012 on a new Windows 2012 R2 cluster for a client and ran across a bit of a problem. When the SQL Installer was attempting to start SQL Server for the first time SQL Server was throwing Windows errors 1069 and 1194 which basically say… Cluster network name resource […]
SQL Saturday Nashville Pre-Con and Sponsorship
I’m pleased to be able to report that I’m giving a pre-con on SQL Server Performance at SQL Saturday Nashville. The sign up page is available here. In addition to giving a pre-con I’m also signed up as a Silver sponsor, so I’ll have a booth at the pre-con setup where you can come talk […]
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 […]