Author: nigelDBA

SQL Server Connection Problems – a Checklist

SQL Server Connection Problems – a Checklist

This Checklist came about after installing additional SQL Server Instances on existing Servers and finding that a bit of additional work was required before Users could access. It’s equally valid for default installations of SQL Server. Allow remote connections to this server This is the suggestion that most “helpful” users provide when they report that…

Read More Read More

I want to be a Snowflake DBA

I want to be a Snowflake DBA

  There’s a lot of talk at the moment about how Cloud services will rapidly replace “On Premises” SQL Server. Snowflake, one of the major players in the Data Warehouse space offers just this, with the promise of “no requirement for a DBA”. Surely a tempting proposal, but should this be a concern for us?…

Read More Read More

Multi-Server Scripting – Powershell, SQLCMD and Scripts that write Scripts

Multi-Server Scripting – Powershell, SQLCMD and Scripts that write Scripts

I received a request for help today from a friend (let’s call him “Dave”). Dave was looking for a better way to deploy projects across a large number of Databases spread over multiple Servers. My initial response suggested looking at scripting – either using SQLCMD or Powershell. Alternatively, there are tools such as Redgate’s “MultiScript”…

Read More Read More

SQL Server Configuration Manager

SQL Server Configuration Manager

A few thoughts on SQL Server Configuration Manager. As a DBA, I use it lot. Knowing a little more about it can be handy for others too. If you want to know what SQL Instances are installed on a Server, their Startup parameters and whether they are running at the moment, you can open SQL…

Read More Read More

Availability Groups – Making SQL Agent Jobs only run on Primary Replica

Availability Groups – Making SQL Agent Jobs only run on Primary Replica

I recently encountered some strange behaviour with SQLAgent Jobs in an Always On Availability Group. There’s a major difference between SQL Server Failover Cluster Instances (FCI) and SQL Server Availability Groups that makes it a little bit more complicated with SQLAgent Jobs. Put simply, with a Failover Cluster, there is only one “SQL Server” involved.…

Read More Read More

T-SQL Tuesday #105: Brick Walls

T-SQL Tuesday #105: Brick Walls

T-SQL Tuesday was started some time ago by Adam Machanic whereby lots of people blog their thoughts on a common topic. Month #105 is hosted by Wayne Sheffield with the topic of “Brick Walls”, Wayne is encouraging people to talk about when they have reached a “Brick Wall” on a project and how they worked…

Read More Read More

SQL Server Snapshots – Use Cases and Problems

SQL Server Snapshots – Use Cases and Problems

It about eight years since I last used Database Snapshots. Through no real fault of their own, we haven’t been friends for a long time.   As with most things, Database Snapshots are great in moderation. We had valid use-cases. Users were looking for a Static point to use for Month End reporting. On a…

Read More Read More

Cost saving with SQL Server – Right Sizing

Cost saving with SQL Server – Right Sizing

Last night a DBA saved my… Budget. I saved more than my annual salary in SQL Server Licensing costs last year. That sounded like a pretty cool line to get on my resume, and it’s something that lots of us have the opportunity to work towards. SQL Server licensing is expensive, yet SQL Server can…

Read More Read More

Follow on Feedly

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close