By Lori Brown | Miscellaneous , SQL Administration , SQL Maintenance , SQL Server
— By Lori Brown @SQLSupahStah I recently received a panicked call from a client who had a SQL instance go down because the server’s C drive was full. As the guy looked he found that the msdb database file was 31 GB and was consuming all of the free space on the OS drive causing […]
Continue readingBy Lori Brown | Miscellaneous , SQL Administration , SQL Server
— By Lori Brown @SQLSupahStah I recently was tasked with finding out how implementing TDE on a database along with encrypting several columns in a heavily used table was going to affect application code and query performance. Here are the steps I took to implement TDE encryption along with some query run statistics. I also […]
Continue readingBy Lori Brown | Miscellaneous , SQL Administration , SQL Server
Available in SQL 2012 & 2014 Enterprise Edition ColumnStore Indexes were introduced in SQL 2012 and are designed to improve performance in data warehouses. These indexes are good for batch processing and read only queries that use large data sets. Tables that are bulk loaded are good candidates. ColumnStore Indexes stores data in a columnar […]
Continue readingBy Lori Brown | Miscellaneous , SQL Administration , SQL Server
Available in SQL Server 2014 – All Editions Delayed Durabilty is a way to defer the acknowledgement of the transaction log records getting written to disk, i.e. transactions can continue without waiting, and SQL will assume that the log record *will* be written. You may know the ACID rules (Atomicity, Consistency, Isolation, Durability) that guarantee […]
Continue readingBy Lori Brown | SQL Administration , SQL Server
Available in SQL Server 2014 Enterprise Edition In-Memory OLTP is a new lock-free, latch-free, optimistic concurrency approach to storing data in memory. While it may seem reminiscent of DBCC PINTABLE is it definitely not the same since data in memory-optimized tables is not organized in pages, and does not use the Buffer Pool. It is […]
Continue readingBy Ginger Daniel | Performance Tuning , SQL Administration , SQL Server , Windows
Recently, a client of mine contacted me in a panic because almost all of the memory on the SQL server was used up…according to Task Manager, that is. Don’t panic…task manager is probably lying. Well, a little bit anyway. And Task Manager is just that, a task manager. If you are looking at it to […]
Continue readingBy Ginger Daniel | Installation , SQL Administration , SQL Server
After you make sure you have everything in your environment ready to go and all the prerequisites that need to be done before deployment have been done, we are ready to install the AlwaysOn Availability Group! The following steps need to be performed in this order: Add Windows Failover Clustering (WSFC) to each replica (server) […]
Continue readingBy Ginger Daniel | Installation , SQL Administration , SQL Server
Before implementing your AlwaysOn Availability Group, make sure you have everything in your environment ready to go. There are several prerequisites that need to be done to ensure a successful deployment. These prerequisites focus on your Windows environment, the SQL instances, and the databases to be included in your AlwaysOn group. Windows: Windows Server 2008 […]
Continue readingBy Ginger Daniel | SQL Administration , SQL Server
AlwaysOn is a great new feature in SQL Server 2012 and 2014 Enterprise edition. It has been described as the next evolution of database mirroring. AlwaysOn enhances the existing technologies of database mirroring and failover clustering to provide a strong layer of high availability and disaster recovery. The way it works is that you have […]
Continue reading