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,732 reads
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,732 reads
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,100 reads
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
976 reads
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
950 reads
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,890 reads
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,875 reads
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,244 reads
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,768 reads
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,404 reads
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,035 reads
I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow...
By Steve Jones
I had a suggestion from somone on a place where AI helps them and...
Disclaimer: this post is not sponsored by Redgate 🙂 For those who’ve missed it,...
Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL...
Comments posted to this topic are about the item Does Version Control Scare You
Comments posted to this topic are about the item Unlimited Text
If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run?
See possible answers