Daniel Farina

   

Daniel Farina was born in Buenos Aires, Argentina. Self-educated, since childhood he showed a passion for learning. He studied at Universidad de Buenos Aires. Daniel started working as a programmer at a young age. Over the years he specialized in databases, particularly SQL Server and Oracle. Now with 30 years of age, his work experience includes working with various technologies like VB, C, .NET, web development, Windows and Linux systems. He likes to read about science, psychology, philosophy and many other things. In his spare time, he trains powerlifting aiming to compete.

2019 Awards
  

2018 Awards
     

2017 Awards
     

2016 Awards
     

2015 Awards
  

2014 Awards
  

• SQL Server 2014 Backup Encryption (last update: 2/3/2014)
  

• Comparison of the VARCHAR(max) and VARCHAR(n) SQL Server Data Types (last update: 10/6/2016)
  
• Overview of SQL Server sql_variant Data Type (last update: 11/2/2016)
  

• Deciding Between Editions of SQL Server for Production (last update: 8/23/2018)
  
• Execute SQL Server Script Files with the sqlcmd Utility (last update: 7/6/2017)
  
• How to Attach a SQL Server Database without a Transaction Log and with Open Transactions (last update: 4/29/2020)
  
• How to stop and start SQL Server services (last update: 2/6/2020)
  
• Introduction to SQL Server's sqlcmd utility (last update: 6/30/2017)
  
• Options to Move a Big SQL Server Database to a New Drive with Minimal Downtime (last update: 4/18/2014)
  
• Recover a SQL Server database prior to database changes (last update: 9/16/2016)
  
• SQL Server scripts to use with sqlcmd (last update: 9/14/2018)
  
• sqlcmd User Variables and Variable Precedence Examples (last update: 8/24/2017)
  
• Understanding SQL Server Schedulers, Workers and Tasks (last update: 8/11/2016)
  
• Using SQL Server sqlcmd scripting variables (last update: 8/15/2017)
  

• Check SQL Server Instant File Initialization for all Servers (last update: 11/13/2017)
  

• How To Interpret SQL Server DBCC SHOW_STATISTICS Output (last update: 11/17/2015)
  

• How to Fix a Corrupt MSDB SQL Server Database (last update: 6/24/2015)
  

• New SQL Server 2014 Dynamic Management Views (last update: 12/20/2013)
  
• SQL Server 2014 Real Time Query Monitoring (last update: 9/9/2014)
  

• Deciding to use SQL Server 2017 Express Edition (last update: 6/28/2018)
  
• Installing SQL Server 2017 Express (last update: 7/20/2018)
  
• Introduction to SQL Server Express User Instances (last update: 8/3/2018)
  
• SQL Server Express Versions (last update: 7/6/2018)
  

• Solving SQL Server Database Physical File Fragmentation (last update: 8/13/2013)
  

• Auto Generate Create Table Script Based on SQL Server Query (last update: 10/5/2018)
  

• Debugging Natively-Compiled Stored Procedures Statements (last update: 11/28/2014)
  
• Determine BUCKET_COUNT for Hash Indexes for SQL Server Memory Optimized Tables (last update: 1/7/2014)
  
• Guidelines for Using Natively-Compiled Stored Procedures in SSIS Packages (last update: 11/14/2014)
  
• Migrate to Natively Compiled SQL Server Stored Procedures for Hekaton (last update: 10/10/2013)
  
• Monitor Memory Consumption for SQL Server Memory Optimized Tables (last update: 9/22/2014)
  
• Overcoming storage speed limitations with Memory-Optimized Tables for SQL Server (last update: 10/2/2013)
  
• Setup a Memory Quota for SQL Server Memory Optimized Databases (last update: 10/31/2014)
  
• Understanding SQL Server Memory-Optimized Tables Hash Indexes (last update: 12/24/2013)
  
• Updating statistics for Memory-Optimized tables in SQL Server (last update: 11/29/2013)
  
• Workaround for lack of support for constraints on SQL Server Memory-Optimized Tables (last update: 11/18/2013)
  

• SQL Server Installation Best Practices (last update: 6/16/2017)
  

• Getting File Properties using SQL Server Integration Services Add-In (last update: 6/11/2015)
  

• Export SQL Server Data with Integration Services to a Mainframe (last update: 3/5/2015)
  
• Importing Mainframe Data including Packed Numbers with SQL Server Integration Services (last update: 1/20/2015)
  
• Importing Mainframe Data with SQL Server Integration Services (last update: 12/17/2014)
  

• Get Progress Information for SSIS Script Tasks (last update: 12/10/2014)
  
• Importing character columns containing binary zeros into SQL Server (last update: 12/1/2015)
  
• Importing Mainframe Data with SQL Server Integration Services and Host Integration Server (last update: 2/6/2015)
  
• Introduction to Mainframe Data Storage for SSIS Developers (last update: 1/26/2015)
  

• Parallelize Data Flows with SSIS Balanced Data Distributor Transformation (last update: 7/10/2015)
  

• SQL Server Linked Server Error could not map ordinals for one or more columns (last update: 11/25/2015)
  

• Does updating SQL Server statistics cause blocking (last update: 12/16/2016)
  
• Implementing SQL Server Transaction Retry Logic for failed transactions (last update: 3/25/2014)
  
• Monitoring SQL Server Blocked Sessions with SQLCMD (last update: 12/11/2017)
  

• Monitoring SQL Server Log Shipping with sqlcmd (last update: 1/3/2018)
  

• Deleting Historical Data from a Large Highly Concurrent SQL Server Database Table (last update: 3/30/2015)
  

• Automatically Send Performance Dashboard Reports during a database event using Reporting Services (last update: 3/15/2016)
  
• Create SQL Server Disk Space Report for All Servers (last update: 9/13/2017)
  
• Real time auditing of failed SQL Server logins with user settable performance counters in Performance Monitor (last update: 8/26/2013)
  

• Create a Process Dump of SQL Server using SqlDumper.exe Tool (last update: 1/31/2019)
  
• Disabling SQL Server Optimizer Rules with QUERYRULEOFF (last update: 2/25/2016)
  
• Enabling SQL Server Trace Flag for a Poor Performing Query Using QUERYTRACEON (last update: 8/28/2014)
  
• First Steps for SQL Server Performance Troubleshooting (last update: 12/17/2015)
  
• SQL Server Performance Tuning with Hypothetical Indexes (last update: 6/3/2014)
  
• Troubleshooting SQL Server Transaction Log Related Wait Types (last update: 1/5/2016)
  
• Usage of DBCC OPTIMIZER_WHATIF for SQL Server Query Tuning (last update: 8/7/2014)
  

• How to Modify the Global DNS Configuration on Servers Using PowerShell (last update: 4/20/2018)
  

• Different Approaches to Correct SQL Server Parameter Sniffing (last update: 6/24/2014)
  

• Implement Dynamic Data Sources in SQL Server Reporting Services (last update: 5/23/2016)
  

• Automatic SSRS report output of all report parameter combinations (last update: 4/8/2016)
  
• Simulate Reporting Services Data Driven Subscriptions on Unsupported Editions (last update: 4/15/2016)
  

• Issues with SQLCMD when using special characters (last update: 1/11/2018)
  

• Implementing SQL Server Row and Cell Level Security (last update: 9/10/2013)
  
• Meltdown and Spectre Vulnerabilities Impact on SQL Server (last update: 3/21/2018)
  

• Install SQL Operations Studio on Ubuntu Linux (last update: 6/12/2018)
  

• Automatic Updates for SQL Server Management Studio (last update: 9/24/2015)
  
• Getting Per Session Wait Statistics in SQL Server 2016 (last update: 11/3/2015)
  
• Implement Row Level Security Natively with SQL Server 2016 (last update: 8/26/2015)
  
• Install SQL Server Management Studio with Web Installer without Internet Access (last update: 9/16/2015)
  
• New Features in SQL Server Management Studio for SQL Server 2016 (last update: 8/6/2015)
  
• New SQL Server Management Studio Azure Integration (last update: 10/22/2015)
  
• Troubleshoot SQL Server Function Performance with the sys.dm_exec_function_stats DMV (last update: 11/11/2015)
  

• SQL Server Agent Service Won't Start Due to Access Denied (last update: 2/20/2020)
  

• How to Enable SQL Server CLR Integration using T-SQL (last update: 7/16/2019)
  
• Increasing Buffer Pool in SQL Server 2014 (last update: 1/31/2014)
  
• Recover SQL Server Resource Database (last update: 10/25/2019)
  
• SQL Server could not spawn FRunCommunicationsManager thread (last update: 12/26/2013)
  

• SQL Server Management Studio Performance Dashboard Reports Overview (last update: 12/21/2015)
  

• Adding SQL Server Tools to the PATH Environment Variable on Linux (last update: 3/23/2017)
  
• Configure SQL Server on Linux (last update: 3/8/2017)
  
• Configure SQL Server on Linux to Use Windows Authentication (last update: 10/12/2017)
  
• Introduction to Bash Scripting for SQL Server DBAs (last update: 11/6/2018)
  
• Introduction to Bash Scripting for SQL Server: Declaration of Variables and Constants (last update: 11/27/2018)
  
• Introduction to Bash Scripting: Conditional Statements (last update: 12/20/2018)
  
• Introduction to Bash Scripting: Display User Messages and Catch User Input (last update: 12/5/2018)
  
• Introduction to Bash Scripting: Functions (last update: 12/31/2018)
  
• Introduction to Bash Scripting: Iterative Statements Using Loops (last update: 12/28/2018)
  
• Introduction to Bash Scripting: Parameter Expansions (last update: 1/15/2019)
  
• Introduction to Bash Scripting: Pipes and Redirections (last update: 2/7/2019)
  
• Linux Administration for SQL Server DBA’s: Changing the I/O Scheduler (last update: 6/9/2017)
  
• Linux Administration for SQL Server DBA’s: Checking CPU Usage (last update: 1/30/2017)
  
• Linux Administration for SQL Server DBA’s: Checking Disk I/O (last update: 5/9/2017)
  
• Linux Administration for SQL Server DBA’s: Checking Disk Space (last update: 4/28/2017)
  
• Linux Administration for SQL Server DBA’s: Checking Network I/O (last update: 5/23/2017)
  
• Restore or Attach a Windows SQL Server Database Backup on a Linux Server (last update: 2/9/2017)
  
• Scheduling SQL Server Tasks on Linux (last update: 10/10/2018)
  
• Scheduling SQL Server Tasks on Linux Part 2: Advanced Cron Topics (last update: 10/18/2018)
  
• Scheduling SQL Server Tasks on Linux Part 3: Sending E-Mail Alerts with Cron (last update: 11/1/2018)
  
• Update SQL Server Applications on Ubuntu Linux with Apt (last update: 5/16/2018)
  
• Upgrading an Ubuntu Linux Distribution (last update: 6/4/2018)
  

• How to Restore Model Database in SQL Server (last update: 12/3/2019)
  
• Replace Model SQL Server Database with a User Database (last update: 12/13/2019)
  
• Track SQL Server TempDB Space Usage (last update: 6/30/2016)
  

• Get SQL Server Row Count and Space Used with the sp_rows (last update: 9/27/2018)
  
• SQL Server Loop through Table Rows without Cursor (last update: 9/12/2019)
  

• Different Ways to Connect to SQL Server Using sqlcmd (last update: 10/31/2017)
  

• DDL Trigger Notification for SQL Server Linked Server Changes (last update: 3/22/2019)
  
• How to Create, Modify or Drop a SQL Server Trigger (last update: 5/6/2019)
  
• How to find Updated Column in SQL Server Trigger (last update: 6/19/2019)
  
• How to View Triggers in SQL Server Management Studio (last update: 4/3/2019)
  
• SQL Server Referential Integrity Across Databases Using Triggers (last update: 3/4/2019)
  
• SQL Server Trigger Best Practices (last update: 6/6/2019)
  
• SQL Server Trigger Example (last update: 2/26/2019)
  
• SQL Server Trigger on View Example (last update: 4/24/2019)
  
• SQL Server Triggers Pros and Cons (last update: 5/22/2019)
  

• What's new in SQL Server 2014? Is it worth the upgrade? (last update: 1/23/2014)