(Thomas LaRock) Everyone’s pegging quantum computing as the next big thing in enterprise technology. Quantum computing is becoming as overhyped as Blockchain, if such a thing is possible.
Tag: sql server
SQL SERVER – Simple Method to Generate Fixed Digit OTP Code Using Random Function
(Pinal Dave) One of my blog readers sent me the following mail after reading my earlier blog posts about Random Function and OTP Code. Before you read the email, you can read those blog posts here, here, and here.
I/O vs Logical I/O
(Kenneth Fisher) tl;dr; While the difference is very important 90% of the time you won’t care and should just add the two numbers together.
AzureCAT Guidance: Develop Azure Resource Manager templates for cloud consistency
(Ed Price) This topic of ARM template best practices (and getting started instructions) has a regular and consistent cloud scenario over the years. AzureCAT has written whitepapers on this.
Optimizing Type 2 Slowly Changing Dimensions in Integration Services – Part 2
(Koen Verbeeck) In the first part we introduced the reasoning behind type 2 slowly changing dimensions. We also discussed different implementation options in Integration Services (SSIS).
How to convert sys.master_files size column into GB
(Jack Vamvas) Question: I need to convert the sys.master_files size column into GB. Currently when I run select name,size from sys.master_files I get back the file size as KB. I’ve tried doing something – size/1024/1024 – but I’m getting incorrect results
4 strategies to beat the SQL Server 2008 support cutoff
(Robert Sheldon) The end of SQL Server 2008 extended support should spur database teams into action. Consider these four options to extend security or migrate your aging SQL Servers.
SQL SERVER – FIX: Error – The Job Failed. Unable to Determine If The Owner DomainUser of Job Job_Name Has Server Access
(Pinal Dave) I keep on breaking my lab environment and have learned many things from it. Here is one of the recent errors which I fixed. In this blog, we would learn how to fix error “The job failed. Unable to determine if the owner of job has server access.” While executing
Persisting job history in Azure SQL Managed Instance
(Jovan Popovic) Azure SQL Managed Instance is a fully managed SQL Server hosted in Azure cloud. Although it supports many SQL Server features, there are some constraints compared to SQL Server that you manage.
Creating Map Small Multiples In Power BI With The Azure Maps API
(Chris Webb) Since my post last week on using the Google Image Charts API to create sparklines and small multiples in Power BI has proved very popular, I thought I would do a follow-up showing how to use the Azure Maps API to create map small multiples.
