Career Challenges - Database Weekly (Dec 15, 2008)
This week Steve Jones sees a lot of people talking about challenges in their career.
2008-12-13
835 reads
Articles
Career Challenges - Database Weekly (Dec 15, 2008)
This week Steve Jones sees a lot of people talking about challenges in their career.
2008-12-13
622 reads
ETL Auditing
This Article shows a method to audit ETL-Processes to be able to retrace processes and affected data.
2008-12-12
11,545 reads
2008-12-12
54 reads
Discover Analysis Service's Properties using Windows PowerShell and AMO
Part 2 of this series illustrates how to use Windows PowerShell and AMO to get the various Server properties of SQL Server Analysis Service.
2008-12-12
2,235 reads
Using SQL Server meta data to list tables that make up views
One of the issues I often face is the need to find views that are already established for certain tables. This maybe for other developers, end users or even for myself. I could search the system tables to find this or explore each view, but are there other ways to easily find a list of all tables that are used for a view or even a list of all views that a table is tied to?
2008-12-12
3,940 reads
Writing a Basic MDX Query Pt.2 - SQL School Video
In the second part of this basic video on MDX queries, MVP Brian Knight continues with his discussion of MDX, examining some more advanced MDX features.
2008-12-11
6,744 reads
Analyze and Fix Index Fragmentation in SQL Server 2008
This article describes how an index gets fragmented and the steps which a DBA can take to fix index fragmentation
2008-12-11
2,876 reads
Determine Object Dependencies Before Changing Your SQL Server Schema Design
Maintaining a database often means schema changes. Before you change or delete anything, be sure to check for dependent objects.
2008-12-11
2,638 reads
SQL Server 2008 Mirroring Testing
Comparison of performance of SQL 2008 mirroring to SQL 2005 mirroring.
2008-12-10
7,482 reads
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