Microsoft SQL Server 2022 Updates / Release Candidate (RC 1) Evaluation Edition (16.0.950.9)
Posted by Barac in Updates on Oct 5th, 2022 | 0 comments
SQL SERVER 2022 Update Version: MSSQL 2022 Release Candidate (RC1) Evaluation Edition, Build: 16.0.950.9, Release Date: September 2022, Download: https://learn.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2022?view=sql-server-ver16#release-candidate; ...
SQL Server / PowerShell / Check SQL Server version and a current patch level for all servers you specify using PowerShell
Posted by Barac in Azure, Powershell, SQL Server on Apr 24th, 2022 | 0 comments
Script Download: SQLServerUpdateStatus Download Summary: Check SQL Server Version and the current patch level for all servers you specified. As well check the latest patches/updates available for the installed SQL Server version and send an email with results. Description: SQL Server Instance Update Status PowerShell script which can be invoked remotely from another PC through the command line, with PowerShell or executed remotely through task scheduler adding servers names. The script is checking server registry values for (Version,...
SQL Server / Remove SCHEMABINDING from the multiple VIEWs without DROP and CREATE statements
Posted by Barac in SQL Server, SQL Tips and Tricks on Mar 12th, 2022 | 0 comments
What is the SCHEMABINDING within VIEW?It simple binds the view to the schema of the underlying objects. Tables behind the View cannot be altered in any way which could affect view definition. You can find more at this MS article: ALTER VIEW (Transact-SQL) There is a easy way to remove SCHEMABINDING, you just need ALTER VIEW statement. But what if you have 100 views that needs to be altered? Well there are no SWITCH OFF button for SCHEMABINDING in SQL Server. I had same situation and I wrote this simple script which will generate ALTER VIEW...
#DataWeekender CU5 / Virtual Event / 14th of May 2022
Posted by Barac in SQL Server on Jan 27th, 2022 | 0 comments
VIRTUAL EVENT #DataWeekender is a new online conference that first ran on Saturday 2nd May 2020. Our original intention was to put on an online data platform conference for the community to fill that void left by the cancelling of the in-person events due to Covid-19. We are delighted to announce our 5th running on the 14th of May 2022. Expect to see more super sessions from a range of new to seasoned speakers on a range of data topics. Topics like PowerBI, Data engine, Azure, Data Factory, performance tuning, dev ops, NoSQL, Logic...
SQL Server / Configure an Azure Load Balancer for a SQL Server Always On AG in Azure Virtual Machines / Possible Floating IP and Health Probes Connectivity and Networking issues
Posted by Barac in SQL Monitoring, SQL Server, SQL Tips and Tricks on Jan 21st, 2022 | 3 comments
I will take you through the steps on how to properly configure Azure Load Balancer with Azure SQL Server VMs (IaaS), Windows Failover Cluster (WFC), Availability Group AG, and listener endpoint. The following link shows us what is the best Microsoft Practice, and how Microsoft suggests we should configure an Internal Load Balancer (ILB) for the Availability Group Listener. Create & configure the load balancer How LB really works with Always On Availability Group on SQL Server on Azure VMs? There are two types of Load Balancers –...
Azure SQL PaaS / Platform as a Service Azure SQL redundancy options / Local, Zone and GEO redundant availability
Posted by Barac in SQL Server on Dec 11th, 2021 | 0 comments
This video covers the zone redundancy options available with Azure SQL. You’ll learn about zone redundancy for each service tier including Hyperscale. Agenda: Redundancy options Standard availability model Basic, Standard, and General Purpose service tier locally redundant availability General Purpose service tier zone redundant availability Premium availability model Premium and Business Critical service tier locally redundant availability Premium and Business Critical service tier zone redundant availability GEO redundant availability...
#DataWeekender v4.2 / Virtual Event / 6th of November 2021
Posted by Barac in SQL Server on Oct 23rd, 2021 | 0 comments
VIRTUAL EVENT #DataWeekender is a new online conference that first ran on Saturday 2nd May 2020. Our original intention was to put on an online data platform conference for the community to fill that void left by the cancelling of the in-person events due to Covid-19. We are delighted to announce our 4th running on the 6th of November 2021. Expect to see more super sessions from a range of new to seasoned speakers on a range of data topics. Topics like PowerBI, Data engine, Azure, Data Factory, performance tuning, dev ops, NoSQL,...
DATA SATURDAY #13 MINNESOTA / Virtual Event / One-day free virtual event
Posted by Barac in Azure, DATASATURDAY, SQL Server, SQLSATURDAY on Oct 12th, 2021 | 0 comments
WHAT IS DATA SATURDAY #13 – MINNESOTA Free virtual event for all data learners and professionals seeking to learn! Data Saturday Minnesota is training event for professionals who use the Microsoft data platform. Community speakers will offer sessions about cloud, analytics, database administration, business intelligence, AI and more. Don’t miss out on this FREE event!!! Sessions: Schedule Date and Location: Central Daylight Time (US), Saturday, 16th October, 8am – 7pm NZ time, Sunday, 17th October 2021 and starts at 2am...
DIFINITY CONFERENCE 2022 / Auckland, New Zealand / The largest Data and AI conference in New Zealand
Posted by Barac in Azure, SQL Server on Sep 2nd, 2021 | 0 comments
WHAT IS DIFINITY CONFERENCE Microsoft AI, Data, and Power Platform Conference Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand focusing on Data Platform, AI, Business Intelligence, Business Applications, Power Platform, and Analytics. IT Decision Makers, Developers, Business Analysts, IT Professionals, BI Managers, BI Professionals, Database Administrators, Architects, Digital & Big Data business leaders, and Consultants will gather for two consecutive days of...
#DataWeekender v3.1 / Virtual Event / 15th of May 2021
Posted by Barac in SQL Server on May 7th, 2021 | 2 comments
VIRTUAL EVENT #DataWeekender is a new online conference that first ran on Saturday 2nd May 2020. Our original intention was to put on an online data platform conference for the community to fill that void left by the cancelling of the in-person events due to Covid-19. We are delighted to announce our 3rd running on the 15th of May. Expect to see more super sessions from a range of new to seasoned speakers on a range of data topics. Topics like PowerBI, Data engine, Azure, Data Factory, performance tuning, dev ops, NoSQL, Logic Apps,...
About Me
My name is Zoran, currently living in Auckland, New Zealand. I am a data specialist with more than 15 years of hands-on experience in database administration and optimisation. I am also, Certified Microsoft Trainer (MCT) and Microsoft Certified Solutions Expert (MCSE) with a Master‘s degree in Information Technology. Sharing knowledge and contributing to the SQL Server community is my passion. I am also an organiser of the Auckland SQL User Meetup Group. As well I am active blogger and speaker at different SQL events such as SQL Saturdays, Meetups etc.
read moreAuckland SQL Group
MSDN PROFILE
SQL SERVER UPDATES
- Microsoft SQL Server 2022 Updates / Release Candidate (RC 1) Evaluation Edition (16.0.950.9)
- Microsoft SQL Server 2019 Updates / BETA (15.0.1000.34) / RTM (15.0.2000.5)
- Microsoft SQL Server 2017 Updates / RTM (14.0.1000.169)
- Microsoft SQL Server 2016 Updates / RTM (13.0.1601.5) / SP1 (13.0.4001.0 or 13.1.4001.0) / SP2 (13.0.5026.0 or 13.2.5026.0) / SP3 (13.0.6300.2 or 13.3.6300.2)
- Microsoft SQL Server 2014 Updates / RTM (12.0.2000.0) / SP1 (12.0.4100.1 or 12.1.4100.1) / SP2 (12.0.5000.0 or 12.2.5000.0) / SP3 (12.0.6024.0 or 12.3.6024.0)
- Microsoft SQL Server 2012 Updates / RTM (11.00.2100) / SP1 (11.0.3000.0 or 11.1.3000.0) / SP2 (11.0.5058.0 or 11.2.5058.0) / SP3 (11.0.6020.0 or 11.3.6020.0) / SP4 (11.0.7001.0 or 11.4.7001.0)