Following on from a previous blog post (https://blobeater.blog/2021/01/15/sql-server-linux/) on installing SQL Linux, a common requirement will be the need to connect to it to issue queries, typically via SQLCMD). There isn’t too much to it but still an important step. … Continue reading ?[1] The post SQL server Linux and SQLCMD[2] appeared first on SQLServerCentral[3]. […]
This post is about code which is an online editor you can use with cloudshell. I live in the Azure platform all day (almost) every day. What this means is I need to be able to run scripts from just about any device – there are times where I will be scaling a Hyperscale database […]
This blog post is about a situation where you are capitalising an argument in bash and you get the following error: bash: ${state^^}: bad substitution In this example I was capitalising a variable called state to STATE. After some quick googling I found that the reason I am getting this error is not because of […]
This blog post relates to where you might be doing scale operations of your app services or VMs in Azure and get the following error after doing quite a few scale up and down operations. The exact error I received was: Failed to update configuration for ‘Api’. {“Code”:”Conflict”,”Message”:”You have exceeded the maximum amount of scale […]
This blog post is about a situation where writing an IF THEN ELSE statement with variables fails with something like ./scalePREPROD.sh: line 26: [[1: command not found This was in a script called scalePREPROD that scaled app services if they were not a certain value – so I am checking to see IF they are […]
Data Saturday #2 – Guatemala[1] is tomorrow. This is the first event on the calendar, though the second one to move from SQL Saturday over. I’m thrilled that this is taking place and that there are presentations in both English and Spanish. I hope sometime to actually attend a live event like this, and see […]
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle[1], which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag[2]. Today’s tip is to take a different route when you next […]
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle[1], which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag[2]. Today’s tip is to connect with someone near you – share […]
If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking. There’s also a high likelihood that you live in the United States. The technology industry seems to be thick with this stereotype, but as I mentioned in a series of posts about gatekeeping, if we only listen to (or read) white-> […]
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle[1], which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag[2]. Today’s tip is to switch off your tech 2 hours before […]
Through high school and college, I carried deep wounds due to what was going on at home. Only a handful of people outside of my family knew what what was happening. I didn’t want to share what was occurring for a number of reasons: thinking about it brought more pain, it was deeply embarrassing, and […]
(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach a crossroad with a large stone that had some directions written on it – turn right and you will lose your horse, turn left and you will lose your life, walk straight and you will find your happiness. Also, growing up […]
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server and storage performance. No matter how many gerbils power your storage, you need to know what type they are and the power that they provide. Storage is not about gerbils it is about IOPs, bandwidth, latency, and tiers. As a DBA […]
The next example is how to do a CTE (Common Table Expression). When creating the CTE I will also rename one of the columns from “dataType” to “x”. T-SQL WITH CTE(x, dataType, dataSubType) AS ( SELECT dateTime, dataType, dataSubType FROM chicago.safety_data ) SELECT * FROM CTE; Spark SQL WITH CTE AS (SELECT dateTime as x, […]
One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL[1]: CONTROL: Confers ownership-like capabilities on the grantee. https://docs.microsoft.com/en-us/sql/relational-databases/security/permissions-database-engine?view=sql-server-ver15#_conventions[2] Ownership-like. So not quite ownership. In essence if you have the control permission you have every stated permission to the object. This includes the ability to grant permissions […]
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle[1], which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag[2]. Today’s tip is to get moving. Do something physically active (ideally […]
Welcome to a new year, and a new look at what I’ve learned in my time as a beginner and junior DBA. So, I’ve been in this DBA gig for just over 1.5 years, and it’s been quite a fun and interesting ride. Many readers have read my Ironic DBA Files posts where I regularly… […]
If you are building database solutions in Azure , using Azure SQL Database then you will know that you have a purchasing option decision to make. That being should you use a vCore model or DTU approach? Whilst I am … Continue reading ?[1] The post Azure SQL vCore vs DTU[2] appeared first on SQLServerCentral[3]. […]
Sitemap | Terms | Privacy | Cookies | Advertising