(Jack Vamvas) Question: I’m working on an Enterprise application upgrade and have hit some problems. As part of the debugging process I’m inspecting the sql queries executing. The program is currently running SELECT 1 FROM TABLE. (replace TABLE with actual table name).
Tag: sql server
Change size of Azure SQL Managed Instance using PowerShell
(Jovan Popovic) Azure SQL Managed Instance is fully-managed SQL Server Database Engine hosted in Azure cloud. With Managed Instance you can easily add/remove cores associated to the instance and change the reserved size of the instance. You can use PowerShell to easily manage size of the instance an
Using the STRING_SPLIT Function in SQL Server
(Srinath M S) SQL Server 2016 provides a way to split a string that is concatenated with a separator.
How do I get High Availability in my Azure Storage Accounts?
(Denny Cherry) This question actually comes up a lot. With the new managed storage it’s less of an issue as Managed storage takes care of the high availability for you.
SQL SERVER – Split Comma Separated Value String in a Column Using STRING_SPLIT
(Pinal Dave) In this blog post, we will learn about STRING_SPLIT function which was earlier introduced in SQL Server 2016 but still not widely adopted in the industry. We will learn today how to Split Comma Separated Value String in a Column Using STRING_SPLIT.
Query To Retrieve Statistics Data: dm_db_stats_histogram
(Grant Fritchey) Starting with SQL Server 2016 Sp1 CU2, a new way of directly querying statistics, specifically the histogram, has been introduced: dm_db_stats_histogram. We’ve always been able to query the statistics using DBCC SHOW_STATISTICS.
What are the system databases?
(Kenneth Fisher) I get to help with technical interviews every now and again, and one of the questions we always ask is “What are the system databases, and what are they for.”
Connecting from SSRS 2016 to SSAS using HTTP/MSMDPump and Basic Authentication – ‘Object reference not set to an instance of an object’
(Krishnakumar Rukmangathan) After upgrading to SSRS 2016 SP1 CU8, or SSRS 2016 SP2, you might see the following error when running reports or connecting to a SSAS data source using HTTP/MSMDPump with Basic Authentication, “Object reference not set to an instance of an object.”
Using SQL Server Integration Services to Export Data in JSON Format
(Parvathy Natraj) How do I export data in JSON format using SQL Server Integration Services?
Getting value out of data quickly
(James Serra) There are times when you need to create a “quick and dirty” solution to build a report. This blog will show you one way of using a few Azure products to accomplish that.