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,707 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,707 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,097 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,889 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,054 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,765 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,034 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers