SQL Server – Configuration – Default Directories

Background In the last few days knee-deep reviewing SQL Server Installs and Scripts. ServerProperty In the last hour or so found myself looking at what is exposed via ServerProperty. Folders Here are some of the File System folder entries exposed through the ServerProperty function. InstanceDefaultDataPath Name of the default path to the instance log files. … Continue reading SQL Server – Configuration – Default Directories

Transact SQL :- sys.dm_os_enumerate_filesystem – Error – 0x8007007a

Background Still stuck on sys.dm_os_enumerate_filesystem. Want to touch on a couple of diagnostic steps. Lineage Posts along same subject. Transact SQL :- sys.dm_os_enumerate_filesystem Date Published :- 2020-04-23 Link Usage Syntax SQL Sample Sample -01 SQL Output Issues Issue - "Internal error. The string routine in file sql\ntdbms\storeng\dfs\alloc\storagedmv.cpp, line 799 failed with HRESULT 0x8007007a." Error Message … Continue reading Transact SQL :- sys.dm_os_enumerate_filesystem – Error – 0x8007007a

Transact SQL :- sys.dm_os_enumerate_filesystem

Background Will like to take a few minutes to discuss an un-documented Transact SQL function. The function's name is sys.dm_os_enumerate_filesystem. Usage Syntax SQL Sample Sample -01 SQL Output Issues Issue - Parameter is incorrect Error Message Textual Image Explanation We passed a null or an empty string as the file pattern to look for. Remediate … Continue reading Transact SQL :- sys.dm_os_enumerate_filesystem

UDP Flood Attack

Background My Internet connection has been spotty for a while here. TroubleShooting Finally, took the time this evening to see what is going on. Outline Router Check the Router Wireless Access Point Check the Wireless Access Points Computer & Hosts Check the computers and hosts connected to your Router & Hosts Internet Service Provider Check … Continue reading UDP Flood Attack

SQL Server – 2019 – Developer Edition – Installation Media

Background Microsoft SQL Server Developer Edition is free for non-production use.   Explore Let us touch on where to get our hands on the install media/ISO. Media Microsoft SQL Server Downloads URL Link Microsoft | Visual Studio Subscriptions URL Link   Review Media Availability Microsoft | Visual Studio Subscriptions Outline Go to Visual Studio Subscriptions … Continue reading SQL Server – 2019 – Developer Edition – Installation Media

DBeaver :- Generate Schema – Datatypes and Column Widths – Error – “Cannot specify a column width on data type”

Background Let us stay with Dbeaver and point out a slightly different issue.   Sample Data SQL Server DDL DDL - Create Schema and Table DBeaver Launched Dbeaver and worked towards scripting the object's DDL. Outline Here are the steps :- Connect to the Database Transverse the Database Navigator outline and select Instance\Database\Schema\Tables Select the … Continue reading DBeaver :- Generate Schema – Datatypes and Column Widths – Error – “Cannot specify a column width on data type”

DBeaver :- Export Data – Timestamp / SQL Server – Error – “Cannot insert an explicit value into a timestamp column”

Background Reviewing a system and wanted to get the data from one of it's table and copy it into a new system. Sample Data SQL Server DDL DDL - Create Schema and Table DML DML - Add Data to Table Microsoft SQL Server Management Studio ( SSMS ) SQL Server's Management Studio capably manages such … Continue reading DBeaver :- Export Data – Timestamp / SQL Server – Error – “Cannot insert an explicit value into a timestamp column”

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'”

ANSI Standards – Database – Substring

Background Reviewing some SQL and wanted to point out a tiny dissimilarity between database platforms. Data Our test table is Oracle's SCOTT.EMP Here is what the data looks like :- Substring/Substr The HIREDATE is the only well formatted fixed length string. Its format is DD-MMM-YY. Query Oracle SQL Output Explanation Oracle relies on Substr to … Continue reading ANSI Standards – Database – Substring