I can connect to my instance locally but not remotely
Every now and again (today for example) I’ll get a call that one of our SQL Server instances is down. ...
2012-10-23
1,258 reads
SQLStudies
fn_OBJECT_TYPE
I recently started using OBJECT_NAME, OBJECT_SCHEMA_NAME and OBJECT_ID functions; unfortunately I really could have used OBJECT_TYPE but it doesn’t exist...
2012-10-19
1,236 reads
A review of SQL Interoperability / Joes 2 Pros Volume 5 by Rick A Morelan
I recently passed my MCTS 2008 Development (70-433). Yay me! That made my 3rd 2008 certification. This one was probably the...
2012-10-15
1,846 reads
Multiple CTEs
Multiple CTEs
It’s somewhat obscure in BOL and I wasn’t able to find any examples but it turns out you can...
2012-10-11 (first published: 2012-10-09)
4,563 reads
Active flag on the TCP/IP Properties page of SQL Server Configuration Manager
I’ve been unable to connect to a server via one of its aliases for about a week. When I looked...
2012-10-05
1,972 reads
When I get stumped I ….
I work with a reasonably large team of DBAs. There are 9 of us and we support not only 70+...
2012-10-02
1,199 reads
DBMail on a cluster
I’ve always found clusters a pain in the neck. For my latest pain I just spent the last 2 days...
2012-09-26
628 reads
Using a TVP instead of Dynamic SQL to pass a list into a SP
A couple of days ago I read Steve Jones’ blog on creating a user defined table type. This reminded me...
2012-09-25
1,177 reads
Funny results from OPTIMIZE FOR AD HOC WORKLOADS
I recently turned on OPTIMIZE FOR AD HOC WORKLOADS for the first time on one of my servers. When I...
2012-09-18
1,356 reads
EXECUTE AS USER = ‘Somebody else’
As a database administrator I get lots of security requests. “Please grant me read authority on this table, write on that table,...
2012-09-10
730 reads
Blogs
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Connect resiliently to SQL Server
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
Forums
Some query values change when query is run but not others. Why?
Hi everyone I have a 1000 line SQL query that is too long to...
using different credentials when debugging ssis
hi, now and then i want one connection in my ssis pkgs to use...
AlwaysON health check alerts
Comments posted to this topic are about the item AlwaysON health check alerts