Glenn’s Tech Insights For September 26, 2019
(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …
SQL SERVER – Unable to Start SQL Server Service or Connect After Incorrectly Setting Max Server Memory to a Low Value
One of my clients contacted me for whom I assisted incomplete installation of SQL Server along with health check and backup automation. Here is the email which came across about max server memory.Hi Pinal,Please help! This is urgent as SQL Server is do …
Getting Started with SQL Server on Google Cloud Platform
There are a number of providers for SQL Server in the cloud. Having multiple options brings along the complexity of having to decide which option works best for you. This means you get to play, test, and maybe even have a proof of concept with differen …
SQL Change Automation 4.0: Collaborative Database Development Across Visual Studio and SQL Server Management Studio
The post SQL Change Automation 4.0: Collaborative Database Development Across Visual Studio and SQL Server Management Studio appeared first on SQLServerCentral.
Why Attend 21 Essential Scripts: Performance Tuning for Everyone?
It has been the entire year since I am doing various road tour with my training – 21 Essential Scripts: Performance Tuning for Everyone. I have been presenting on this topic for about a year and now is the time that I put it to the rest. My final …
Sort Alphanumeric Values in SQL Server
The post Sort Alphanumeric Values in SQL Server appeared first on SQLServerCentral.
New: SQL Monitor 9.1 – control and refine the alerts for your growing estate
The post New: SQL Monitor 9.1 – control and refine the alerts for your growing estate appeared first on SQLServerCentral.
Building Machine Learning Models to Solve Practical Problems
Machine learning has been reshaping our lives for quite a while now. Be it the smallest thing such as unlocking your phone through Face Recognition to useful interactions with Siri, Alexa, Cortana, or Google using Speech Recognition, machine learning i …
High-End 4K AMD Gaming PC Build Guide
Continuing the series I started last week, I thought I would put together a build guide for a High-End 4K AMD Gaming PC. I am classifying a high-end gaming machine as costing above $1500.00 for the main components. You can easily spend significantly mo …
Updated First Responder Kit and Consultant Toolkit for September 2019
This month’s release has a lot of new feature goodness: the Consultant Toolkit can automatically upload the results to Amazon S3, plus sp_BlitzCache adds a new sort order to better catch unparameterized queries burning up CPU, a new warning for s …
SQL Server Management Studio is as Relevant as Ever
After fifteen years of heavy usage by developers and DBAs, it might seem like Microsoft’s free tool, SQL Server Management Studio, is about to go out of style. SSMS is no longer the cool new kid on the block: Microsoft has shown consistent …
SQL SERVER – Script to Get Partition Info Using DMV
I consider myself very fortunate as I get to see a new system every other day when I am working with a Comprehensive Database Performance Health Check. During the consultation, one of the questions was is there any way to see the information about the …
Using PowerShell to Generate Logins, Server and Database Permissions
The post Using PowerShell to Generate Logins, Server and Database Permissions appeared first on SQLServerCentral.
Using tsqlt Tests to Practice Queries
Recently I was talking with someone that was wondering what the value was of writing unit tests. They were concerned that trying to write tests was a large effort and that they might not catch all bugs, so why write the test? It’s a common viewpoint th …
Redgate need users looking to do CI/CD for Oracle Databases
The post Redgate need users looking to do CI/CD for Oracle Databases appeared first on SQLServerCentral.