The Average Joe
Most of us, by definition, are average. That's fine most of the time, but when you want a new job, standing apart from the average Joe is a good idea. Steve Jones talks about working on standing apart from the crowd.
President's Day 2010
A holiday in the US has Steve Jones on the slopes. A short reminder of patches released last week is the editorial today.
The Community Has Been Heard
Steve Jones talked about the announcements of Service Pack 4 for SQL Server 2005 and Service Pack 2 for SQL Server 2008 in this editorial.
Webinar Series: SQL Server 101
A partnership with Pragmatic Works brings you some basic SQL Server training through a series of webinars.
Use SSIS to import one cell of an Excel file into SQL Server
Recently I needed to find a method to import one cell of an Excel sheet into SQL Server 2005 using a scheduled job on a 64 bit clustered environment. For example, I have a monthly sales report listing sales per product category, such as Books, Magazines, DVDs, etc. I only want to import the Total Sales amount into SQL Server and this number is located in an Excel file "sales.xls.sheet1.cell.B5". I used to use OPENROWSET to solve the problem, however OPENROWSET requires Microsoft Jet OLE DB Provider which is not available in 64 bit. In this tip I am going to talk about how to use SSIS to accomplish this task easily.
Safety in Numbers
One of the core things a DBA must do is ensure backup and recovery of data. This Friday Steve Jones asks about your tolerance for safety and backup data in a Friday poll.
Tips for New DBAs
New and old DBAs alike can benefit from going back to the roots of the profession. This series of articles highlight the skills needed to move to the next level of Database Administration.
Azure Tutorial - Building a'Hello Word' app in Visual Studio
This article demonstrates how to build a simple Azure app using Visual Studio
SSIS Alpha Splits using the CODEPOINT() Function
A relatively common requirement in ETL processing is to break records into disparate outputs based on an alphabetical split on...
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers