Formatting Dates with 3 Character Months (SQL Spackle)
Another in the series of articles to help you "fill in the cracks" in your T-SQL knowledge. MVP Jeff Moden shows us a super simple, high performance method to solve this timeless problem.
New Resource: LearnSomeSQL.com
We're trialling a new resource for SQL beginners and we'd like to know what you think.
Disaster Recovery Tip #4 - Learn about partial restores!
Sometimes recovery simply entails rerunning a failed process.
Telemetry basics and troubleshooting
From the MSDN Windows Azure blog - We recently introduced Azure CAT team series of blog posts and tech articles describing the Cloud Service Fundamentals in Windows Azure code project posted on MSDN Code Gallery. The first component we are addressing in this series is Telemetry. This has been one of the first reusable components we have built working on Windows Azure customer projects of all sizes.
Password Ninjas
How do you keep track of passwords? A few experts out there share some of their techniques and Steve Jones adds his thoughts.
Resolving Errors While Connecting to SSIS
This article will help you solve connection errors with SSIS due to permission issues.
How To Document Your PowerShell Library
PowerShell provides comment-based help for functions and scripts with Get-Help, but when you want to document modues or generate a complete indexed API in HTML format, just as you can with Sandcastle for .NET or javadoc for Java, then stronger magic is required. Michael Sorens shows you how it is done, with source code.
SQL in the City Seminar Sacramento 2013
Join Red Gate for a free a seminar on July 26 (the day before SQL Saturday Sacramento). SQL Server MVP experts, Steve Jones and Grant Fritchey will present sessions featuring best practices for SQL Server database development and deployment, in addition to showing Red Gate tools in action.
SQL Saturday #239 East Iowa
SQL Saturday will be in Iowa City on July 27, 2013. This free day of SQL Server Training and Networking will also have pay-for pre-conference sessions presented by Bill Pearson, Louis Davidson and Tim Mitchell.
Data Philanthropy
The idea of giving back to the world some of your success has been something many successful businesses have done forever. Steve Jones thinks they should consider giving more than physical resources, but also give data.
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
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
From SQL Server On-Premises to Claude Desktop: How I built a Full MCP Pipeline
Comments posted to this topic are about the item From SQL Server On-Premises to...
Independence Day 2026
Comments posted to this topic are about the item Independence Day 2026
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers