My First White Paper – Top 10 Tips for Optimizing SQL Server Performance
Earlier this year I had the chance to collaborate on my first ever white paper “Top 10 Tips for Optimizing...
2013-04-30
1,432 reads
Blog Posts
PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers.
We came across a scenario where database bak files being created from long time which are no more in use...
2013-04-30
1,111 reads
SQL Server +0 and -0
This is a very interesting error happened in one of my clients’ databases. Their database has been running for at...
2013-04-30
1,571 reads
Configuring PerformancePoint in SharePoint 2013
Last week while assisting a customer configure SharePoint BI I ran into an interesting problem when configuring PerformancePoint. After following...
2013-04-29
1,905 reads
Creating a Shared Dataset with Report Builder
I was recently asked by a customer if you could build a Shared Dataset using Report Builder 3.0. More specifically,...
2013-04-29
2,936 reads
DMV-9 : Digging out details of CLR Tasks……..sys.dm_clr_tasks
sys.dm_clr_tasks DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-in/library/ms177528.aspx
Returns a row for all common language runtime (CLR) tasks...
2013-04-29
1,800 reads
Error while enabling Windows Feature: Netfx3
Recently I was setting up a virtual machine environment to do some demo’s. One of the virtual machines would be...
2013-04-29
9,072 reads
How to collect cluster Information using TSQL
Sometime back I was involved in a project which was to collect information for the servers we are supporting – creating...
2013-04-29
1,893 reads
How to provide a better customer service
Thomas La Rock (Blog | Twitter) recently wrote a blog post about misplacing a device he has called a FitBit One which...
2013-04-29
1,726 reads
INFORMATION_SCHEMA the un-sung system views
I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others....
2013-04-29
2,631 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Designing for Teams
Comments posted to this topic are about the item Designing for Teams
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers