sqlcmd – Avail on MS Windows

Background Trying to a DOS Command batch on an MS Windows Box. Ran into an easy to correct error. Error Error Image Error Text   Remediation Outline Identify sqlcmd Download sqlcmd Install sqlcmd   Identify sqlcmd artifacts sqlcmd is available here. Images   Download sqlcmd Depending on the bitness of your OS, please choose (x64) … Continue reading sqlcmd – Avail on MS Windows

SQL Server – Transact SQL – Function – Unicode – Online Sample

Background Earlier this week I was helping a family member with an exercise. Transact SQL - Unicode His exercise involved using the Unicode function. Sample Googling landed me at the official Microsoft documentation for the Unicode Function. Documentation Unicode Transact SQL Link Microsoft Sample Microsoft Sample -01 Code Output     Microsoft Sample -02 Outline … Continue reading SQL Server – Transact SQL – Function – Unicode – Online Sample

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