How to Get the Output of a Stored Procedure into a Table
Putting the output of a stored procedure into a table provides you multiple options for parsing and using the output with other TSQL commands. Read on to learn more.
2016-11-30
9,898 reads
Articles
Who the Devil Wrote This SQL Code?
The way that you format T-SQL code can affect the productivity of the people who have to subsequently maintain your work. It is never a good experience to see SQL Code, cry out “Who the devil wrote this code?”, and then realise that it was you. Grant gives some examples of bad formatting and explains why you should never check-in badly-formatted SQL code.
2016-11-29
6,105 reads
How to Change an Analysis Services Instance to Tabular Mode
In this post I will show a procedure to change Analysis Services instance to tabular mode in SQL Server 2016 if you accidentally setup SQL Server Analysis Services to multi-dimensional mode instead of Tabular mode
2016-11-28
47,830 reads
Experience SQL Server 2016 in Microsoft Luxembourg’s Intelligent Office
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
Migrating Databases to Azure SQL Database
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
What is Azure SQL Data Warehouse?
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
Top 5 things you MUST know about PowerPivot for Excel
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
What's New in SQL Server Reporting Services 2016
Koen Verbeeck provides an overview of the new features and capabilities found in SQL Server Reporting Services 2016.
2016-11-25
5,009 reads
Change the Collation Setting for Clustered SQL Server 2014 Instance
In this post I will show a procedure to change collation settings of SQL Server 2014 cluster instance.
2016-11-24
3,439 reads
5 Advantages of Load Balancing For IT Companies
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
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers