News Articles Databases News

SQL server Linux and SQLCMD from Blog Posts – SQLServerCentral

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]. […]

Azure Platform Series: cloudshell code -your (brilliant) online editor from Blog Posts – SQLServerCentral

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 […]

Bash: ^^}: bad substitution – upgrade your bash version from Blog Posts – SQLServerCentral

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 […]

Azure Platform Series “You have exceeded the maximum amount of scale changes within the past hour” from Blog Posts – SQLServerCentral

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 […]

Bash: “command not found” in IF statement from Blog Posts – SQLServerCentral

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 […]

The First Data Saturday is Tomorrow from Blog Posts – SQLServerCentral

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 […]

Daily Coping 22 Jan 2021 from Blog Posts – SQLServerCentral

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 […]

Daily Coping 21 Jan 2021 from Blog Posts – SQLServerCentral

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 […]

It’s 2021, so why are you reading this? from Blog Posts – SQLServerCentral

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-> […]

Daily Coping 20 Jan 2021 from Blog Posts – SQLServerCentral

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 […]

[Coping] Hidden Wounds from Blog Posts – SQLServerCentral

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 […]

Logical crossroads in Azure Data Factory (IF and Filter operations) from Blog Posts – SQLServerCentral

(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 […]

Storage Tiers What SQL Server DBAs Need to Know from Blog Posts – SQLServerCentral

“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 […]

Synapse Analytics and .NET for Apache Spark Example 3 – CTE() from Blog Posts – SQLServerCentral

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, […]

What is the CONTROL permission? from Blog Posts – SQLServerCentral

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 […]

Daily Coping 19 Jan 2021 from Blog Posts – SQLServerCentral

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 […]

Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 1) from Blog Posts – SQLServerCentral

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… […]

Azure SQL vCore vs DTU from Blog Posts – SQLServerCentral

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

Senior Software Developer

Creator of @LzoMedia I am a backend software developer based in London who likes beautiful code and has an adherence to standards & love's open-source.