The SQL Server SMO client API can be used query and alter settings and objects within your SQL Server instances, however in case you want to query your user database, you will run into some limitations. The client API simply isn’t aware of your data objects and therefore not exposing a typed scheme. Fortunately, it’s pretty easy to accomplish when using the SQL Server PowerShell Module (SQLPS)
Was running into the following error while installing JIRA: “Network error IOException: Connection refused”. It seems that the SQL Server Express installer doesn’t enable the TCP/IP protocol by default.
I was addressing performance issues onsite just a couple of weeks ago and while waiting for the right authorizations, access tokens and whatever you need nowadays to just run some scripts…, one of the developers approached me and asked for some insights on how to Scripting SQL Server installations.
Ever executed a script on the wrong environment? Neither do I… but for those who do need a visual queue as to which server you are on, I’ve included some helpful steps below:
Recently, I worked on a project which involved auditing a dozen of SQL server instances. A process I usually script upfront however, due to constraints on my time and some local challenges (a very “opinionated” customer) wasn’t able to do so. Fortunately I discovered this somewhat unknown “Group Server Queries” option a while ago, so gave it a try and was pleasantly surprised.
SQL server’s recovery model is crucial for designing a backup and restore strategy. However, it can be a bit of a management chore when dealing with Development server.
If you don’t want to be bothered to look at databases where the log file is 100 times larger than the data files then the following might come in handy:
On-site performance tuning analysis can be as rewarding as it is frustrating. There are some aspects you just can’t control; Ranting managers or dealing with a passive DBA, which often stands behind you with popcorn and drinks. Fortunately, you can prepare your scripts in advance based as i did based on prior leanings.
Recent Comments