#columnstore index

[thedbahub]

Columnstore Indexes vs. Nonclustered Indexes in SQL Server

Columnstore Indexes: A Game-Changer for Data Warehousing Columnstore indexes revolutionized data warehousing by storing data in a columnar format. This approach significantly improves query performance for analytical workloads. By compressing data and efficiently reading only the required columns, columnstore indexes reduce I/O and memory usage. Here’s an example of creating a columnstore index…

View On WordPress

[seniordba]

Sample Databases for SQL Server 2014 Microsoft has released the training databases for the latest version of SQL Server, named SQL Server 2014.

[hiramfleitas]

I'll be presenting tomorrow @Nova Southeastern University - 9:50am Room 2081 (Carl DeSantis Building)

I’ll be presenting tomorrow @Nova Southeastern University – 9:50am Room 2081 (Carl DeSantis Building)

Hi,

I just received the news that I got selected to speak at Nova Southeastern University tomorrow, 2/10/18 at 9:50am in Room 2081 (Carl DeSantis Building).

Here’s the event info: http://fladotnet.com/codecamp/Home.aspx Register here (FREE): https://eventbrite.com/e/south-florida-code-camp-2018-tickets-38099337143

Pls fwd this invite to your friends and colleges if you think they’ll be interested…

View On WordPress

[hiramfleitas]

Yesterday was another good day at work.

Since returning from summit, I spent a rigorous amount of time developing slides & demos to share what I learned, attempting to deliver on my pact with my CIO and Director.

Well, that came true today in full-circle & the feedback was amazing!

Recording:

Slides:

Description:

This is a summary of the sessions I attended at PASS Summit 2017. Out of the week-long conference, I put together these slides to summarize the conference and share with you what I learned. The slides are about the sessions that I found had the most value and include demos I personally developed and tested, alike the speakers at the conference.

Agenda:

Schedule

Keynotes

Session notes and takeaways

Demos

Follow-up resources

Raffle

Topics:

Columnstore Indexes

Performance 2017 vs 2016

Automatic Tuning

Docker / SQL Operations Studio / GitHub (DevOps)

Power BI

Security (Encryption / Dynamic Data Masking / Row-Level-Security)

Cosmos DB

Predictive Analytics (Machine Learning and AI)

Resources: http://goo.gl/BqfYSi

GitHub: https://github.com/hfleitas

Special thx to the folks that were extremely helpful throughout my journey and put up with all my emails and questions. @bobwardms @AndyPT @ericskang @sammesel

Thank you,

Hiram

SQL Pass Summit 2017 Yesterday was another good day at work. Since returning from summit, I spent a rigorous amount of time developing slides & demos to share what I learned, attempting to deliver on my pact with my CIO and Director.

[seniordba]

Top 8 Features of SQL Server 2016

Microsoft recently announcedthe top eight features of SQL Server 2016. The earlier versions of SQL Server has had unparalleled performance, but Microsoft mat have outdone themselves this time with groundbreaking additional features. Microsoft SQL Server is the most popular commercial enterprise-level relational database management system available today. You will be able to scale up to 12TB of…

View On WordPress

[hiramfleitas]

My Schedule @SQLPASS Summit 2017

My Schedule @SQLPASS Summit 2017

Here’s my week’s schedule – narrowed down with help of friends, for my 1st time at SQL PASS Summit 2017 in Seattle, WA.

Here’s the full conference schedule: http://www.pass.org/summit/2017/Sessions/Schedule.aspx

My Schedule:

Precon:

Mon: Data Modeling with Power BI (603, Marco)

Tues: Columnstore Indexes – Practical Solutions & Techniques (606, Niko)

Conf:

Wed:

1015am: Benchmarking & Testing…

View On WordPress