Self Hosting WCF Services With Transport Security
When developing and debugging transport security WCF services it’s a real pain if each developer on the team needs to...
2013-03-15
212 reads
Renaming Server with SQL
I recently had to rename my laptop on which I have two SQL server instances. I have a default instance...
2013-03-14
1,690 reads
The STUFF function
While I was at the 2011 Pass Summit I was given the following piece of code to create a comma...
2013-03-14
907 reads
Customizing SSMS – Hiding the panels
This is a short series on some customizations in SSMS to make it visually more appealing.
As a presenter, I’ve learned...
2013-03-14
1,161 reads
SQL Server : Part 4 :Explaining the Non Clustered Index Structure
A table can have only one clustered index as the data rows are stored in the order of the clustered...
2013-03-14
30,638 reads
Logging into Azure and Office365 with Different Accounts
I have been doing some work on the Modern Apps Live! content that required me to use both an Office365...
2013-03-14
796 reads
Why you need Business Intelligence
First lets define what Business Intelligence (BI) is. My favorite definitions:
Forrester Research: “Business Intelligence is a set of methodologies, processes,...
2013-03-14
2,061 reads
Index Tuning
This week I've been carrying out some performance tuning of some of the more intensive procedures in one of our environments. Using...
2013-03-21 (first published: 2013-03-14)
3,636 reads
SQL Server under source control with Team Foundation Services and Red-Gate Source Control
During the last few years I’ve been involved in database source control management and release plans tasks. These are important...
2013-03-14
787 reads
PowerShell Usage in DBA Work — Case Study 3/7
As a DBA, sometimes we may need to demonstrate to some stakeholders when a sql server instance was last rebooted,...
2013-03-14
1,183 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