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
Blog Posts
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
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
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
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
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
Adding a Linked Server with ‘Oracle Provider for OLE DB’ as the provider – Proceed with caution !
Adding a linked server is an easy task which can be done at any point of time. I was under...
2013-03-13
2,939 reads
Atlanta MDF Presents Five Pre-Cons to choose from in Atlanta Friday, May 17
SQL Saturday is returning to Atlanta on May 18th at Georgia State University – Alpharetta, 3775 Brookside Pkwy, Alpharetta, GA 30022
The...
2013-03-13
198 reads
Atlanta MDF Presents Five Pre-Cons to choose from in Atlanta Friday, May 17
SQL Saturday is returning to Atlanta on May 18th at Georgia State University – Alpharetta, 3775 Brookside Pkwy, Alpharetta, GA 30022 The day before the event Atlanta MDF is...
2013-03-13
21 reads
Cleaning orphaned SIDs after a SQL Server VM template deployment
A few weeks ago (or longer, I’m behind on email again) Nate Palm (LinkedIn) messaged me after the most recent...
2013-03-13 (first published: 2013-03-11)
1,674 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
Alamat BCA KCP Metro Tanah Abang Telp:0821°7555°651
Hub Cs 08217555651 Pusat Grosir Metro Tanah Abang 2 Lt. 7. 10, Jl. K.H....
BCA KCU MENARA BCA Telp/Wa:08218200203
Hub Cs 08218200203 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1 Lt. 28, RT.1/RW.5,...
Alamat BCA KCP Raden Saleh Telp/Wa:08218200233
Hub Cs 08218200233 Jl. Raden Saleh Raya No.17A No. 13, 15, RT.1/RW.2, Kenari, Kec....
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