SSRS - Report for Stored Procedure with Parameters
You receive a request from an analyst for a report to be built from a procedure they wrote. It will require parameters based on values currently in the database and ones that allow free-typing. This article will provide a basic walk-through on handling this type of request.
Getting Data Into and Out of PowerShell Objects
You can execute PowerShell code that creates the data of an object, but there is no cmdlet to generate the 'object notation' code from an existing PowerShell object; until now, that is. Phil Factor also produces a ConvertTo-YAML function and explains how they both work, with illustrative code.
A Fundamental Security Mistake
Steve Jones thinks Microsoft is making a fundamental security mistake in the way they build features for the various editions of SQL Server. Read today's editorial and see if you agree.
Normalizing Performance
Determining the best performance value you can get for your effort is not as straightforward as you might think.
Red Gate Software to unveil Database Lifecycle Management at PASS Summit
PASS attendees will get the chance to learn about Database Lifecycle Management (DLM) straight from its chief proponent: Red Gate Software, the database and .NET tooling company.
Format Durations in SQL Server Analysis Services
I have a fact table in my data warehouse that tracks durations of certain events as the total number of seconds that have passed. When users browse the cube, I’d like to show these durations formatted as time using the hh:mm:ss format. How can I do this in Analysis Services (SSAS)? - Koen Verbeeck responds.
The Geek Costume
This Friday Steve Jones has another fun poll. A question on the geek costume that might excite you the most.
Does NoSQL = NoDBA?
There’s a joke doing the rounds at SQL conferences and seminars: three DBAs walk into a NoSQL bar and leave when they can’t find a table. You may have heard it before, but it made Matt Hilbert sit down and ponder. What’s happening? Is there a division opening up between the newly fashionable NoSQL followers and DBAs? Matt enters the world of NoSQL to investigate.
Blogs
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
PowerShell Newbie – Variables
By gbargsley
This is Week 2 of PowerShell Strikes Back – a four-week May series for...
Forums
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers