System Sessions/Spids Rather than Spid < 50
Saw System Sessions posted on the PSS blog and it shows an example of information being written to the error...
2008-01-23
609 reads
Finding missing rows
One way to find the rows from one table that don't match another table is to use a sub-query. Here is...
2008-01-22
542 reads
We Are Microsoft Charity Challenge Weekend
This weekend, I had the unique opportunity to donate some time to a worthwhile charity organization. Through the efforts of...
2008-01-21
844 reads
A Holiday Posting
It's Martin Luther King, Jr. day here in the US where we remember the famous civil rights leader. So my...
2008-01-21
676 reads
Free Subscriptions to Visual Studio Magazine
First time I've noticed this being offered, saw it posted on the Orlando .Net Users Group (ONETUG) site. Sign up...
2008-01-21
1,449 reads
Learning to Blog via Books
I was chatting with a friend recently and in the course of 'what are you up to lately' I mentioned...
2008-01-20
497 reads
Connecting to a Reporting Services Model
There's always been some confusion about models in Reporting Services, many people ignore them thinking that they are only for...
2008-01-18
1,566 reads
Free Ebook Chapter(Book) - Introducing SQL Server 2008
Saw it mentioned in the recent MSPress newsletter, Peter DeBetta is writing Introducing SQL Server 2008 and right now Chapter...
2008-01-18
867 reads
The Interviewer is Wrong
Michael Coles had an interesting post about a job interview a friend went on. The person answered questions correctly, but...
2008-01-17
882 reads
MVP Chat
My first MVP chat was today, a monthly hour long session where we have a Microsoft representative and we all...
2008-01-17
725 reads
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
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...
TempDB Facts I
Comments posted to this topic are about the item TempDB Facts I
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers