archive-be.com » BE » S » SQLUG.BE

Total: 294

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • Events - SQLUG.be
    dry 2013 SQL Server Days 2013 Parallel Data Warehouse Modern Data Warehousing Strategy The dangerous beauty of Bookmark Lookups Love is AlwaysOn and Contained Databases What is Big Data Automating SSRS Deployments 2012 SQL Server Days 2012 Powershell The DBA as a consumer An evening in the cloud the old the new and the big xVelocity and DAX in Action ColumnStore Indexes in SQL Server 2012 Power View and SQL Server 2012 2011 SQL Server Days 2011 Database Mirroring Microsoft Clustering and Virtualization PowerPivot BISM and the future of a BI Solution SQL Server Locking SQL Server Forensic Analysis 2010 SQL Server Days 2010 Ask the Experts What is System Center Operations Manager 2007 R2 and how can it help in managing SQL Servers Resource Governor SQL Server Service Broker and some of the things it can do for you About us Our Profile Our Goal Why register Our team Hosting by combell Contact us Speeding up your ETL with CDC 15 01 2015 Datasets used for applications and analysis are growing larger every day And even though hardware is getting cheaper this gives us the same challenges we had 10 to 20 years ago We need to think smarter about the amounts of data we store and process Not only production system performance is important our nightly ETL is also bound to timeslots But what is your dataset becomes too large to process in a designated timeslot One of the technical options you have to solve this is using CDC Change Data Capture In this session you ll get an introduction to CDC a look at why CDC is your best option we re going to look at the pros and cons of CDC and see how easy it might be to implement it in your company About Jeffrey

    Original URL path: http://sqlug.be/events/20150115 (2016-04-30)
    Open archived version from archive


  • Events - SQLUG.be
    AlwaysOn and Contained Databases What is Big Data Automating SSRS Deployments 2012 SQL Server Days 2012 Powershell The DBA as a consumer An evening in the cloud the old the new and the big xVelocity and DAX in Action ColumnStore Indexes in SQL Server 2012 Power View and SQL Server 2012 2011 SQL Server Days 2011 Database Mirroring Microsoft Clustering and Virtualization PowerPivot BISM and the future of a BI Solution SQL Server Locking SQL Server Forensic Analysis 2010 SQL Server Days 2010 Ask the Experts What is System Center Operations Manager 2007 R2 and how can it help in managing SQL Servers Resource Governor SQL Server Service Broker and some of the things it can do for you About us Our Profile Our Goal Why register Our team Hosting by combell Contact us Big Data vs Many data with a dive into the PDW 05 06 2014 Big data is the marketing term du jour but what is it really As a broad umbrella term it can be misleading and many so called big data problems are what I would call many data problems In this session I will take you through big data many data scale out in operational and reporting systems and then dive into my personal favorite piece of the big data tools Microsoft s Parallel Data Warehouse and talk about my experiences working on this technology You ll learn about the 3 Vs of big data the CAP theorem and spend a little time learning about distributed systems messaging and complex event processing On the BI side you will learn the history starting with OLAP Online Analytic Processing in memory and column store technologies and learn the theory of MPP Massively Parallel Processing You will learn about distribution how statistics work in a PDW the

    Original URL path: http://sqlug.be/events/20140605 (2016-04-30)
    Open archived version from archive

  • Events - SQLUG.be
    high and dry 2013 SQL Server Days 2013 Parallel Data Warehouse Modern Data Warehousing Strategy The dangerous beauty of Bookmark Lookups Love is AlwaysOn and Contained Databases What is Big Data Automating SSRS Deployments 2012 SQL Server Days 2012 Powershell The DBA as a consumer An evening in the cloud the old the new and the big xVelocity and DAX in Action ColumnStore Indexes in SQL Server 2012 Power View and SQL Server 2012 2011 SQL Server Days 2011 Database Mirroring Microsoft Clustering and Virtualization PowerPivot BISM and the future of a BI Solution SQL Server Locking SQL Server Forensic Analysis 2010 SQL Server Days 2010 Ask the Experts What is System Center Operations Manager 2007 R2 and how can it help in managing SQL Servers Resource Governor SQL Server Service Broker and some of the things it can do for you About us Our Profile Our Goal Why register Our team Hosting by combell Contact us Unravelling SQL 2014 In Memory OLTP 13 05 2014 Since SQL Server In Memory OLTP was unveiled last November there has been a lot of conversation and buzz about it The new SQL Server 2014 introduces memory optimized database technology for optimizing the performance of OLTP workloads In particular it introduces memory optimized tables for efficient contention free data access and natively compiled stored procedures for efficient execution of business logic All of this and more About Mario Van Hissenhoven Mario is a Microsoft Certified Trainer for SQL Server as a developer administrator with more than 14 years of experience His specialties are SQL Server Development query tuning and writing complex stored procedure His database related knowledge goes from database modelling to design complex queries and optimization of performance He has experience as a developer with ETL SSIS the design of dashboards and

    Original URL path: http://sqlug.be/events/20140513 (2016-04-30)
    Open archived version from archive

  • Events - SQLUG.be
    of Bookmark Lookups Love is AlwaysOn and Contained Databases What is Big Data Automating SSRS Deployments 2012 SQL Server Days 2012 Powershell The DBA as a consumer An evening in the cloud the old the new and the big xVelocity and DAX in Action ColumnStore Indexes in SQL Server 2012 Power View and SQL Server 2012 2011 SQL Server Days 2011 Database Mirroring Microsoft Clustering and Virtualization PowerPivot BISM and the future of a BI Solution SQL Server Locking SQL Server Forensic Analysis 2010 SQL Server Days 2010 Ask the Experts What is System Center Operations Manager 2007 R2 and how can it help in managing SQL Servers Resource Governor SQL Server Service Broker and some of the things it can do for you About us Our Profile Our Goal Why register Our team Hosting by combell Contact us Your backups high and dry 10 02 2014 One of the most important tasks of every DBA is developing a good backup strategy You ve probably written your own scripts or used the maintenance solution of Ola Hallengren But where do you store your backups On your SAN or on tape And how many times did you forget to switch tapes or did you have to bring the tape to a safe deposit box Well Microsoft recently announced several new ways to back up and recover SQL Server databases with Windows Azure These features provide an easy way to cloud backup and disaster recovery for on premises databases This session provides a detailed explanation of the new SQL Server 2014 Backup features to Windows Azure like manual managed backup encryption and backup to Windows Azure Tool The session is bulk loaded with demos and it will give you an idea if these new features can be helpful in your environment About

    Original URL path: http://sqlug.be/events/20140210 (2016-04-30)
    Open archived version from archive

  • Events - SQLUG.be
    introduction All about SQL Server Data Tools Data Platform components on the Microsoft Azure Platform Power BI Dashboarding Exploring Power Query Microsoft Azure for Developers Analyzing I O Subsystem Performance Database Design Throwdown Speeding up your ETL with CDC 2014 Big Data vs Many data with a dive into the PDW Unravelling SQL 2014 In Memory OLTP Your backups high and dry 2013 SQL Server Days 2013 Parallel Data Warehouse Modern Data Warehousing Strategy The dangerous beauty of Bookmark Lookups Love is AlwaysOn and Contained Databases What is Big Data Automating SSRS Deployments 2012 SQL Server Days 2012 Powershell The DBA as a consumer An evening in the cloud the old the new and the big xVelocity and DAX in Action ColumnStore Indexes in SQL Server 2012 Power View and SQL Server 2012 2011 SQL Server Days 2011 Database Mirroring Microsoft Clustering and Virtualization PowerPivot BISM and the future of a BI Solution SQL Server Locking SQL Server Forensic Analysis 2010 SQL Server Days 2010 Ask the Experts What is System Center Operations Manager 2007 R2 and how can it help in managing SQL Servers Resource Governor SQL Server Service Broker and some of the things it can do for

    Original URL path: http://sqlug.be/events/20131107 (2016-04-30)
    Open archived version from archive

  • Events - SQLUG.be
    old the new and the big xVelocity and DAX in Action ColumnStore Indexes in SQL Server 2012 Power View and SQL Server 2012 2011 SQL Server Days 2011 Database Mirroring Microsoft Clustering and Virtualization PowerPivot BISM and the future of a BI Solution SQL Server Locking SQL Server Forensic Analysis 2010 SQL Server Days 2010 Ask the Experts What is System Center Operations Manager 2007 R2 and how can it help in managing SQL Servers Resource Governor SQL Server Service Broker and some of the things it can do for you About us Our Profile Our Goal Why register Our team Hosting by combell Contact us Parallel Data Warehouse 30 09 2013 Unlike most vendors who opt to provide their high end appliances for a high price or provide a relational data warehouse appliance that is disconnected from their Big Data and or BI offerings Microsoft SQL Server Parallel Data Warehouse provides both a high end massively parallel processing appliance that can improve your query response times up to a hundred times over legacy solutions as well as seamless integration with both Hadoop and the usual business intelligence solutions The main topic of the evening will be about the new Parallel Data Warehouse PDW 2 0 and more in particular the alignment with Microsoft s preferred technology partner HP About the speakers Corinne Haesaert is an HP p re sales advocate in the business critical server division part of HP s enterprise server storage and network division She has a strong focus on solution selling and is specialised in mission critical servers HP UX relational databases high availability and disaster recovery Henk van der Valk joined Microsoft last year to focus on SQL Server Parallel Data Warehouse PDW He is a regular guest speaker of SQLPass in the netherlands and

    Original URL path: http://sqlug.be/events/20130930 (2016-04-30)
    Open archived version from archive

  • Events - SQLUG.be
    An evening in the cloud the old the new and the big xVelocity and DAX in Action ColumnStore Indexes in SQL Server 2012 Power View and SQL Server 2012 2011 SQL Server Days 2011 Database Mirroring Microsoft Clustering and Virtualization PowerPivot BISM and the future of a BI Solution SQL Server Locking SQL Server Forensic Analysis 2010 SQL Server Days 2010 Ask the Experts What is System Center Operations Manager 2007 R2 and how can it help in managing SQL Servers Resource Governor SQL Server Service Broker and some of the things it can do for you About us Our Profile Our Goal Why register Our team Hosting by combell Contact us Modern Data Warehousing Strategy 11 06 2013 The recent introduction of new technologies like PowerPivot BI Semantic Model columnstore indexes in SQL Server and the more general trend of advances in Self Service BI and Big Data might be considered threats to the classic data warehouse ecosystem In reality a good data warehouse is still the best starting point for any kind of analysis but it is necessary to update the strategy of its implementation and evolution in this new era This session will start the conversation about what a modern strategy for data warehousing can be in this era Which type of data modeling we should use for the data warehouse What is the role of the data marts Does the use of technologies like PowerPivot or Analysis Services Tabular affect the way you should model your data Do the columnstore indexes remove the need of an analytical server like Analysis Services We will try to answer to these and other questions offering an updated approach to the data warehouse modeling methodology About Marco Russo Marco Russo is a consultant and trainer in Business Intelligence and software

    Original URL path: http://sqlug.be/events/20130611 (2016-04-30)
    Open archived version from archive

  • Events - SQLUG.be
    Unravelling SQL 2014 In Memory OLTP Your backups high and dry 2013 SQL Server Days 2013 Parallel Data Warehouse Modern Data Warehousing Strategy The dangerous beauty of Bookmark Lookups Love is AlwaysOn and Contained Databases What is Big Data Automating SSRS Deployments 2012 SQL Server Days 2012 Powershell The DBA as a consumer An evening in the cloud the old the new and the big xVelocity and DAX in Action ColumnStore Indexes in SQL Server 2012 Power View and SQL Server 2012 2011 SQL Server Days 2011 Database Mirroring Microsoft Clustering and Virtualization PowerPivot BISM and the future of a BI Solution SQL Server Locking SQL Server Forensic Analysis 2010 SQL Server Days 2010 Ask the Experts What is System Center Operations Manager 2007 R2 and how can it help in managing SQL Servers Resource Governor SQL Server Service Broker and some of the things it can do for you About us Our Profile Our Goal Why register Our team Hosting by combell Contact us The dangerous beauty of Bookmark Lookups 18 04 2013 You know Bookmark Lookups in SQL Server and you rely on them for your indexing strategy But do you also know that they are the most dangerous thing in SQL Server which can lead to massive performance losses that blows up your CPU and I O resources Join this session to get a basic understanding of Bookmark Lookup and their associated performance problems In detail you will learn about The Tipping Point Parameter Sniffing Problems Bad Statistics Auto Forced Parametrization Bookmark Lookup Deadlocks About Klaus Aschenbrenner Klaus Aschenbrenner provides independent SQL Server Consulting Services across Europe and the US Klaus works with the NET Framework and especially with the SQL Server 2005 2008 from the very beginnings In the years 2004 2005 Klaus was entitled with

    Original URL path: http://sqlug.be/events/20130418 (2016-04-30)
    Open archived version from archive