What's Your Ideal DBA Job?
Brad engages in a little Summer daydreaming, and wonders what the Ideal DBA job would look like...
Page compression in SQL Server 2008
Page compression is a new feature available in Enterprise and Developer editions of SQL Server 2008. In this article, MAK discusses how to enable PAGE data compression on a table and index.
When the next object-persistence boat comes in.
Phil enjoys an old Microsoft Training manual and wonders why it is no longer possible to encompass the whole of SQL in a 400 page book any more..
Who's been logging into my SQL Server?
In a recent blog post, see the steps Denny Cherry thinks are vital to monitoring both successful and unsuccessful outside user logins to your SQL Server.
Making Demands
Imagine you are invited to speak somewhere and you have a bit of power. Have some fun with this Friday's poll and let us know what you'd demand.
On Error () Logging by Using Event Handlers
Use of event handlers provided in SSIS package to handle runtime errors while the package is running and logging the error information in the database.
Identifying Object Dependencies in SQL Server
Is there a way to identify which objects are dependent on other objects within a SQL Server database? I need to modify the table structure to add new columns. However, before making any changes I want to make sure that I understand all the object dependencies. Is there a way in SQL Server 2008 to quickly identify all the object dependencies?
Introduction to Fast Track Data Warehouse Architectures
This paper provides an overview and guide to SQL Server® Fast Track Data Warehouse, a new set of reference architectures created for scale-up (SMP) SQL Server based data warehouse solutions. It includes a summary of the resources available in the reference configuration, the distinguishing features of the approach, and the steps necessary to take full advantage of the new architectures.
Making Demands
Imagine you are invited to speak somewhere and you have a bit of power. Have some fun with this Friday's poll and let us know what you'd demand.
The secret skill revealed in the dusty booklet
Going through one’s father’s belongings after his death is always a poignant, bitter-sweet experience. I was going through his most precious books a while back; there were books that were written by him, books by friends and relatives, books about friends...
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