Using a Recursive CTE to Generate a List
Learn how to generate lists of column values from multiple rows by grouping and using a recursive CTE. This is a very flexible and easy implementation, compared to using cursors or PIVOT operators.
Getting Started with Power BI Designer
The Power BI Designer was recently added under the Microsoft Power BI umbrella. Power BI Designer quickly builds reports or dashboards locally and deploys them to the Power BI site. In this article, Arshad Ali demonstrates how to get started with Power BI Designer.
#SQLNewBlogger
Steve Jones talks about blogging today, how it can help your career, and how easy it can be to get started.
Integration Services, MySql and SET FMTONLY ON
Challenges with integrating MySQL data in an ETL regime and the Amazing FMTONLY trick!
Learning SQL Server 2012
A collection of technologies and links that will help you learn more about SQL Server 2012.
Microsoft Azure Stream Analytics
Azure Stream Analytics aims to extract knowledge structures from continuous ordered streams of data by real-time analysis. It provides a ready-made solution to the business requirement to react very quickly to changes in data and handle large volumes of information. Robert Sheldon explains its significance.
SQL Monitor Custom Metric: Memory Used By Ad Hoc Queries Running Once
This metric measures the amount of memory used by the total number of ad-hoc queries that are currently in the plan cache. If the value is high, it indicates memory is being wasted by storing the execution plans of queries that will never be run more than one time.
Export SQL Server Reporting Services Report Data into Multiple Excel with Worksheets
Sometimes SQL Server Reporting Services users want to export SSRS reports into Excel with multiple sheets, but when the SSRS report data region (Tablix/Matrix) doesn't have any grouping then all the data will be exported into a single sheet. Ghanesh Prasad explains how to export a SSRS report into Excel with multiple sheets.
Skill Supply and Demand
Finding staff with the proper skills can be a challenge, and it might be a reason why you choose, or remain with, a particular technology.
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Secure Communications
Comments posted to this topic are about the item Secure Communications
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers