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,669 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,096 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
976 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
949 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,889 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,875 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
13,812 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,763 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,404 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,032 reads
Blogs
SQL Prompt Quick Access to Helper Code
By Steve Jones
We’ve been doing some events as part of the Redgate Roadshow, and at one...
Eleven chapters of my data architecture book are available
By James Serra
As I have mentioned in prior blog posts, I have been writing a data...
Speaking at SQL Saturday Boston 2023
By alevyinroc
I’m happy to announce that I will be speaking at SQL Saturday Boston on...
Forums
Database recovery
Hi, My .mdf file is accidentally deleted at client's place and without bothering the...
Works on all other sql2022 servers but not on production. - must be dropped
HI We have a small utility that is giving us a "#table is missing...
Convert common Separated number to # table
@reportParameter 1008,1009,1011,1014 values need to insert to #Table Note: @reportParameter is not returning values...
Ask SSC