The SQL Server Luxembourg User Group invites you to join us at our next event, in Microsoft’s new Intelligent Offices, for Tom van Zele’s SQL 2016 presentation. Tom’s road-show session highlights SQL Server 2016’s new features: End-to-end mobile BI, advanced analytics, cloud integration and lots of other new stuff will be addressed.
2016-11-28 (first published: 2016-11-23)
3,352 reads
Tim Radney of SQLskills discusses strategy and some available tools for helping migrate your databases to Azure SQL Database.
2016-11-28
2,879 reads
Azure SQL Data Warehouse is a cloud-based, scale-out database capable of processing massive volumes of data, both relational and non-relational. Built on our massively parallel processing (MPP) architecture, SQL Data Warehouse can handle your enterprise workload.
2016-11-28
249 reads
Koen Verbeeck provides an overview of the new features and capabilities found in SQL Server Reporting Services 2016.
2016-11-25
5,009 reads
As an IT company, it is crucial that you maintain uptime and monitor the performance of various processes. By making database load balancing a key element, you can ensure that your processes and websites run smoothly. Tony Branson explains.
2016-11-24
5,719 reads
Whether you are running an RDBMS, or a Big Data system, it is important to consider your data-partitioning strategy. As the volume of data grows, so it becomes increasingly important to match the way you partition your data to the way it is queried, to allow 'pruning' optimisation. When you have huge imports of data to consider, it can get complicated. Bartosz explains how to get things right; not perfect but wisely.
2016-11-22
3,345 reads
Rob Farley discusses some solutions and gotchas for implementing a custom sort using ORDER BY in T-SQL queries.
2016-11-21
3,624 reads
It is worth getting familiar with Apache Spark because it a fast and general engine for large-scale data processing and you can use you existing SQL skills to get going with analysis of the type and volume of semi-structured data that would be awkward for a relational database. With an IDE such as Databricks you can very quickly get hands-on experience with an interesting technology.
2016-11-18
3,131 reads
Receiving an access denied error message when trying to connect to a remote instance of SSIS from SSMS? Sadequl Hussain provides the solution.
2016-11-17
4,199 reads
Power BI Desktop continues to evolve. There have been many improvements to the reporting side that together make it easier to get from the data to the visualisation as quickly as possible. You can now create line charts that let users drill down into hierarchical data. There are now ways of adding dynamic reference lines to a visualization that provide users with relevant reference points. Robert Sheldon demonstrates how to combine these features to great effect.
2016-11-16
3,166 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers