SQL Server 365

A Script A Day - Day 16 - Database Restore

• by Chris McGowan

• SQL Server 365

Today’s script is one I have used more times that I care to remember.  As a DBA database backups and...

2012-02-22

667 reads

A Script A Day - Day 15 - Untrusted Check Constraints

• by Chris McGowan

• SQL Server 365

Today’s script comes about because of a recent discussion about check constraints.  The discussion was about the use of WITH...

2012-02-22

1,014 reads

A Script A Day - Day 14 - Upgrading to SQL 2012

• by Chris McGowan

• SQL Server 365

Today’s script is one I have used to test one possible upgrade method from SQL Server 2008 to SQL Server...

2012-02-21

954 reads

A Script A Day - Day 13 - Chris' Top Tip - Batches

• by Chris McGowan

• SQL Server 365

Today’s post is pretty cool.  So you have been reading up about something on the World Wide Web or you...

2012-02-21

457 reads

A Script A Day - Day 12 - Granting Role Membership to All Principals

• by Chris McGowan

• SQL Server 365

Today's script will grant membership in the db_owner fixed database role in all online read/writable user databases to all principals not...

2012-02-20

888 reads

A Script A Day - Day 11 - User Permissions By Database

• by Chris McGowan

• SQL Server 365

Today's script will return you permissions granted to a user for every online database.  The script uses EXECUTE AS so...

2012-02-20

1,080 reads

Sorry...

• by Chris McGowan

• SQL Server 365

I've been offline for a week to take some annual leave and recharge my batteries.  To make up for the...

2012-02-20

459 reads

A Script A Day - Day 10 - Hosts on vCentre

• by Chris McGowan

• SQL Server 365

If you use VMWare for your virtualisation environment all virtual machines are managed by one or more vCentre management servers. ...

2012-02-10

693 reads

• Discuss

A Script A Day - Day 9 - Index Compression Estimations

• by Chris McGowan

• SQL Server 365

Today's script provides amongst other information Index compression estimates based on existing index information.  All you need to do is...

2012-02-09

1,296 reads

• Discuss

A Script A Day - Day 8 - Non Clustered Index Information

• by Chris McGowan

• SQL Server 365

Today's script comes to you from London where I am at my head office for my appraisal!  Lets hope it...

2012-02-08

439 reads

• Discuss