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
2019 Awards

2018 Awards


2017 Awards


2016 Awards


2015 Awards

2014 Awards

Backup
- SQL Server 2014 Backup Encryption (last update: 2/3/2014)
Data Types
- 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)
Database Administration
- 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)
Database Configurations
- Check SQL Server Instant File Initialization for all Servers (last update: 11/13/2017)
Database Console Commands DBCCs
- How To Interpret SQL Server DBCC SHOW_STATISTICS Output (last update: 11/17/2015)
Disaster Recovery
- How to Fix a Corrupt MSDB SQL Server Database (last update: 6/24/2015)
Dynamic Management Views and Functions
- New SQL Server 2014 Dynamic Management Views (last update: 12/20/2013)
- SQL Server 2014 Real Time Query Monitoring (last update: 9/9/2014)
Express Edition
- 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)
Fragmentation and Index Maintenance
- Solving SQL Server Database Physical File Fragmentation (last update: 8/13/2013)
Functions - User Defined UDF
- Auto Generate Create Table Script Based on SQL Server Query (last update: 10/5/2018)
In-Memory OLTP
- 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)
Install and Uninstall
- SQL Server Installation Best Practices (last update: 6/16/2017)
Integration Services Control Flow Transformations
- Getting File Properties using SQL Server Integration Services Add-In (last update: 6/11/2015)
Integration Services Data Flow Transformations
- 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)
Integration Services Development
- 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)
Integration Services Performance
- Parallelize Data Flows with SSIS Balanced Data Distributor Transformation (last update: 7/10/2015)
Linked Servers
- SQL Server Linked Server Error could not map ordinals for one or more columns (last update: 11/25/2015)
Locking and Blocking
- 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)
Log Shipping
- Monitoring SQL Server Log Shipping with sqlcmd (last update: 1/3/2018)
Maintenance
- Deleting Historical Data from a Large Highly Concurrent SQL Server Database Table (last update: 3/30/2015)
Monitoring
- 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)
Performance Tuning
- 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)
PowerShell
- How to Modify the Global DNS Configuration on Servers Using PowerShell (last update: 4/20/2018)
Query Optimization
- Different Approaches to Correct SQL Server Parameter Sniffing (last update: 6/24/2014)
Reporting Services Data Sources
- Implement Dynamic Data Sources in SQL Server Reporting Services (last update: 5/23/2016)
Reporting Services Development
- 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)
Scripts
- Issues with SQLCMD when using special characters (last update: 1/11/2018)
Security
- 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)
SQL Operations Studio
- Install SQL Operations Studio on Ubuntu Linux (last update: 6/12/2018)
SQL Server 2016
- 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
- SQL Server Agent Service Won't Start Due to Access Denied (last update: 2/20/2020)
SQL Server Configurations
- 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
- SQL Server Management Studio Performance Dashboard Reports Overview (last update: 12/21/2015)
SQL Server on Linux
- 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)
System Databases
- 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)
T-SQL
- 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)
Tools
- Different Ways to Connect to SQL Server Using sqlcmd (last update: 10/31/2017)
Triggers
- 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)
Upgrades and Migrations
- What's new in SQL Server 2014? Is it worth the upgrade? (last update: 1/23/2014)