DBA relationships – The data custodian
G’day,
As DBA’s, we all know how to manage security, some are more advanced that others but ensuring that the right...
2011-04-28
2,272 reads
measure twice, cut once.
Connection strings and application name
G’day,
There are many things that developers and DBA’s can do to help their relationships run smoothly, most of them are relatively simply...
2011-04-27
14,733 reads
The developer / DBA relationship.
G’day,
A large part of my job involves liaising with developers. I spent the first 8 years of my IT career working as...
2011-04-27
2,657 reads
A small facet of information
G’day,
I’ve blogged about facets before, but I just thought that I’d mention them again, as they came in quite handy...
2011-04-24
519 reads
PowerShell Tip – Custom windows for different tasks.
G’day
There seems to be a lot of articles around at the moment concerning the use of PowerShell.
I think this is...
2011-04-22
735 reads
DBCC TraceOn – some processes are global.
Hi,
I was recently doing some testing as I thought that I’d experiment with the ghost clean up process.
I found that...
2011-04-13
2,649 reads
So, what’s this heap thing?
G’day,
I’ve been asked a few times lately to explain what a heap is.
I’m quite happy to do this, but I...
2011-04-10
2,397 reads
This appears to be a system procedure..but it isn’t!
G’day,
Recently, I was browsing through my database server when suddenly under the “System Stored Procedures” folder of the master database...
2011-04-05
2,031 reads
View system object definitions
G’day,
You’ve probably all noticed that when you right click on a user database object in SSMS object explorer that you...
2011-04-03
625 reads
If you fire that trigger, make sure you have the correct ID
G’day,
I think it would be a fair bet to say that we’ve all used the @@IDENTITY function. It returns the...
2011-04-02
568 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers