SQL Server
SQL Server Best Practices: Optimizing Power for SQL Server
If you’re expecting high performance from your SQL Servers, you'll need to optimize power. This post will take you through essential best practices, including instances hosted on SSD and Fusion ioMemory.
January 19, 2016 • 5 min read Data
SQL Server Best Practices on Flash Series
Announcing: SQL Server Best Practices on Flash - an upcoming webinar and new blog series
December 9, 2015 • 2 min read Data
SQL Server 2005: How To Give It Up And Thrive
The migration off SQL Server 2005 can present you with challenges, but it is actually a great opportunity to save money and deploy a more efficient, economical database solution. Jason Pederson shares how.
October 29, 2015 • 6 min read Data
Data Warehouse (DW) in the Era of Flash: Massive 90-95TB DW in 4U
In the previous post in this series, I wrote about two 45-55TB data warehouse systems that fit entirely in a 2U or 4U server. In this blog post we’ll look at two more Fast Track systems, this time rated for 90-95TB, in 4-socket, 4U servers. The largest SQL Server 2012 Data Warehouse (DW) FTRA that […]
October 13, 2015 • 5 min read Data
Professional Association for SQL Server (PASS) International Summit 2015
Later this month, from October 26th-30th, database pros from all over the world descend on downtown Seattle for the Professional Association for SQL Server (PASS) International Summit. PASS Summit is the world’s largest and most popular gathering for SQL Server professionals. Last year there were over 5,900 registrations and this year there are likely to […]
October 9, 2015 • 3 min read Data
Data Warehouse (DW) in the Era of Flash: Powerful 45-55TB DW in 2U or 4U Servers
In the previous post in this series, I wrote about two data warehouse systems that fit entirely in a 2U server, Fast Track-rated for 20TB to 28TB. In this blog post we’ll look at two more Fast Track systems, this time rated for 45TB to 55TB; one in a 2-socket, 2U server and the other […]
October 1, 2015 • 4 min read Data
Data Warehouse in the Era of Flash: 20-28TB DW in a 2U server
Faster insights from your business data – that’s what you expect from your data warehouse to help you achieve your business outcomes. So let’s talk about the systems that enable you to achieve that and how to choose the right one for your workloads. In the first post in this series, “Data Warehouse in the […]
September 24, 2015 • 4 min read Data
Data Warehouse in the Era of Flash – Better, Stronger, Faster
To deploy a cost-effective data warehouse solution you need balance. But the storage system impacts the ability to extract the insights you’re looking for. Peter Plamondon shares how flash comes to the rescue.
September 15, 2015 • 6 min read Data
SQL Server Columnstore Index Performance: Intro and Demo
Columnstore indexes are a powerful memory-optimized column-oriented index intended for data warehouse workloads—but far too few architects know about them or their benefits. Columnstore indexes routinely improve performance by 10x, 100x (such as in the demo below), and even 1,000x—rendering results in seconds that classic row store data structures required minutes to satisfy. Microsoft recommends […]
August 7, 2015 • 4 min read Data
Number One Reason to Upgrade from SQL Server 2005: Save Hundreds of Thousands of Dollars per Server
The Microsoft World Partner Conference takes place next week. You can find my SanDisk® colleagues at booth #900 to learn how partnership powers innovation. As SQL Server 2005 End-of-Service (EOS) looms, I’m taking the opportunity to discuss how to innovatively upgrade your infrastructure by leveraging SanDisk flash to save hundreds of thousands of dollars per […]
July 2, 2015 • 4 min read Data