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,695 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,695 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,096 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
13,953 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,033 reads
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers