SQL Server – Database Management – File Groups & Files – v2019/CTP

Background Wanted to list out the steps to add filegroups and files to a database. And, remove them. Outline Create Database File Group Management Add Add Filegroup Add file to filegroup Remove Remove file from filegroup Remove Filegroup Drop Database Tasks Create Database SQL Syntax Sample Filegroup Management Filegroup Management - Add Filegroup Management - … Continue reading SQL Server – Database Management – File Groups & Files – v2019/CTP

Transact SQL – STRING_AGG – Error – “Incorrect syntax near ‘within'”

Background Working on a script, but noticed an error when I tried to sort the data using the String_Agg within group clause. Code Let us reproduce using a sample data set. SQL Sample -01 SQL Output Sample -02 Outline If one reviews our output, one will notice that the cities are listed based on the … Continue reading Transact SQL – STRING_AGG – Error – “Incorrect syntax near ‘within'”

SQL Server – Installation/Upgrade – Extract package files

Background Here I am struggling to install Microsoft SQL Server. It just will not install. And, stubborness is not bailing me out. Take a look at the files Googled till I bled. One of things I was asked to do was to take a look at the installation package. Artifacts RTM For the RTM, which … Continue reading SQL Server – Installation/Upgrade – Extract package files

SQL Server – Installation – DISM

Background Trying to install Microsoft SQL Server, but ran into a familiar error. Blockers Microsoft SQL Server 2005 Setup System Configuration Check Images IIS Feature Requirement ASP.Net Version Registration Requirement Prerequisite Installation DISM Outline Get dism /online /get-features dism /online /get-featureinfo Enable Feature Dism /online /Enable-Feature Tasks get-features Syntax Sample Output get-featureinfo Syntax Sample Output … Continue reading SQL Server – Installation – DISM

SQL Server – v2019 – OS Requirements

Background We are 3 months into 2019, and it is way past time to start evaluating SQL Server v2019. Product Development Cycle In terms of community participation, the product engagement cycle is :- Community Technology Preview ( CTP ) Release Candidate Release To Manufacturing Cumulative Updates Within each of this cycle, there will be tiered … Continue reading SQL Server – v2019 – OS Requirements

SSMS – v2008 – Error – “Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)”

Background Drew a quick error running Sql Server Management Studio (SSMS). Error Text The error reads :- Index was outside the bounds of the array. (Microsoft.SqlServer.Smo) Image Explanation Error reads Microsoft.SqlServer.Smo Index was outside the bounds of the array Recreate Tried connecting to Microsoft SQL Server v2017 instance with Sql Server Management Studio v2008. TroubleShooting … Continue reading SSMS – v2008 – Error – “Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)”