PASS Business Analytics Conference: the ultimate networking
I went to the PASS Business Analytics Conference last week, and had an absolute blast. I presented two sessions, and...
2013-04-18
1,186 reads
Blog Posts
Run DBCC CHECKDB on a regular basis
Problem One common task as DBA is to run DBCC CHECKDB on a regular basis to detect and correct potential corruption...
2013-04-18 (first published: 2013-04-10)
11,893 reads
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,094 reads
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
978 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
591 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
709 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
574 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,603 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers