The Complete Weekly Roundup of SQL Server News

Hand-picked content to sharpen your professional edge

At a keynote this week (video, transcript), Tim Cook, CEO of Apple, outlined some of the issues that we face in this world where technology is being used to gather, hoard, sell, and use tremendous amounts of data. He used the term data industrial complex, a take off of the military industrial complex that has industry working closely with government in a way that might make some of us uncomfortable. Or may align interests that benefit the few over the many.

I know that Apple has been on both sides of this debate in recent years. If you get all your data, you might be surprised. There have been concerns about tracking, about the storage of messages, even after phones are wiped, and other issues. At the same time, Apple has provided tools and protection that have stymied law enforcement and upset governments with their encryption.

This isn't to defend or laud Apple in any way, but rather to note that privacy issues around data are complex and of a concern. I like the general topics that Mr. Cook outlines, and I do think that we have lots of work to do in these areas, both as private organizations and with public laws and frameworks that outline rights and responsibilities, while still allowing innovation and creative use of data.

That is a hard balance to strike, and I really don't quite know how I want my data used and protected. At times I want to prevent the use of data for purposes I haven't agreed to, but at other times I appreciate the creative and helpful use of information about my life. I'm not even consistent about the ways in which I treat my own data at times, which reminds me of the complexity in dealing with sensitive data about individuals.

The GDPR, which took effect this year, and similar laws (CCPA, AUS Privacy Act, etc.), are a good move forward, in my opinion. They might go too far in some ways, or be too lax in others, but we need to start the discussion and examine the effects of some concrete rules in the real world. My hope is that we have a regular and constant debate on how we should treat data in an increasingly connected world that gathers larger volumes and more types of data than ever before in our history.

Steve Jones from SQLServerCentral.com

» Join the debate, and respond to today's editorial on the forums

All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit. These headlines are gathered throughout the week and are posted in real time at the website. Check there for information throughout the week or enjoy this weekly summary of the SQL Server world.

Webinars

SQL in the City Streamed December 2018 - The theme for December 2018's SQL in the City Streamed is Your Journey to Compliant Database DevOps. The schedule includes sessions designed to broaden your skillset, support your ongoing learning, and keep you up-to-date with what’s new in the industry and at Redgate....(more)

Enable Business Agility Through Database DevOps - Founder and Chief Technologist at Nebbia Technology, Esteban Garcia, joins Redgate to discuss how DevOps helps technology teams to go faster and automate everything. As teams lower the cycle time between idea and production, how can organizations leverage these new capabilities to improve product delivery and quality?...(more)

The Importance of Provisioning in Compliant Database DevOps - Compliance shouldn’t mean that you are forced to slow down your development process or compromise the quality of your work. In this webinar we will highlight the importance of provisioning as a part of your Compliant Database DevOps story and how it can accelerate your delivery processes while remaining in line with relevant legislation....(more)

The single question to predict success for DevOps, and what it means for change control - In this 30 minute session, Microsoft MVP Kendra Little will share and discuss her three key insights from the 'Gene Kim joins Redgate to discuss The 2018 Accelerate State of DevOps Report' webinar, and show why these insights make a compelling argument for rethinking your organization's change control process....(more)

Vendors/3rd Party Products

SQL Clone V3: New features heighten visibility and manageability of clones and images. - With a brand new dashboard, activity feed and search functionality there is a lot happening in the SQL Clone v3 release. Check out the full breakdown of the update and get onto the latest version. ...(more)

SQL Prompt as a Layout Tool: A Survival Guide - Phil Factor's guide to taming SQL Prompt layout options, and getting it to format code just the way you like it....(more)

T-SQL

Passing Data table as Parameter to Stored Procedures - Real-world database applications need to make multiple requests from the front end to the database in order to carry out all sorts of functions. If an application is data-intensive, such as the ones used in banks or airports etc, the number of data trips ......(more)

Another Difference between N” and ” in SQL Server. - If it walks like a 'duck', talks like a 'duck', and looks like a 'duck'...careful! It could be a N'duck' ...(more)

SQL SERVER – How to DROP Multiple Tables Using Single DROP Statement? - In my earlier post, SQL SERVER – How to DELETE Multiple Table Together Via SQL Server Management Studio (SSMS)? I showed you how to DROP Statement multiple tables together using a wizard in SQL Server Management Studio (SSMS). Lots of developers are ......(more)

Unexpected Shorthand Date Implicit Conversions - I do my best work in the mornings.  Evenings are pretty good too once I get a second wind. Late afternoon are my nemesis for getting any serious technical or creative work done.  Usually I reserve that time for responding to emails, writing documentation, ......(more)

Contextual View Part II or how to hide sensitive data - In this article I continue to explore the ways to secure the data via contextual views and describe the technique of hiding the data in the logical layer utilizing business rules. Click here to read full article. ...(more)

Tools

Installing Azure Data Studio - Azure Data Studio is the newest tool from Microsoft for working on the data platform. Last year we saw the preview release of this, called SQL Operations Studio. No one liked the name, and as the tools team at Microsoft worked to update the tool, they ......(more)

The Lighter Side

Tesla pulled the “full self-driving” option—here’s what customers think - Enlarge / Tesla CEO Elon Musk. (credit: Yuriko Nakao/Bloomberg via Getty Images) Over the last two years, Tesla has been charging customers $3,000 to $5,000 for an upgrade called "full self-driving." "All you will need to do is get in and tell your ......(more)

The new 2019 Hyundai Kona EV is a clever little electric crossover - Hyundai LOS ANGELES—If you believe we'd be better off with more people driving electric vehicles, any increase in the variety of those EVs is a welcome event. The latest option for the would-be EV owner certainly hits most of the right notes to be a ......(more)

SQL Server Security

Invalid value given for parameter PASSWORD. Specify a valid parameter value. - I still use sp_help_revlogin to transfer logins between servers.  I know there are other options, including a set of Powershell commands contained in dbatools (#YouCanDoAnythingWithPowershell) but this is a case where the old method works so I don't ......(more)

Validating SMO security bugs with Pester - SQL Server Management Objects (SMO) are the .NET classes underpinning Management Studio and all good PowerShell that interfaces with SQL Server. It also exposes your SQL Server Authentication passwords in plain-text and doesn't support basic ADO.NET ......(more)

SQL Server News

Cumulative Update #12 for SQL Server 2017 RTM - The 12th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing ......(more)

String or Binary data would be truncated: replacing the infamous error 8152 - In the recent announcement at Ignite 2018 on the release of SQL Server 2019 CTP 2.0, the new Big Data Clusters, data virtualization, support for UTF-8, and Intelligent Query Processing were highlights. But we have also previewed work being done to address ......(more)

SQL Server 2019 CTP 2.0 New Features – Columnstore support for sp_estimate_data_compression_savings - Next up for new Storage Engine area features in SQL Server 2019 is an update to the sp_estimate_data_compression_savings stored procedure to add support for both columnstore and columnstore archive compression. This stored procedure has been around since ......(more)

Security news and thoughts

Recent Security Breaches Come at Great Cost--Including Jobs - A Kaspersky Lab report found that employees have been laid off in the wake of recent security breaches where data was stolen or compromised. ...(more)

Two new supply-chain attacks come to light in less than a week - Enlarge (credit: Brian Smithson / Flickr) Most of us don’t think twice about installing software or updates from a trusted developer. We scrutinize the source site carefully to make sure it’s legitimate, and then we let the code run on our computers ......(more)

Another Windows 0-day flaw has been published on Twitter - SandboxEscaper, a researcher who back in August tweeted out a Windows privilege escalation bug, has published another unpatched Windows flaw on Twitter. The new bug has some similarities to the previous bug. Windows services usually run with elevated ......(more)

R Language

Machine learning: Logistic regression and decision trees for healthcare in R - CategoriesAdvanced ModelingTagsDecision TreesLogistic RegressionMachine LearningOne of the sectors with the most demand for machine learning statistics is the healthcare sector and the life science industry. This sector has always been data-driven, looking ......(more)

Machine learning logistic regression for credit modelling in R - CategoriesRegression ModelsTagsLogistic RegressionROCMachine learning logistic regressions is a widely popular method to model credit modeling. There are excellent and efficient packages in R, that can perform these types of analysis. Typically you will ......(more)

Spread, Gather, Separate, and Unite variables and datasets in R - CategoriesIntroductionTagsData ManipulationtidyverseTips & TricksWith the use of tidyverse package is become easy to manage and create new datasets. Among many other useful functions that tidyverse has, such as mutate or summarise, other functions including ......(more)

Product Upgrades and Releases

How to See Execution Plans in Azure Data Studio - Azure Data Studio is Microsoft’s cross-platform tool for T-SQL developers. It’s still relatively young, so it has some missing areas of functionality. When you run DMV queries to look at query plans, they show up as XML, which isn’t very friendly. For ......(more)

Release: SQL Server Migration Assistant (SSMA) v7.11 - Overview SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access allows users to convert a database schema to a Microsoft SQL Server schema, upload the schema, and then migrate data to the target SQL ......(more)

Product Reviews and Articles

SQL Provision offers users an easier way to manage, organize and make available masked copies of databases - Over the past year Redgate has released some major improvements to SQL Provision, including the ability to modify images with Data Masker and SQL scripts, and create templates for clones, allowing users to specify SQL scripts to run after creation. Now ......(more)

This is a company that practises what they preach - How good is a company at engaging with their user base? Obviously when things are going great then it’s wins all around for the company and hopefully the people have invested their money in that company’s products… When things are not going well – I ......(more)

A Basic Technique for Masking Address Data using Data Masker - In my previous article, I showed how to use Data Masker to obfuscate credit card data, while ensuring that the masked data retained the characteristics and distribution of real credit card information. This 2-part article series is going to do the same ......(more)

PowerPivot/PowerQuery/PowerBI

Create a Power BI Slicer Panel - There is nothing worse than having a Power BI report that has 50% of the space taken up with slicers.  When this happens, you only get half the page to visualise the actual data.  But on the flip side, if you don’t have the slicers it can be harder for ......(more)

Fuzzy match / merging in Power BI Desktop (October 2018) - In this video, we look at the new fuzzy match / merging option within the October 2018 version of Power BI Desktop. This feature is incredibly powerful when it comes to data matching and can be adjusted to meet your needs. The post Fuzzy match / merging ......(more)

Microsoft R, Data Science and Power BI - In this video, we are joined by Buck Woody. Buck is a data scientist at Microsoft. We work together to show how you can easily visualize Microsoft R in Power BI. We use Microsoft R Open and then move onto Power BI Desktop. The example used in Microsoft ......(more)

Fuzzy Matching in Power BI and Power Query; Match based on Similarity Threshold - After a long wait, in the October 2018 release of Power BI Desktop we saw the fuzzy matching feature added finally. Yay! Have you ever wanted to match two tables together but not on exact matches, but also on a threshold of similarity? if your answer ......(more)

Web API Data Sources with Power Query and Scheduling Data Refresh in the Power BI Service - Using a Web API is a convenient way to expose and consume data over an Internet connection.  Exercising some essential design patterns, understanding and working with the Power Query Formula Firewall is essential if you need to consume Web API data with ......(more)

Performance Tuning SQL Server

Filtered Indexes vs Parameterization (Again) - At First I Was Like… This won’t work at all, because parameters are a known enemy of filtered indexes. But it turns out that some filtered indexes can be used for parameterized queries, whether they’re from stored procedures, dynamic SQL, or in databases ......(more)

Batch Mode For Row Store: Does It Fix Parameter Sniffing? - Snorting The Future SQL Server 2019 introduced batch mode over row store, which allows for batch mode processing to kick in on queries when the optimizer deems it cost effective to do so, and also to open up row store queries to the possibility of Adaptive ......(more)

Understanding Optimizer Timeout and how Complex queries can be Affected in SQL Server - What Is Optimizer Timeout? SQL Server uses a cost-based query optimizer. Therefore, it selects a query plan with the lowest cost after it has built and examined multiple query plans. One of the objectives of the SQL Server query optimizer (QO) is to ......(more)

Is Cost Threshold for Parallelism Measured in Seconds? - SQL Server automatically chooses when to divide your query’s work across multiple CPU cores. It makes that decision based on your query’s cost. To see it, let’s throw 1,000,000 tiny rows in a table:CREATE TABLE dbo.Timeless(ID INT IDENTITY(1,1) PRIMARY ......(more)

Why Did a Plan Get Removed From Cache? - I was recently asked if we could tell why a plan was removed from cache. If you read this blog, you know what I’m going to say next. I checked the extended events and there are actually two different events that will tell us information about a plan ......(more)

Baselines for SQL Server and Azure SQL Database - Last week I got an email from a community member who had read this older article of mine on baselining, and asked if there were any updates related to SQL Server 2016, SQL Server 2017, or vNext (SQL Server 2019). It was a really good question. I haven’t ......(more)

Microsoft News

Microsoft finalizes its $7.5 billion GitHub acquisition - Microsoft's acquisition of GitHub has passed regulatory approval and is now official. ...(more)

MDX/DAX

DAX – Cumulative Total and Blank Handling - When developing DAX measure, you should be aware that Blank value behavior might be similarly insidious as NULL value in DB. Sometimes it can surprise you as shown in the following example. You might have been asked to develop new DAX measure which would ......(more)

Optimizing IF and SWITCH expressions using variables - This article describes how variables should be used in DAX expressions involving IF and SWITCH statements in order to improve performance. In DAX, variables are useful to write more readable code. Variables are also useful to optimize code execution, ......(more)

Hardware News

New Intel Desktop Processor Families - Intel formally announced its 9th generation Core mainstream desktop processors on October 8, 2018 at its Fall Launch Event in New York. So far, they have announced three members of this family. The prices below are the MSRP prices. Actual street prices ......(more)

Dell Launches Three Rugged Latitude Laptops with up to 1000-nit Displays - Dell today introduced its new generation of ruggedized Latitude laptops designed to operate in rough locations. The new family consists of three base models that offer different levels of protection against extreme handling and environments. The new ......(more)

The Intel 9th Gen Review: Core i9-9900K, Core i7-9700K and Core i5-9600K Tested - Intel’s newest line of desktop processors bring with them a number of changes designed to sway favor with performance enthusiasts. These new parts bring Intel’s consumer processors up to eight cores, with higher frequencies, better thermal connectivity, ......(more)

Samsung Shows Off 256 GB DDR4 RDIMM: Coming to Servers Soon - Samsung this week demonstrated its first 256 GB memory module for upcoming servers. The new Registered DIMM (RDIMM) is based on Samsung’s 16 Gb DDR4 memory devices introduced earlier this year and takes advantage of the company’s 3DS (three-dimensional ......(more)

HA/DR/Always On/Clustering

SQL SERVER – Always On Availability Groups and Full-Text Index - One of the most successful offerings from me has been Comprehensive Database Performance Health Check. Sometimes during my assistance, some random issues appear which I try to solve as well. In a recent engagement, one of their developers asked a question ......(more)

ETL/SSIS/ELT

Five Ways Data Engineers Are Leveraging Self-Service Data Prep Solutions - Click to learn more about author Farnaz Erfan. With the growth of Big Data Analytics, data engineers are now gaining a lot of popularity.  And, while the majority of them have coding and technical skills, ETL knowledge, or can program in MapReduce, many ......(more)

“Do I Need a Biml Framework, Andy?” - No. No, you do not need a Biml Framework. In the same way that I do not need a vehicle powered by an internal combustion engine, you do not need a Biml framework. You see, I live about 5 miles from Farmville Virginia. I could walk to town each time my ......(more)

Data Privacy, Complianace, and GDPR

CCPA Recent Updates: What You Need To Know - Click to learn more about author Matt Dumiak. It should come as no surprise to anyone that the California State Legislature has passed, and the California Governor has signed, amendments to the California Consumer Privacy Act (CCPA). Having previously ......(more)

Tim Cook calls for strong US privacy law, rips “data-industrial complex” - Enlarge / Apple CEO Tim Cook speaks at the International Conference of Data Protection and Privacy Commissioners (ICDPPC) in Brussels. (credit: European Data Protection Supervisor) Apple CEO Tim Cook today called on the US government to pass "a comprehensive ......(more)

Data Classification in SQL Server 2019 - One of the areas that Redgate is working on is making data classification easier. Microsoft added some capabilities to SSMS 17.5 and Redgate has an EAP out for the next version of our data catalog tool. Azure SQL Database has had some advanced options ......(more)

Redgate acknowledged as a representative vendor in Gartner’s 2018 Market Guide for Data Masking - Data masking really has come of age. Gartner’s 2018 Market Guide for Data Masking has just been published and predicts that the global enterprise use of data masking (DM) or similar de-identification techniques will rise to 40%, an increase from 15% in 2017. And Redgate is acknowledged in the Guide as a representative vendor for Data Masking....(more)

Help Redgate improve Data Masker for SQL Server - Redgate are looking for people to help them get a deep understanding of compliance and SQL Server data masking requirements in order to ensure they can provide a world class solution. ...(more)

Apple Rolls Out GDPR-like Features for U.S. Users - New privacy rules allow U.S. customers to download all information Apple has on them, plus it adopts new transparency practices, essentially mirroring practices in the EU. ...(more)

Conferences, Classes, and Events

5th annual “Seattle Freecon" - Are you going to be in Seattle on Monday, Nov 5, 2018, but will not be attending one of the excellent precons at the PASS Summit? Then come on over to our freecon! The Seattle Freecon will be held on Nov 5, 2018 at 9:00am....(more)

Calling all user group leaders! We want to present for you in 2019! - By the end of December, we at SQLskills will have presented remotely (and a few in-person) to more than 100 user groups and PASS virtual chapters around the world in 2018! We’d love to present remotely for your user group in 2019, anywhere in the world, ......(more)

New class: Immersion Event on Azure SQL Database, Azure VMs, and Azure Managed Instance - Tim’s been working closely with the development team on Azure Managed Instance, presented with them at Ignite recently, and has been presenting internally at Microsoft field offices to their clients, as well as working with our own clients extensively ......(more)

Computing in the Cloud (Azure, Google , AWS)

SQL Server IaaS Extension Query Service for SQL Server on Azure VM - SQL Server IaaS Extension is installed by default on Azure virtual machines deployed from SQL Server based images on Azure Market Place. SQL Server IaaS extension manages SQL Server configurations on the VM including SQL server connectivity, storage ......(more)

Career Growth

ASF 015: Kalen Delaney interview - Introduction Kalen Delaney has been working with SQL Server since 1987 when she joined the Sybase Corporation in Berkeley, California. Kalen has an independent international trainer and consultant since 1992. She has been a SQL Server MVP since 1993 ......(more)

Active Forgiveness - Earlier this year, I wrote about Failure Integrity Power Transparency and Respect. This was taken from the perspective of a person who is learning how to navigate their failures or the failures of a group which includes them. In this... The post Active ......(more)

Some Thoughts on How to Prepare to Serve on the PASS Board of Directors - From time to time I’m asked for advice and insight on running for and serving on the PASS Board. I feel like the answer to that might fill a small book! I don’t have time to write that and I don’t think it would sell a lot of copies anyway, so maybe ......(more)

Big Data

SQL Server 2019 Big Data Clusters - At the Microsoft Ignite conference, Microsoft announced that SQL Server 2019 is now in preview and that SQL Server 2019 will include Apache Spark and Hadoop Distributed File System (HDFS) for scalable compute and storage.  This new architecture that ......(more)

Essential Open Source Big Data Tools - Click to learn more about author Paul Bates. The analysis of Big Data is a phenomenon that has gained considerable momentum in the past decade. The transition into the information age has made the analysis and visualization of Big Data vital to the success ......(more)

The On-Demand Business Ecosystem is Heavily Reliant on Big Data - Click to learn more about author Tuhin Bhatt. One of the biggest disruptors in technology is the on-demand solutions and services that have followed the trailblazing success of Uber. On-demand apps are presently dominating in multiple industries – fitness, ......(more)

Azure SQL Managed Instance

Connect to Azure SQL Database Managed Instance with Virtual Network peering - How to connect with an existing VM to your Managed Instance Vnet This guide assumes you already have a deployment of a Managed instance in your subscription Problem summary: Initially, you might not want to deploy a new machine using the script in the ......(more)

Azure SQL Managed Instance – Prerequisites - NOTE: This post contains steps for creating Azure resources.  You must have access to an Azure subscription to complete these steps. Before creating an Azure SQL Managed Instance, a number of prerequisite resources must be provisioned.  These are: An ......(more)

Azure SQL Database

Whirlwind Tour of Azure SQL Database - I have finally uploaded my Azure SQL Database presentation, apologies for the delay. I am already working on an improved version which I will be delivering next year. Here is the abstract: Azure SQL Database is a general-purpose relational database … ......(more)

Azure SQL DB – Failed to update database because the database is read-only - Quite an interesting  situation I found myself in where I was perplexed for about 5 minutes. I was connected to an Azure SQL Database where I was configuring some users where then I executed a query and was presented with … Continue reading ? ...(more)

Azure SQL Data Warehouse and Data Lake

NYC Yellow Cab Data in Azure SQL Data Warehouse - Microsoft Azure provides a convenient feature when creating a new Azure SQL Data Warehouse database. You can create the database from a backup of the Microsoft sample database, AdventureWorksDW. This is super fast and easy. It also has huge tables... The ......(more)

Analysis Services / BI on the MS Stack

BI Basics – Technology Serving Business - In my BI Basics series of blog posts, I’ve already discussed visualization and data transformation. Those are crucial aspects of Business Intelligence. Without the ability to acquire data and present it to people within the business, BI becomes somewhat ......(more)

AI/Machine Learning/Cognitive Services

How to Gain Real Value from AI - Click to learn more about author Gaby Olazabal. As Artificial Intelligence (AI)-based solutions are introduced to the insurance industry and a new wave of InsurTech companies rise up, it can be difficult to see the forest for the trees. AI-based products ......(more)

Administration of SQL Server

SQL Server Agent Job Sort Order - SQL Server Agent Job Sort OrderToday's post could also be titled "I have no idea what is happening here." We have an agent job, "Job - Do Stuff". We then created a few hundred jobs (templates for the win) all named like "Job - Do XYZ" where XYZ is a ......(more)

SQL Server 2016 Memory Accounting Part II: Another Suspicious Example - tl;dr - No answers yet but perhaps a cleaner picture of the puzzle. A few months ago I shared a puzzle I've been looking at.  The example i shared is from 4 vNUMA node VM, where the equation [database + stolen + free = total] holds true for the instance ......(more)

Identifying delays between SQL calls using SQL profiler - One of the common goto methods for query specific slowness which can be replicated via an application can be to start up a trace or extended events session whilst replicating the issue, we all know about the dangers of running these sessions without ......(more)

SQL SERVER – How to Get List of SQL Server Instances Installed on a Machine Via T-SQL? - Earlier last year, I had posted a very interesting blog post which still today gets quite a lots of interest is SQL SERVER – How to Get List of SQL Server Instances Installed on a Machine?. In the recent Comprehensive Database Performance Health Check, ......(more)

SQL Server Diagnostic Information Queries for October 2018 - This month, I have just made some minor improvements to most of the query sets. I have a T-SQL script that you can use to check whether your instance of SQL Server has been patched to mitigate against the Spectre/Meltdown CPU vulnerability. This works ......(more)

Latest Service Packs – To Install or Not to Install? - It is interesting, when working with many different clients, the questions about installing Windows Updates and SQL Server updates comes up and often the discussion leads to the pros versus cons of each. The need to apply updates and the balance with ......(more)

Keeping Large Table Statistics Current -TF2371 - Statistics are the magic ingredient that helps the query optimizer create its best guess for generating an execution plan. Keeping statistics as accurate as possible will give the optimizer the information it uses to calculate estimated costs and cardinality, ......(more)

Create a slipstream installer for SQL Server on Windows - Since the release of SQL Server 2008 Service Pack 1 in April 2009, it has been possible to install SQL Server with media that includes the latest patches, whether they be Service Packs (for SQL Server 2016 and prior), Cumulative Updates, and even hotfixes. ...(more)

What is wrong with MDS (Master Data Services) Database in SQL Server 2019 - After having published a blogpost on Master Data Services in SQL Server 2019, I have published a series of tweets expressing how much it hurts to se bad configurations of MDS in SQL Server 2019, I was encouraged a couple of people to blog about so more ......(more)

Do Index Reorganization Update Statistics? – Interview Question of the Week #196 - Question: Do Index Reorganization Update Statistics? Answer: No. Index Reorganization does not update Statistics of your database. This is one of the most common questions I receive during my SQL Server Performance Tuning Practical Workshop. Whenever ......(more)

How do I look at my error log if SQL won’t open? - Quick and easy post today. Hopefully you’ve opened the error log on a SQL instance. However, what happens if you don’t have the log viewer in SSMS? In fact, the instance won’t come up at all so you really need to see what went wrong. Fortunately, the ......(more)