Set DAC port with a specific number
Usually named instance can uses dynamic port, if firewall setup on the server, you can use SQL Server Configuration Manager...
2013-04-18 (first published: 2013-04-10)
5,095 reads
Blog Posts
SQL Saturday #175–Fargo
One of the goals early on with SQL Saturday was to spread them far and wide. Andy Warren and I...
2013-04-18
790 reads
Cool Tool – SQL Space Map
I came across a cool open source tool called “SQL Space Map“.
The tool, written by Ryan McCauley, presents a visual representation...
2013-04-17
896 reads
Cumulative Update – 12 for SQL Server 2008 R2 Service Pack 1 Is Now Available !
The 12th cumulative update release for SQL Server 2008 R2 Service Pack 1 is now available for download at the...
2013-04-17
979 reads
Featured on ITCentralStation this week
WOW! This week I was featured on the ITCentralStation.com home page as their Reviewer of the Week with my review of...
2013-04-17
592 reads
PowerSQL – Find and Replace string on multiple file of local or remote machine
Copy and Paste the below content in Set-FindandReplaceString.PS1. Please read the instructions carefully. Try to do a dry run on some...
2013-04-17
711 reads
SQL Saturday #211 Chicago Wrap Up
This past Saturday I had the pleasure of speaking at one of the largest SQL Saturdays I have ever attended...
2013-04-17
575 reads
SQL Server – Add Date/Time to output file of BCP / SQLCMD
You can export data from SQL Server using BCP command for SQLCMD utility. However, these utilities does not support dynamic...
2013-04-17 (first published: 2013-04-09)
3,605 reads
SQLSaturday#235 in NYC Announced!
{Start Circus bumper music here} LADIES and GENTLEMEN; SQL SERVER
PROFESSIONALS of ALL AGES, Come one, come all!
Get ready for a...
2013-04-17
1,239 reads
Connecting to SSIS 2008 Without Local Admin
The default install of SSIS only allows users with local admin rights on the server to connect. This can be...
2013-04-16
62 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