Patching
Probably the least enjoyable thing about being a DBA is patching servers. We received the bad news in the July MS...
2008-07-19
1,919 reads
Follow Up Notes on the Custom Whiteboard
A few months back I posted about our latest whiteboard and I thought I'd report back with an update. Initially...
2008-07-17
513 reads
JSSUG Speaking Event: Reporting Services 2008
We had a great group of about 35 people last night at the JSSUG (Jacksonville SQL Server User Group) meeting....
2008-07-17
717 reads
Tools
Below is a list of various tools I use, some SQL related and some not. Follow the links to my...
2008-07-17
1,178 reads
Comments on Dissecting SQL Server Execution Plans by Grant Fitchey
Long time SSC participant Grant Fitchey has published a great book on reading/understanding execution plans. I finally had the chance...
2008-07-16
1,361 reads
SQL Server 2008: Implementation and Maintenance, Beta Exam
I signed up for the SS2K8 beta exam, the maintenance and implementation one, and had it scheduled for this morning....
2008-07-16
861 reads
Reminder - Midlands PASS Chapter Meeting - July 17 - MVP John Welch
The Midlands PASS Chapter hosts:
SQL Server MVP John Welch
July 17, 2008 at Training Concepts
The Midlands PASS chapter will hold a...
2008-07-16
631 reads
Jacksonville Code Camp Set for August 23, 2008
The fourth annual Jacksonville Code Camp is set for August 23, 2008 and it looks like they are off to...
2008-07-15
467 reads
Find all views created on a table
USE ADVENTUREWORKS;-- You can use any kind of database that you have
GO
--Procedure that shows all views created on a table,...
2008-07-15
639 reads
MentoringNet
I ran across MentoringNet in a recent renewal flyer from ACM. I'm interesting in all things mentoring, so I went...
2008-07-14
1,005 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers