Detective Stories - Changing the Case
How to change your "UPPER" or "lower" case strings to a mixed case
Software Assurance Cuts Back
Software Assurance from Microsoft is losing a benefit and Steve Jones comments.
TSQL Challenge 41 - Extract email addresses from text data
This challenge involves extracting email addresses from a table that contains text data downloaded from various websites.
When Times are Tough, Do You Rise to the Occasion?
Life isn't fair, and things don't always go your way. In fact, most people hit a tough patch sooner or later. When that happens to you, how do you respond?
Create a Performance Baseline Repository
This article demostrates how to create a Baseline repository that holds summarized data of all SQL Executions executed on an instance of SQL Server.
Announcing the New PowerShell Virtual Chapter of PASS!
PASS is launching a new PowerShell Virtual Chapter. It's first meeting is next Wednesday at 12 pm EDT.
Risk Analysis
This Friday Steve Jones asks about your spending on Disaster Recovery and is it in line with the risks involved.
Sending multiple rows to the Database from an Application: Part I
New author Mohd Nizamuddin brings us the start of a series that talks abuot how you can send multiple rows to the database from an application.
Manage Database Projects With Visual Studio 2010
This article demonstrates how to manage database projects with Visual Studio 2010.
Data Distribution - Part 2
In the second part of this series, Leo Peysakhovich provides a mechanism for tracking real time data changes.
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
TempDB Facts I
Comments posted to this topic are about the item TempDB Facts I
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers