*1337 Tech alert: Azure, IaaS, IaC, SQL Server, AlwaysOn AG/FCI, Networking, Clustering, VPN Vnet2Vnet, S2D, SOFS, Load Balancers, Health Probes… Helloooo! Besides SQL Server 🙂 On of my current professional personal pet projects is around Azure, I always liked Infrastructure/ networking related stuff; actually I was a SysAdmin back in 2004 managing stuff from DCs to Exchange,
Hello! With the release of Windows Server 2016 and the “great/awesome/fabulous feature” storage spaces direct(S2D) that has the concept of leveraging local storage to build a “virtual-san”, with different storage type from SAS/SSD/NVMe to generate different storage tiers/caching that can be both applicable on the cloud and on premises, this is game changer for SQL,
Hello, Hope everything is running great! It is not that uncommon, that large/complex database environments might have an overlapp of maintenance commands being executed, being one of the classics the one bellow: Tipically DBA’s design their maintenance processes (that might include Integrity Checks/ Index Rebuilds/Reorgs/ Update Stats) to run on a daily basis under a
Hello again! 3 conditions need to be true for me to write something, 1st is having a little bit of spare time,the 2nd is to write about something that nobody hasn’t really blogged about (my search skillz might not be that 1337) and inspire at least one person to learn something new and stimulate curiosity. Moving forward to
Hello! As a frequent flyer I like to sleep on the airplane but since sleep is overrated and I’m in a long term relationship with Data Platforms 🙂 , I decided to write about one of the projects that I’m working on. Can’t disclosure all the details about it (NDA kicking in…), but I can
Build a professional snapshot of experience with PowerBI, why not, why wouldn’t you use 2 presentation layers, a snapshot and a more detailed document with all the bytes ?
Change NUMA-Node Processor Affinity is an online operation that can be done without causing downtime but I have experienced that it can lead to bring an instance offline if the resource monitor takes long time to free memory and keeps generating Mini-Dumps, at #51 it will bring the instance offline. Started to have Non yielding
First of all, whenever issues arise from patching your SQL Server production environment, please keep calm 🙂 In a scenario, that you successfully patched SQL Server (Service Pack/ CU) but the SQL Server Resource Group can’t be brought online, I recommend to start your PowerShell console and generate your Cluster Log (simply by Get-ClusterLog), this will
Hello world 🙂 To sum up, i was working with one of my customers regarding the UI (User Interface) freezing while restoring (Symantec NetBackup) a database into SQL Server 2012, leading to a unresponsive behavior from the server. Scenario (VMware guest – WS2012R2): Started with gathering performance counters to jump into the analysis and even though
If you are interested on a solution that provides elastic scale, High Availability and Disaster Recovery between different locations with a “pay as you go approach”, I suggest you to invest 2 minutes of your time to take a look of this session!