The DBA Ultimate Fitness Workout Plan
If you plan to stay on top of your DBA game then you have to workout regularly.
Those of you that...
2011-02-15
690 reads
John Sansom
10 Things Every DBA Should Do
Recently I spoke about how The Best Database Administrators Automate Everything, as well as Document Everything and this got me...
2011-02-08
2,224 reads
Your Lack of Documentation is Costing You More Than You Think
You’ve got a mountain of work to get done and not enough time to do it in. There’s simply just not...
2011-02-01
1,499 reads
The Art of the Outstanding DBA
Being average is dull. Are we consistently producing quality that we can be proud of, each and every time? So...
2011-01-25
569 reads
Why Every DBA Needs a Buddy
If you truly desire to be an effective SQL Server Database Administrator then you absolutely must have a buddy.
SQL Server...
2011-01-18
1,899 reads
T-SQL Tuesday 14: Techie Resolutions for You not Me
Is it just me or has the community done the whole “What are my goals for this year” thing to...
2011-01-11
643 reads
The Best Database Administrators Automate Everything
Do you understand the value of your time? I mean really understand it. Time is your absolute number one most valuable asset. Once...
2011-01-04
1,416 reads
TSQL Tuesday 13: Managing Unrealistic Expectations
It’s that time of the month again, no not that one, it’s T-SQL Tuesday time and this weeks topic is...
2010-12-14
654 reads
Life Without a Net – My comment
Did you catch the brilliant and thought provoking editorial post Life Without a Net by Rodney Landrum on SQL Server...
2010-11-02
411 reads
The Perfect SQL Server DBA / Developer Role
Whilst enjoying my coffee fix this morning, along with today’s SQL Server Central Email, my attention was caught by Steve...
2010-09-09
342 reads
Blogs
Attacking the Weakest Link
By Brian Kelley
When I look at a system and think about its security model, the first...
Webinar – Microsoft Fabric for Dummies
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Forums
Extend Event with sqlserver.login
My knowledge of Extended Events is limited, but I am trying to capture some...
ghost backups processed 0 pages
I've got something I'm not aware of performing backups of my dbs at random...
Stored Procedures - passed string than variable length
Dear all, I was just wondering: Can you change the default behaviour as illustrated...
Question of the Day
The Backup File Extension
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers