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.
EzAdo Part 4
EzAdo is a very simple api built to exploit some new features of SQL 2016. It combines software, convention, and creativity to get more done in less time.
Finally, Create or Alter
Today Steve Jones looks at the CREATE OR ALTER syntax, added in SQL Server 2016 SP1.
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.
Hire the Right People
Today Steve Jones discusses the need to hire the people to do the tasks we need done, not the position we filled.
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
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.
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.
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.
Online T-SQL Scripts and Copyright
The issue of copyright for online scripts is a grey area. If a script is published without any form of copyright notice, most people assume that it is freely available for reuse. It's not necessarily the case.
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Alamat kontak resmi BCA KCP Klender Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. I Gusti Ngurah Rai No.8 A-B, RT.8/RW.6, Wil, Kec. Duren Sawit, Kota...
Alamat kontak resmi BCA KCP Santa Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Wolter Monginsidi No.54, RT.2/RW.4, Petogogan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah...
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers