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.
Automating Red Gate SQL Compare with MSSQL Server Agent
How to compare two databases and email the results to every one who needs to know
SQL Overview SSIS Package III - Full Package
Continuing on with his series on reporting for your SQL Server, David Bird brings together the series with the full package used for building the report.s
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers