I recently needed to ensure that a Power BI imported dataset would be refreshed after populating data in my data mart. I was already using Azure Data Factory to...
2020-07-21 (first published: 2020-07-09)
418 reads
One of the concepts in Snowflake that I find many struggle with is how constraints are handled. If you come from a traditional database platform such as Microsoft SQL...
2020-07-21 (first published: 2020-07-08)
621 reads
I’m at the just barely scratching the surface level of getting started with AWS Deployment Pipelines. Of course, the first thing I want to do with them is get...
2020-07-20
62 reads
If you have to manage or work with an Azure SQL database and want to know what service tier the database is currently operating, but you don't have access...
2020-07-20
3,825 reads
If you have to manage or work with an Azure SQL database and want to know what service tier the database is currently operating, but you don't have access...
2020-07-20
87 reads
In my first article in Azure Cosmos DB, we talked about What is Cosmos DB and How to provisions it, then in the Second article we talked about Partitioning Architecture in Azure Cosmos...
2020-07-20
11 reads
I’ve 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-07-20
9 reads
Defining primary keys is the hardest part of the operation. You will need to work very closely with the business in order to define exactly what column or columns...
2020-07-20 (first published: 2020-07-14)
342 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I needed to write this post because I...
2020-07-20 (first published: 2020-07-08)
212 reads
Nowadays, the big environments that have large databases with a heavy amount of transaction they had one common performance issue in the OLTP transaction when the database size increased...
2020-07-20
7 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...
I have a couple of SQL Agent job steps which run PowerShell commands of...
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...
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