Snowflake Data Cloud
Time to shift gears away from the world of relational databases whether that is in the cloud, on-prem, Linux-based, containers or even sitting within Kubernetes. Everyone has heard of...
2022-07-06
147 reads
Arun Sirpal
A New MVP Led Training Initiative – Cloud Formations
Hello Readers – I wanted to make sure those who follow my blog have heard about the new MVP led training initiative started by Paul Andrew (@mrpaulandrew). It’s called...
2022-07-04
16 reads
Azure CLI – Deleting Resources
Azure CLI is really handy for all sorts of tasks. When I build solutions, POCs and environments and I want to tear down the resources I like to use...
2022-06-16
31 reads
Azure Storage Replication Types
Storage Accounts are pretty much integrated into so many different designs in Azure, whether you are using Azure Synapse, 3rd party product like Snowflake, or Event Streaming designs –...
2022-06-15
54 reads
Azure VM Scale Sets
I really like scale sets. It lets you create and manage up to 1000 load balanced VMs per availability zone using windows or Linux images. (We can have flexible...
2022-06-09
16 reads
Azure VM Types
There are many different family groups for Azure VMs each with its own purpose. Below is a summary of what can be selected. This is important because for example...
2022-06-06
12 reads
Azure High Availability
Lets write about Microsoft Azure, specially the area of high availability when it comes to virtual machines. No doubt you will know about Azure Virtual Machines. IaaS approach is...
2022-05-31
13 reads
Azure SQL Managed Instance – Maintenance Windows
A post close to my heart, Azure SQL Managed Instance, I have blogged about this many times but I feel I should be sharing more details about this. One...
2022-05-12
148 reads
Azure Redis Cache and Geo-replication
The concept of a geo-replicated partnership between a primary and secondary node is very similar to that of something you may have seen with Azure SQL DB, where the...
2022-05-06
47 reads
Azure Redis Cache – Persistent Data
I mentioned before that you could use the idea of data persistency to rebuild your data from total failure. There are two types. RDB and AOF. RDB – persists...
2022-04-28
19 reads
Blogs
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find...
SQL Server 2022 Administration Inside Out
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
WIT/DEI Mental Health and Wellness Day Challenge to Present
Back in December 2019, I started presenting my session on mental health with lots...
Forums
Calculate log space required on principle for maintenance activity
Hi all, We have a database configured for asynchronous mirroring. We have some planned...
Get a Date Time Stamp of table when another columns value changes.
I have created a table as per below query CREATE TABLE [dbo].[mydbtemp]( [Datetime] [datetime]...
how to write a query by using some filter patterns in SQL Server?
what I want is to apply some filter patterns to search the data. For...
Ask SSC