Do you know how to provide high availability protection for SQL Server without upgrading to Enterprise Edition? Learn how to get robust data protection features for a fraction of the cost of SQL Enterprise Edition with AlwaysOn Availability Groups.
You can say "migrations and upgrades" to a database administrator (DBA) or systems administrator, but what they usually hear is "risk and downtime". This e-book shows you how to simplify the migration and upgrade process so you can avoid the risks.
This tutorial is intended to help experienced T-SQL Developers, DBAs, Data Analysts and Data Science enthusiasts to start using Python language with T-SQL. This enables data science and analytics tasks closest to the actual data.
I recently had a task to move SQL Reporting Services to a new server. While researching I found two methods to accomplish this task. One used a scripting tool which I wrote an article about and the other method is the one recommended by Microsoft. This me
Some of our SQL Servers contain tables with summarized data (summarized on a weekly / monthly / quarterly basis). Previously this data was emailed as a flat file attachment to the recipients. I was asked to convert this in such a way that the email itself
When Availability Groups were introduced in SQL Server 2012, they were only available in Enterprise Edition. This made it challenging to move from Database Mirroring to Availability Groups, especially if you’re running Standard Edition.