WWBOD
This Friday's poll asks you to tell us what you'd do if you won the lottery. Is there something that you'd rather be doing than your current job? Dream a little and let us know.
SQL Server Log Shipping to a Different Domain or Workgroup
Sometimes the requirement arises to provide a copy of your database to an off-site location, such as a disaster recovery datacenter. Log Shipping is one of the most popular, proven technologies used to create a copy of your databases on a remote server.
Coding More Carefully
If you had less resources or compilation too longer, would you code more carefully? Steve Jones talks about the benefits that might come from not having the latest and greatest hardware.
ETL Magic with SSIS – Part II
Part II of a discussion and demonstration of ETL of a CSV data file using SSIS.
Grant Fritchey's SQL Server Howlers
We decided to ask various well-known SQL Server people to write about their favorite SQL Server Howlers. These are those common misunderstandings about how SQL Server works that end in tears, and plaintive forum questions. Grant Fritchey opens the series with some of those howlers that stick in the mind.
Cloud Safety
Is the cloud secure? How can you be sure? Steve Jones talks a little about some ways you can try to check on your cloud provider.
Getting Started with Business Intelligence Semantic Model (BISM) in SQL Server 2012
The Business Intelligence Semantic Model is one of the most significant enhancements in SQL Server 2012. BISM allows aspects of the traditional multidimensional model to coexist with the relational model in a format called the tabular model and can be used with all client tools in the Microsoft BI stack.
Dynamically create and populate staging tables from CSV files
This SSIS package reads the first line of a CSV file to obtain field names, then creates a table based on those field names and loads the remaining lines into the table.
Raw Materials - Order! Order!
Leibniz breaks out of a buyer's dilemma that might defeat a subtler mind.
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
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
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