Introduction In my last blog post, I have addressed an issue with DAX Median function consuming a lot of memory. To refresh the result, below is the performance summary...
2020-12-10 (first published: 2020-12-01)
228 reads
I have held various certifications through my DBA career, from CompTIA A+ certification back when I worked help desk (I'm old) through the various MCxx that Microsoft has offered...
2020-12-10 (first published: 2020-12-01)
667 reads
This week we are going to launch a blog series geared towards folks that are new to PowerShell. The growing popularity of automation is seeing people getting started with...
2020-12-09 (first published: 2020-11-24)
435 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-12-09
17 reads
In this exercise we will see the implementation of Windows Active Directory integration to Microsoft SQL Server on Linux environment. In this example Centos1 is(more...)
2020-12-09
6 reads
This is one of them little options that I see which quite often gets little consideration or gets set to a user database without consideration of what the consequences...
2020-12-09 (first published: 2020-11-30)
394 reads
This is the seventh post in my retrospective attempt to answer every T-SQL Tuesday invitation. In the beginning of June 2010, Jorge Segarra invited us to write about our...
2020-12-09
36 reads
Many conferences have moved online this year due to the pandemic, and many attendees are expecting captions on videos (both live and recorded) to help them understand the content....
2020-12-08 (first published: 2020-11-24)
139 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-12-08
20 reads
This exercise demonstrates the installation and configuration of Microsoft SQL Server on Linux environment, this is a standalone deployment . Step 1 – Create “mssql”(more...)
2020-12-08
5 reads
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Comments posted to this topic are about the item Database security permissions save script
I have a SQL Agent job for backing up a set of Analysis Services...
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers