Daniel Farina

Daniel Farina was born in Buenos Aires, Argentina. Self-educated, since childhood he showed a passion for learning.

   
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   

CategoryTitle
BackupSQL Server 2014 Backup Encryption
Common Runtime LanguageHow to Enable SQL Server CLR Integration using T-SQL
Common Runtime LanguageSQL Server CLR Introduction
Common Runtime LanguageSQL Server CLR Scalar Functions
Common Runtime LanguageSQL Server CLR Table Valued Function
Data TypesComparison of the VARCHAR(max) and VARCHAR(n) SQL Server Data Types
Data TypesOverview of SQL Server sql_variant Data Type
Database AdministrationDeciding Between Editions of SQL Server for Production
Database AdministrationExecute SQL Server Script Files with the sqlcmd Utility
Database AdministrationHow to Attach a SQL Server Database without a Transaction Log and with Open Transactions
Database AdministrationHow to stop and start SQL Server services
Database AdministrationIntroduction to SQL Server's sqlcmd utility
Database AdministrationOptions to Move a Big SQL Server Database to a New Drive with Minimal Downtime
Database AdministrationRecover a SQL Server database prior to database changes
Database AdministrationSQL Server scripts to use with sqlcmd
Database Administrationsqlcmd User Variables and Variable Precedence Examples
Database AdministrationUnderstanding SQL Server Schedulers, Workers and Tasks
Database AdministrationUsing SQL Server sqlcmd scripting variables
Database ConfigurationsCheck SQL Server Instant File Initialization for all Servers
Database Console Commands DBCCsHow To Interpret SQL Server DBCC SHOW_STATISTICS Output
Disaster RecoveryHow to Fix a Corrupt MSDB SQL Server Database
Dynamic Management Views and FunctionsNew SQL Server 2014 Dynamic Management Views
Dynamic Management Views and FunctionsSQL Server 2014 Real Time Query Monitoring
Express EditionDeciding to use SQL Server 2017 Express Edition
Express EditionInstalling SQL Server 2017 Express
Express EditionIntroduction to SQL Server Express User Instances
Express EditionSQL Server Express Versions
Fragmentation and Index MaintenanceSolving SQL Server Database Physical File Fragmentation
Functions User Defined UDFAuto Generate Create Table Script Based on SQL Server Query
In Memory OLTPDebugging Natively-Compiled Stored Procedures Statements
In Memory OLTPDetermine BUCKET_COUNT for Hash Indexes for SQL Server Memory Optimized Tables
In Memory OLTPGuidelines for Using Natively-Compiled Stored Procedures in SSIS Packages
In Memory OLTPMigrate to Natively Compiled SQL Server Stored Procedures for Hekaton
In Memory OLTPMonitor Memory Consumption for SQL Server Memory Optimized Tables
In Memory OLTPOvercoming storage speed limitations with Memory-Optimized Tables for SQL Server
In Memory OLTPSetup a Memory Quota for SQL Server Memory Optimized Databases
In Memory OLTPUnderstanding SQL Server Memory-Optimized Tables Hash Indexes
In Memory OLTPUpdating statistics for Memory-Optimized tables in SQL Server
In Memory OLTPWorkaround for lack of support for constraints on SQL Server Memory-Optimized Tables
Install and UninstallSQL Server Installation Best Practices
Integration Services Control Flow TransformationsGetting File Properties using SQL Server Integration Services Add-In
Integration Services Data Flow TransformationsExport SQL Server Data with Integration Services to a Mainframe
Integration Services Data Flow TransformationsImporting Mainframe Data including Packed Numbers with SQL Server Integration Services
Integration Services Data Flow TransformationsImporting Mainframe Data with SQL Server Integration Services
Integration Services DevelopmentGet Progress Information for SSIS Script Tasks
Integration Services DevelopmentImporting character columns containing binary zeros into SQL Server
Integration Services DevelopmentImporting Mainframe Data with SQL Server Integration Services and Host Integration Server
Integration Services DevelopmentIntroduction to Mainframe Data Storage for SSIS Developers
Integration Services PerformanceParallelize Data Flows with SSIS Balanced Data Distributor Transformation
Linked ServersSQL Server Linked Server Error could not map ordinals for one or more columns
Locking and BlockingDoes updating SQL Server statistics cause blocking
Locking and BlockingImplementing SQL Server Transaction Retry Logic for failed transactions
Locking and BlockingMonitoring SQL Server Blocked Sessions with SQLCMD
Log ShippingMonitoring SQL Server Log Shipping with sqlcmd
MaintenanceDeleting Historical Data from a Large Highly Concurrent SQL Server Database Table
MonitoringAutomatically Send Performance Dashboard Reports during a database event using Reporting Services
MonitoringCreate SQL Server Disk Space Report for All Servers
MonitoringReal time auditing of failed SQL Server logins with user settable performance counters in Performance Monitor
Performance TuningCreate a Process Dump of SQL Server using SqlDumper.exe Tool
Performance TuningDisabling SQL Server Optimizer Rules with QUERYRULEOFF
Performance TuningEnabling SQL Server Trace Flag for a Poor Performing Query Using QUERYTRACEON
Performance TuningFirst Steps for SQL Server Performance Troubleshooting
Performance TuningSQL Server Performance Tuning with Hypothetical Indexes
Performance TuningTroubleshooting SQL Server Transaction Log Related Wait Types
Performance TuningUsage of DBCC OPTIMIZER_WHATIF for SQL Server Query Tuning
PowerShellHow to Modify the Global DNS Configuration on Servers Using PowerShell
Query OptimizationDifferent Approaches to Correct SQL Server Parameter Sniffing
Reporting Services Data SourcesImplement Dynamic Data Sources in SQL Server Reporting Services
Reporting Services DevelopmentAutomatic SSRS report output of all report parameter combinations
Reporting Services DevelopmentSimulate Reporting Services Data Driven Subscriptions on Unsupported Editions
ScriptsIssues with SQLCMD when using special characters
SecurityImplementing SQL Server Row and Cell Level Security
SecurityMeltdown and Spectre Vulnerabilities Impact on SQL Server
SQL Operations StudioInstall SQL Operations Studio on Ubuntu Linux
SQL Server 2016Automatic Updates for SQL Server Management Studio
SQL Server 2016Getting Per Session Wait Statistics in SQL Server 2016
SQL Server 2016Implement Row Level Security Natively with SQL Server 2016
SQL Server 2016Install SQL Server Management Studio with Web Installer without Internet Access
SQL Server 2016New Features in SQL Server Management Studio for SQL Server 2016
SQL Server 2016New SQL Server Management Studio Azure Integration
SQL Server 2016Troubleshoot SQL Server Function Performance with the sys.dm_exec_function_stats DMV
SQL Server AgentSQL Server Agent Service Won't Start Due to Access Denied
SQL Server ConfigurationsIncreasing Buffer Pool in SQL Server 2014
SQL Server ConfigurationsRecover SQL Server Resource Database
SQL Server ConfigurationsSQL Server could not spawn FRunCommunicationsManager thread
SQL Server Management StudioSQL Server Management Studio Performance Dashboard Reports Overview
SQL Server on LinuxAdding SQL Server Tools to the PATH Environment Variable on Linux
SQL Server on LinuxConfigure SQL Server on Linux
SQL Server on LinuxConfigure SQL Server on Linux to Use Windows Authentication
SQL Server on LinuxIntroduction to Bash Scripting for SQL Server DBAs
SQL Server on LinuxIntroduction to Bash Scripting for SQL Server: Declaration of Variables and Constants
SQL Server on LinuxIntroduction to Bash Scripting: Conditional Statements
SQL Server on LinuxIntroduction to Bash Scripting: Display User Messages and Catch User Input
SQL Server on LinuxIntroduction to Bash Scripting: Functions
SQL Server on LinuxIntroduction to Bash Scripting: Iterative Statements Using Loops
SQL Server on LinuxIntroduction to Bash Scripting: Parameter Expansions
SQL Server on LinuxIntroduction to Bash Scripting: Pipes and Redirections
SQL Server on LinuxLinux Administration for SQL Server DBA’s: Changing the I/O Scheduler
SQL Server on LinuxLinux Administration for SQL Server DBA’s: Checking CPU Usage
SQL Server on LinuxLinux Administration for SQL Server DBA’s: Checking Disk I/O
SQL Server on LinuxLinux Administration for SQL Server DBA’s: Checking Disk Space
SQL Server on LinuxLinux Administration for SQL Server DBA’s: Checking Network I/O
SQL Server on LinuxRestore or Attach a Windows SQL Server Database Backup on a Linux Server
SQL Server on LinuxScheduling SQL Server Tasks on Linux
SQL Server on LinuxScheduling SQL Server Tasks on Linux Part 2: Advanced Cron Topics
SQL Server on LinuxScheduling SQL Server Tasks on Linux Part 3: Sending E-Mail Alerts with Cron
SQL Server on LinuxUpdate SQL Server Applications on Ubuntu Linux with Apt
SQL Server on LinuxUpgrading an Ubuntu Linux Distribution
System DatabasesHow to Restore Model Database in SQL Server
System DatabasesReplace Model SQL Server Database with a User Database
System DatabasesTrack SQL Server TempDB Space Usage
ToolsDifferent Ways to Connect to SQL Server Using sqlcmd
TriggersBuild SQL Server CLR Triggers
TriggersDDL Trigger Notification for SQL Server Linked Server Changes
TriggersHow to Create, Modify or Drop a SQL Server Trigger
TriggersHow to find Updated Column in SQL Server Trigger
TriggersHow to View Triggers in SQL Server Management Studio
TriggersSQL Server Referential Integrity Across Databases Using Triggers
TriggersSQL Server Trigger Best Practices
TriggersSQL Server Trigger Example
TriggersSQL Server Trigger on View Example
TriggersSQL Server Triggers Pros and Cons
TSQLGet SQL Server Row Count and Space Used with the sp_rows
TSQLSQL Server Loop through Table Rows without Cursor
Upgrades and MigrationsWhat's new in SQL Server 2014? Is it worth the upgrade?
User Defined Type UDTSQL Server CLR User Defined Types Example
TutorialTopic
SQL Server Triggers TutorialTriggers in SQL Server Tutorial
SQL Server Triggers TutorialType of Triggers in SQL Server
SQL Server Triggers TutorialPurpose of Triggers in SQL Server
SQL Server Triggers TutorialPros and Cons of Triggers in SQL Server
SQL Server Triggers TutorialDML Triggers in SQL Server
SQL Server Triggers TutorialSQL Server Triggers INSERTED Table
SQL Server Triggers TutorialSQL Server Triggers DELETED Table
SQL Server Triggers TutorialSQL Server Trigger After Insert
SQL Server Triggers TutorialSQL Server Trigger After Update
SQL Server Triggers TutorialSQL Server Trigger After Delete
SQL Server Triggers TutorialSQL Server Trigger Instead of Insert
SQL Server Triggers TutorialSQL Server Trigger Instead of Update
SQL Server Triggers TutorialSQL Server Trigger Instead of Delete
SQL Server Triggers TutorialCreate Trigger for SQL Server Insert Update and Delete
SQL Server Triggers TutorialNested and Recursive Triggers in SQL Server
SQL Server Triggers TutorialDDL Triggers in SQL Server
SQL Server Triggers TutorialDDL Trigger Example in SQL Server
SQL Server Triggers TutorialTrigger Functions in SQL Server
SQL Server Triggers TutorialSQL Server Logon Trigger Example
SQL Server Triggers TutorialSQL Server Disable and Enable Triggers
SQL Server Triggers TutorialUseful Queries for Triggers in SQL Server
No Records Found
CategoryGroupCategory (articles)
Analysis ServicesAnalysis Services Administration (31)
Analysis ServicesAnalysis Services Development (95)
Analysis ServicesAnalysis Services Dimensions (16)
Analysis ServicesAnalysis Services Measure Groups (7)
Analysis ServicesAnalysis Services Performance (14)
Analysis ServicesAnalysis Services Security (7)
Analysis ServicesAnalysis Services Tools (1)
Analysis ServicesAnalysis Services Tutorials (6)
Analysis ServicesCortana (5)
Analysis ServicesPerformance Point (4)
Business IntelligenceBig Data (23)
Business IntelligenceData Warehousing (4)
CloudAmazon AWS (45)
CloudApache Spark (3)
CloudAzure (187)
CloudAzure Backup and Restore (25)
CloudAzure Cosmos DB (11)
CloudAzure Data Factory (68)
CloudAzure Databricks (23)
CloudAzure Integration Services (14)
CloudAzure Synapse Analytics (33)
Data QualityData Quality Services (7)
Data QualityMaster Data Services (41)
Database AdministrationAvailability Groups (73)
Database AdministrationBackup (78)
Database AdministrationCentral Management Servers (9)
Database AdministrationClustering (73)
Database AdministrationComparison Data and Objects (14)
Database AdministrationCompression (21)
Database AdministrationContained Databases (4)
Database AdministrationContainers (12)
Database AdministrationDatabase Administration (188)
Database AdministrationDatabase Configurations (17)
Database AdministrationDatabase Console Commands DBCCs (25)
Database AdministrationDatabase Mail (18)
Database AdministrationDatabase Mirroring (33)
Database AdministrationDBA Best Practices (39)
Database AdministrationDedicated Administrator Connection (4)
Database AdministrationDeprecated Features (5)
Database AdministrationDevOps (34)
Database AdministrationDisaster Recovery (23)
Database AdministrationError Logs (10)
Database AdministrationExpress Edition (16)
Database AdministrationExtended Events (22)
Database AdministrationFILESTREAM (9)
Database AdministrationFragmentation and Index Maintenance (27)
Database AdministrationHardware (13)
Database AdministrationHigh Availability (3)
Database AdministrationIndexing (82)
Database AdministrationInstall and Uninstall (32)
Database AdministrationLicensing (4)
Database AdministrationLinked Servers (18)
Database AdministrationLocking and Blocking (38)
Database AdministrationLog Shipping (18)
Database AdministrationMaintenance (34)
Database AdministrationMonitoring (115)
Database AdministrationOther Database Platforms (67)
Database AdministrationPartitioning (14)
Database AdministrationPerformance Data Warehouse (4)
Database AdministrationPerformance Tuning (121)
Database AdministrationPolicy Based Management (29)
Database AdministrationPowerShell (127)
Database AdministrationProfiler and Trace (20)
Database AdministrationQuery Store (7)
Database AdministrationRecovery Models (4)
Database AdministrationReplication (75)
Database AdministrationResource Governor (5)
Database AdministrationRestore (40)
Database AdministrationSQL Server 2016 (100)
Database AdministrationSQL Server 2017 (44)
Database AdministrationSQL Server 2019 (19)
Database AdministrationSQL Server 2022 (3)
Database AdministrationSQL Server Configurations (75)
Database AdministrationSQL Server on Linux (76)
Database AdministrationStreamInsight (2)
Database AdministrationSystem Databases (31)
Database AdministrationUpgrades and Migrations (54)
Database AdministrationVirtualization (25)
Database AdministrationWindows Internal Database (1)
Database DevelopmentApplication Development (36)
Database DevelopmentChange Data Capture (14)
Database DevelopmentCommon Runtime Language (12)
Database DevelopmentCommon Table Expressions (3)
Database DevelopmentConstraints (20)
Database DevelopmentData Cleansing for Validation (2)
Database DevelopmentData Science (3)
Database DevelopmentData Types (17)
Database DevelopmentDatabase Design (68)
Database DevelopmentDates (47)
Database DevelopmentDebugging (4)
Database DevelopmentDynamic Management Views and Functions (33)
Database DevelopmentDynamic SQL (7)
Database DevelopmentEntity Framework (13)
Database DevelopmentError Handling (8)
Database DevelopmentFull Text Search (20)
Database DevelopmentFunctions System (65)
Database DevelopmentFunctions User Defined UDF (40)
Database DevelopmentIdentities (17)
Database DevelopmentImport and Export (74)
Database DevelopmentIn Memory OLTP (32)
Database DevelopmentJOIN Tables (21)
Database DevelopmentLanguage Integrated Query LINQ (7)
Database DevelopmentMicrosoft Access Integration (8)
Database DevelopmentMicrosoft Excel Integration (39)
Database DevelopmentMicrosoft Flow (1)
Database DevelopmentPaging (5)
Database DevelopmentPython (36)
Database DevelopmentQuery Optimization (14)
Database DevelopmentQuery Plans (20)
Database DevelopmentR Language (11)
Database DevelopmentScripts (35)
Database DevelopmentService Broker (11)
Database DevelopmentSpatial Data Storage (9)
Database DevelopmentSQL Injection (5)
Database DevelopmentSQL Server Management Objects SMO (3)
Database DevelopmentStored Procedures (27)
Database DevelopmentSynonyms (4)
Database DevelopmentTable Valued Parameters (4)
Database DevelopmentTemp Tables (9)
Database DevelopmentTemporal Tables (13)
Database DevelopmentTesting (31)
Database DevelopmentTransactions (8)
Database DevelopmentTriggers (44)
Database DevelopmentTSQL (296)
Database DevelopmentUser Defined Type UDT (3)
Database DevelopmentViews (13)
Database DevelopmentXML (14)
Integration ServicesData Transformation Services (5)
Integration ServicesIntegration Services Administration (10)
Integration ServicesIntegration Services Analysis Services Tasks (5)
Integration ServicesIntegration Services Best Practices (10)
Integration ServicesIntegration Services Configuration Options (21)
Integration ServicesIntegration Services Connection Managers (5)
Integration ServicesIntegration Services Control Flow Transformations (14)
Integration ServicesIntegration Services Data Flow Transformations (19)
Integration ServicesIntegration Services Development (106)
Integration ServicesIntegration Services Email (3)
Integration ServicesIntegration Services Error Handling (8)
Integration ServicesIntegration Services Excel (14)
Integration ServicesIntegration Services Execute Package Options (8)
Integration ServicesIntegration Services Import and Export Wizard (2)
Integration ServicesIntegration Services NULL Management (4)
Integration ServicesIntegration Services Oracle (4)
Integration ServicesIntegration Services Performance (12)
Integration ServicesIntegration Services Security (7)
Integration ServicesIntegration Services Upgrade (4)
Power PlatformPower Apps (17)
Power PlatformPower BI (128)
Power PlatformPower BI Charts (44)
Power PlatformPower BI Formatting (12)
Professional DevelopmentProfessional Development Books (3)
Professional DevelopmentProfessional Development Branding (13)
Professional DevelopmentProfessional Development Career (17)
Professional DevelopmentProfessional Development Career Planning (16)
Professional DevelopmentProfessional Development Career Transition (4)
Professional DevelopmentProfessional Development Certifications (47)
Professional DevelopmentProfessional Development Community (16)
Professional DevelopmentProfessional Development Conferences (2)
Professional DevelopmentProfessional Development Interview Questions BI (15)
Professional DevelopmentProfessional Development Interview Questions DBA (22)
Professional DevelopmentProfessional Development Interview Questions Developer (6)
Professional DevelopmentProfessional Development Interviewing (38)
Professional DevelopmentProfessional Development Job Search (17)
Professional DevelopmentProfessional Development Management (9)
Professional DevelopmentProfessional Development Recruiters (6)
Professional DevelopmentProfessional Development Resume (13)
Professional DevelopmentProfessional Development Skills Development (18)
Reporting ServicesReporting Services Administration (19)
Reporting ServicesReporting Services Analysis Services (4)
Reporting ServicesReporting Services Best Practices (6)
Reporting ServicesReporting Services Charts (25)
Reporting ServicesReporting Services Configuration (10)
Reporting ServicesReporting Services Custom Report (2)
Reporting ServicesReporting Services Dashboard (1)
Reporting ServicesReporting Services Data Sources (10)
Reporting ServicesReporting Services Development (37)
Reporting ServicesReporting Services Drill Through (4)
Reporting ServicesReporting Services Dynamic Reports (11)
Reporting ServicesReporting Services Filtering (3)
Reporting ServicesReporting Services Formatting (26)
Reporting ServicesReporting Services Functions (5)
Reporting ServicesReporting Services Images (2)
Reporting ServicesReporting Services Installation (9)
Reporting ServicesReporting Services KPI (5)
Reporting ServicesReporting Services Maps (4)
Reporting ServicesReporting Services Migration (5)
Reporting ServicesReporting Services Monitoring (5)
Reporting ServicesReporting Services Network Load Balancing (4)
Reporting ServicesReporting Services Overview (5)
Reporting ServicesReporting Services Parameters (15)
Reporting ServicesReporting Services Performance (6)
Reporting ServicesReporting Services Report Builder (9)
Reporting ServicesReporting Services Report Models (1)
Reporting ServicesReporting Services Security (8)
Reporting ServicesReporting Services SharePoint (1)
Reporting ServicesReporting Services Subreports (4)
Reporting ServicesReporting Services Tutorials (1)
SecurityAuditing and Compliance (45)
SecurityEncryption (28)
SecuritySecurity (194)
SecuritySurface Area Configuration Manager (4)
SharePointSharePoint (130)
SharePointSharePoint Administration (46)
SharePointSharePoint Configuration (27)
SharePointSharepoint Design (46)
SharePointSharePoint Document Management (20)
ToolsAzure Data Studio (10)
ToolsSQL Operations Studio (11)
ToolsSQL Server Agent (92)
ToolsSQL Server Management Studio (74)
ToolsSQL Server Management Studio Configuration (22)
ToolsSQL Server Management Studio Shortcuts (9)
ToolsTools (31)