Although quite a lot has been written about PowerPivot and its features, there are certain aspects about PowerPivot that may not be obvious, especially to someone who is new to the tool. This articles discusses five such items.
2016-11-25 (first published: 2015-01-12)
9,763 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
In this post I will show a procedure to change collation settings of SQL Server 2014 cluster instance.
2016-11-24
3,435 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
2016-11-23
96 reads
In this post I will show a procedure to configure Integration Services in a SQL Server 2016 Cluster.
2016-11-22
5,046 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
2016-11-21
4,642 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
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
Comments posted to this topic are about the item Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers