Listing SQL Instances on a machine (or list of machines)
TweetG’day,
Recently I was updating some of my Powershell scripts for managing SQL SERVER instances.
Generally, when writing a Powershell script to...
2012-04-17
5,749 reads
Marty
- Interests: Playing Guitar, Music Theory
- Website: http://martincatherall.com/
SQL Saturday 136 – Wellington. Speakers review.
TweetG’day,
On Saturday 16th April 2012, I attended SQL Saturday #136 in Wellington, New Zealand.
The day was run by Dave Curlewis [Blog...
2012-04-16
1,104 reads
Speaking at SQL Saturday #136 – Wellington, New Zealand
TweetG’day,
On Saturday 14th April I’ll be speaking at SQL Saturday 136 in Wellington, New Zealand.
My presentation is titled “Extended Events...
2012-04-12
983 reads
Database ownership
TweetG’day,
One of the features that I most like about management studio is the ability to generate a script of the...
2012-04-04
957 reads
Remote DAC connections
TweetG’day,
I wrote a post recently about setting the DAC port for an SQL instance.
I now do this as a matter...
2012-03-31
1,895 reads
Setting the DAC port….
TweetG’day,
I had a situation today where I needed to ensure that the dedicated Administrator connection (DAC) ran on a specific port.
The main...
2012-01-31
9,879 reads
Watch those VARCHAR(MAX) columns, and ONLINE index rebuilds
G’day,
I’ve noted a few instances lately of cases where VARCHAR(MAX) columns have been used unnecessarily, when a small value (for a...
2011-10-26
14,368 reads
sp_configure OR sys.configurations? and do you back these up?
G’day,
I was checking out some of our configuration options today using sys.configurations and I started to wonder how many people...
2011-10-20
6,774 reads
Dropping a database – such a simple thing!
G’day,
I think it’s a safe bet that everybody here has issued a DROP DATABASE statement and knows what to expect.
Well,...
2011-10-18
4,409 reads
Online index rebuilds
G’day,
I’m probably not the only one that has noticed that as the volume of data gets bigger in out databases,...
2011-09-28
1,039 reads
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers