We all have these days as a DBA, hopefully they are few and far between for most of us. This morning I walked into the office and found a stack of emails saying that a developer had responded to a support ticket and modified the values in one of our tables and got it wrong. OK, […]
2019-10-29
8,639 reads
Learn about the factors that should be taken into account if you are considering hosting SAP HANA in a public cloud.
2019-10-29
Phil Factor starts with the basics how to rebuild a set of development database from scratch, using SQL Change Automation, and then demonstrates how to check for any active sessions before rebuilding, import test data using BCP, and secure passwords if connecting to the target with SQL Server credentials.
2019-10-29
2019-10-28
4,800 reads
DevOps might sound intimidating if your organisation has not yet begun on its DevOps journey. In this article, Rahul Varshneya explains some of the benefits and reviews the stages all DevOps organisations go through to achieve it.
2019-10-28
Phil Factor demonstrates how using XML argfiles to pass parameters to SQL Compare cuts out a lot of the tedious scripting involved in modifying a database schema comparison and deployment process, as required for each target database.
2019-10-28
We'll look at using principal components analysis to help visualise your data and detect underlying structure or patterns.
2019-10-25 (first published: 2017-09-12)
4,384 reads
Organizations are looking for help with their DevOps implementation, including Redgate tools, knowing where they want to go with their production and deployment but not sure where to start. Clear Measure have designed a 30-point DevOps Inspection & Report to provide you with the feedback and guidance you need to take your software development and deployment to another level. Request your inspection now.
2019-10-25
In this tip we look at a PowerShell script you can use to gather information about all SQL Server Agent jobs on all SQL Server instances in your environment for quick reporting and analysis.
2019-10-25
Recently I went to work on a SQL Server 2017 instance and couldn't get the Python runtime to load. I'd keep getting this error: A strange error for me to see, and one that didn't quite make sense. How can the runtime not launch? However, restarting the instance still resulted in this error: Msg 39021, […]
2019-10-24
1,214 reads
By Steve Jones
This week we released SQL Prompt 10, which is an exciting milestone for us....
By Devin-Knight
Check out this new series that I’ve started on Power Platform Quick Tips. This...
Over the years I’ve seen quite a few strange things with SQL Server. This...
Comments posted to this topic are about the item Numeric and Decimal, which is...
https takeapills com/gravity-theory-cream/ Gravity Theory Cream
Ask SSC