Becoming a DBA
Steve Jones was recently asked how he knows someone is ready to be a DBA. It's an interesting question and he shares some thoughts on this today.
2009-06-22
590 reads
Articles
Logging connection strings
If you some of the dynamic features of SSIS such as package configurations or property expressions then sometimes trying to work out were your connections are pointing can be a bit confusing.
2009-06-22
3,641 reads
Using the OBJECT_SCHEMA_NAME function to return the schema name
I tend to do a great deal of meta-data (or is it metadata) mining from the system compatibility views and system catalog views in order to build dynamic ad-hoc T/SQL code to use for various administrative processes.
2009-06-22
3,158 reads
What I’ve Read and Recommend to Others – SQL Server 2008 Part 1
I read, a lot. I’ve been a prolific reader all my adult life. I use to split my reading between tech books and my regular relaxing reading but since I got into audio books several years ago I just pretty much read tech books now. Some times I’ll listen..
2009-06-22
2,905 reads
Grown Up Software
We all want to write better software, but do we really want to write grown up software? Steve Jones talks about one of the most successful software groups ever.
2009-06-21
469 reads
Grown Up Software
We all want to write better software, but do we really want to write grown up software? Steve Jones talks about one of the most successful software groups ever.
2009-06-21
434 reads
Grown Up Software
We all want to write better software, but do we really want to write grown up software? Steve Jones talks about one of the most successful software groups ever.
2009-06-21
745 reads
My Approach to Writing for SQLServerCentral
Are you looking to raise your profile? Add something to your resume? Consider writing for SQLServerCentral. Longtime author and expert David Poole gives us some hints.
2009-06-19
3,142 reads
Prepare SQL Server 2005 in a Clustered Environment for SP3
This article from shows how to prepare your SQL Server 2005 clustered environment for Service Pack 3 and avoid some common problems.
2009-06-19
3,837 reads
Improving Performance with SQL Server 2008 Indexed Views
This document describes the indexed views capability of SQL Server 2005 and SQL Server 2008, including the new support for partition-aligned views added to SQL Server 2008. Indexed views are explained and specific scenarios in which they may provide performance improvements are discussed.
2009-06-19
4,111 reads
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers