BLOG

100% discount voucher for DP-700 and DP-600 exams. Take the Fabric certification exams for free!

Career, Courses and Certifications

The WORLD Dataviz Championship in Power BI has started

Events and Talks

Can I use Visual Studio Community in my company to develop Integration Services, Analysis Services, and Reporting Services?

SQL Server - How to query SQL Server Integration Services Catalog (SSISDB) job execution history

Azure SQL Database - DTU, vCore, General Purpose, Serverless, Business Critical, Hyperscale, Elastic Pool: Which to Choose?

Azure SQL Database

SQL Server - Change Tracking vs CDC: When and how to implement lightweight data tracking

SQL Server 2025 - We finally have native regular expression (regex)

Azure SQL Database Firewall - How to Configure Server-Level and Database-Level Rules

Databases

Azure SQL Managed Instance - Warning! Why Shrink Can Destroy Your Performance

Databases

[Live] - Microsoft Reactor - Fabric Data Days: Prepare for certification exam day

[Live] - dotNET Channel - Database Tips for Developers | 12th edition

[Live] - FabricCast #1 - Dirceu Resende: Career, Power BI Embedded, Market and Microsoft Fabric

[Live] - Canal dotNet - Database Tips for Developers: SQL Server 2025 News | 11th edition

[Live] - Coding Night Channel - Roundtable #231: Devs vs DBAs vs Infra: data, containers, DevOps and much more! - 1st edition

[Live] - Microsoft Reactor - PL-300: Prepare for Exam Day and Q&A

[Live] - Coding Night - Roundtable #222: Security in the Use of Databases - OWASP, tips, and much more

[Live] - Database Tips for Developers: SQL Server 2025 and Artificial Intelligence | 10th edition

[Live] - dotNET Channel - Database Tips for Developers #09: What's New in SQL Server 2025

[In-Person Event] - PMI Talk - Data and Intelligence in Project Management

[PowerLive] - Power CLR: APIs, Files and MUCH more directly in SQL Server

Boost Your Career in 2025: Azure Certifications in Focus! - 2nd Edition

Events and Talks

Microsoft Fabric Challenge - May 1st to 17th, 2025

[Live] - TI ES - Databricks: SQL or PySpark?

Events and Talks

[In-Person Event] - Microsoft Reactor São Paulo - How to share billion-row reports with thousands of people at low cost

[Live] - Microsoft Reactor - DP-700: Prepare for exam day and Q&A

[Live] - dotNET Channel - Database Tips for Developers | 8th edition

[Live] - Microsoft Reactor - DP-700: Data Warehousing in Microsoft Fabric

[Live] - FinOps: optimizing cloud costs

Microsoft Reactor - From Synapse to Fabric - DP-700 Certification for Data Engineers

Spark, AI and Streaming in Power BI? Learn more about Microsoft Fabric! - 2nd edition

[Live] - Coding Night - Roundtable #212: Security in the Use of Databases - OWASP, tips, and much more!

CT Tech Talks: Job Market - Development, AI, Cloud & Data

Events and Talks

Tips to help people applying for IT jobs

[Live] - Infrastructure for DBAs

[Live] - Azure Architect Journey: the AZ-305 exam in detail! | Azure Synapse Analytics

SQL Saturday Vitoria 2024

[Live] - Database Monitoring and Observability: from infrastructure to applications | 2nd edition

Events and Talks

[Live] - Roundtable #202: Open source from A to Z - projects, tips, possibilities | 12th edition

Microsoft Most Valuable Professional (MVP) 2024

[Live] - AI Tour Review and AI Technologies on Azure

Events and Talks

[Live] - Database Monitoring and Observability: from infrastructure to applications

Events and Talks

[Live] - Database Tips for Developers | 7th edition

[Live] - Roundtable #198: Devs vs DBAs: relational, NoSQL, ORMs - 3rd edition

[Live] - Database Security: Recommendations and Best Practices to Avoid Vulnerabilities and Attacks

[Live 05.07] - Roundtable #190: Cloud Performance - from applications to databases and infrastructure

Events and Talks

[Live 04.07] - Roundtable | Tips - IT Career

Events and Talks

[Live 03.07] - Power Live - 10 years - Saving on Fabric with SSAS

Events and Talks

[Live 02.05] - #PodCast 010 - Power Embedded: Reduce Costs and Increase Performance with Dirceu Resende

Events and Talks

[Live 01.05] - Roundtable #174: Data Analytics and Event Streaming - use cases, tools and tips

Events and Talks

[Live 11.04] - Azure Architect Journey: the AZ-305 exam in detail! | 25th edition

Events and Talks

[Live 20.02] - Live #82: Relational Databases on Azure - How much does it cost and how to pay less?

Events and Talks

[Live 14.02] - Roundtable #169: Cloud Security: from application to infrastructure | 2nd edition

Events and Talks

[Live 16.01] - What to study for 2024: cloud, data and certifications

Events and Talks

Power BI Report Server - The local Power BI report server you install on your company server

Microsoft Fabric (SKU F) - The most economical Power BI license

Power BI Embedded (SKU A) - Learn more about the license that does not need a PRO account to view reports

Power BI Premium per Capacity (SKU EM) - The licensing that lets you embed reports in internal applications

Power BI Premium per Capacity (SKU P) - How the most expensive and complete Power BI license works

Power BI Premium Per User (PPU) - How this Premium Power BI license works

Power BI PRO - How the most used Power BI license in companies works

Power BI Free - How Power BI free licensing works

[Live 11/06] - Alive #6 - with Dirceu Resende in a conversation about Power BI Embedded and Fabric

Events and Talks

[Live 10/01] - Power BI: how to reduce licensing costs with Embedded + Fabric?

Events and Talks

[Live 03/01] - Azure Architect Journey: the AZ-305 exam in detail! | 14th edition

Events and Talks

[Live 12/29] - Roundtable #167: Technology certifications in 2024 - What is worth studying?

[Live 21/12] - Roundtable #166 - Technology expectations and job market for 2024

Events and Talks

[Live 20/12] - Microsoft Reactor - Unlimited Potential: Maximizing Reach with Power BI and Microsoft Fabric

Events and Talks

[Live 12/12] - Roundtable #164: Disaster Recovery, monitoring, failure prevention

Events and Talks

[Live 28/11] - Is it possible to use databases in containers?

Events and Talks

SQL Saturday #1067 - Sao Paulo 2023

SQL Saturday #1065: Vitoria 2023 - The largest data event in Espirito Santo!

SQL Saturday #1063 - Belo Horizonte 2023

[Live 16/10/2023] - Azure Data Factory: ETLs, data pipelines and cloud integrations | Part 3

Events and Talks

[Live 05/09/2023] - Azure SQL Database - How to replicate data between the cloud and the local database (On-premises)

Events and Talks

[Live 04/09/2023] - Database Tips for Developers - SQL Server | 6th edition

Events and Talks

SQL Server - How to identify and compress tables and indexes without data compression

[Live - 23/08] - SQL Server is extremely fast. You just don't know how to use it! | Part 13

Events and Talks

Microsoft certification exams: official practice tests and study materials

SQL Server - How to identify the date when the trial / evaluation license will expire

SQL Server - How to create login auditing using instance logs

Analysis Services - How to monitor the progress of cube processing by SQL Server

SQL Server - How to reset and recover the SSIS catalog password (SQL Server master key)

SQL Server - How to generate a script with all database indexes

SQL Server and Azure SQL - How to Create a Calendar Table Using SQL Including Holidays

SQL Server and Azure SQL - Challenge for Grouping Data Using Hierarchies

[Live - 02/08] - Azure Architect Journey: the AZ-305 exam in detail! | 1st edition

Events and Talks

[Live - 31.07] - Spark, AI and Streaming in Power BI? Meet Microsoft Fabric!

Events and Talks

[Live] - Microsoft Reactor - GitHub Copilot + Databases: more productivity writing SQL instructions

[Live] - SQL Week Recife Conference 5 - Microsoft Fabric: What Changes for BI?

Analysis Services - How to Change the DeploymentModel Between Multidimensional and Tabular

Business Intelligence (BI)

Analysis Services - How to Move Cubes and Databases to Another Disk or Directory

Business Intelligence (BI)

AZ-305 Exam: Designing Microsoft Azure Infrastructure Solutions - Free Study Material

SQL Server - The SQL Agent Job Execution History Is Disappearing

Meet Power CLR: SQL Server integration with APIs, files, webservices, FTP, and much more!

Live at @cloud4developers - Azure SQL straight to the point

PowerAlerts - The best SQL Server alerting and monitoring system you have ever seen!

SQL Server and Azure SQL - How to Delete or Update Data in Large Tables

DP-900 Exam Microsoft Azure Data Fundamentals - Free Study Material for the Certification Exam

Azure Data Factory (ADF) - How to Change the Service Objective and Resize an Azure SQL Database Using T-SQL Commands

Azure Data Factory (ADF)

SQL Server - How to Synchronize Table Data Between Different Databases Using Trigger

Online Event - Database Tips for Developers - SQL Server, PostgreSQL, MongoDB and much more!

Live - How to Version and Deploy Power BI Models and Reports with Azure DevOps

Live - PostgreSQL, MySQL, MariaDB, Managed Instance and Cosmos DB: Administering PaaS databases beyond Azure SQL Database

Live - How to get your Microsoft certification for free and an overview of Azure data exams

New Microsoft Certified Fundamentals portal for those who want to earn their first certification

SQL Server - How to Validate Email and Email Domain Using SQLClr (C#)

Voucher to Take a Microsoft Certification Exam for Free - Including the PL-300 Power BI

SQL Server - How to unlock a login without changing/resetting the password

SQL Server - Password Policies: Expiration, Mandatory Change and Login Lockout After N Attempts

DataOps - DevOps applied to data projects (Power BI, Azure Data Factory, Azure Analysis Services and Database Objects)

Events and Talks

Invitation to the Live "Is a college degree important in the tech industry?" - May 20th at 8PM

Career, Courses and Certifications

Live #45: Best Practices for Administering Databases on Azure (05/17 at 9 PM)

SQL Server - How to increase query speed by changing the server power plan

Top 25 Best SQL Blogs in the World

Azure SQL Database - How to Create and Manage Users and Logins with SQL and Azure Active Directory (Azure AD) Authentication

Database

SQL Server - ISNULL vs COALESCE: Understanding the Differences Between the Two Functions

SQL Server and Azure SQL Database - How to Return CPU and Memory Usage Using T-SQL

SQL Server - How to identify the query that fired a DML trigger on a table

SQL Server - How to identify and monitor trigger execution

SQL Server - Beware of the SecurityAdmin Server Role: Using Privilege Escalation to Become Sysadmin

SQL Server and Azure SQL Database - How to Identify Key Lookup Occurrences Through Plan Cache

Azure SQL Database - How to view the automatic backup history

Azure SQL Database

SQL Server - How to identify all missing indexes in a database

Marketing and IT: discover the benefits of integrating these areas in your company!

Black Friday discounts for Azure and SQL Server database courses!

Azure SQL Database - STRING_SPLIT function finally gets a parameter to include position numbers

Databases

How to Fix SQL Server Data Tools (SSDT) 2017 Installation Error - Setup Failed: Incorrect function (0x80070001)

Errors

Azure Data Factory (ADF) - How to Create Offline Documentation (in CSV) for Your Project

Business Intelligence (BI)

SQL Server - How to list the largest tables and indexes in the database and show the size of each

SQL Server - How to identify timeout or interrupted connections using Extended Events (XE) or SQL Profiler (Trace)

SQL Server - Using TRANSLATE() to Replace Multiple REPLACE() Calls

Certification exam practice tests? STAY AWAY FROM THEM!

How to learn SQL / Azure Analysis Services (SSAS / AAS) for free – FOR FREE!

Analysis Services (SSAS)

How to learn Azure Data Factory (ADF) for free - FOR FREE!

Azure Data Factory (ADF)

Power Week has started! 8 TOP Talks on SQL Server, SSIS, Azure Data Factory and Power BI

Events and Talks

SQL Server - How to identify the closest store to the customer (or the distance between 2 locations) from the ZIP code (without API)

SQL Server - How to filter and separate the number and text from a string

Powershell - Script to list and export to CSV all files in a directory with name, directory, size, and duration attributes

SQL Server - How to query the dollar (USD), euro (EUR), real (BRL), or any other currency rate in real time with API and SQLCLR

SQL Server - How to write numbers in full in Portuguese and English using T-SQL function

SQL Server Reporting Services (SSRS) - Frozen and Not Starting: Timeout - The Request Failed or the Service Did Not Respond in a Timely Fashion

SQL Server is extremely fast. You just do not know how to use it!

Black Friday discounts on SQL Server training (Buy my course hahaha)

SQL Server - The new GREATEST and LEAST functions

SQL Server - How to Find the Last Login Date of a User

Azure in Practice Free #07 - Managing Databases on Azure

Events and Talks

Analysis Services - An error occurred while opening the model on the workspace database. Reason: An unexpected error occurred (file 'tmcachemanager.cpp', function 'TMCacheManager::CreateEmptyCollectionsForAllParents')

Analysis Services (SSAS)

Want to learn Azure hands-on? Discover my new "Databases on Azure" training

SQL Server - How to Know How Long a Specific Database Has Been Online

Did I Abandon My Blog???

Connect-PowerBIServiceAccount : Failed to populate environments in settings

Windows 10 - How to Fix Bluetooth Headphone Lag, Stuttering and Audio Cutting Out

SQL Server - How to send the content of a table or query in the body of the email as HTML

Microsoft Certified Trainer (MCT) FREE until September 2020!

SQL Server and Power BI - How to Load Stored Procedure Data in SQL Server with DirectQuery

80% OFF on the New BETA DP-900 Certification Exam: Microsoft Azure Data Fundamentals

Careers, Courses & Certifications

My impressions and study material for the DA-100 - Analyzing Data with Microsoft Power BI (beta) certification exam

Six more live streams I participated in for you to watch about Power BI, Big Data, data careers, MySQL, Postgres, and much more (04/25/2020 to 05/13/2020)

Microsoft Certification - Tips for Taking the Exam at Home Without Headaches

Career, Courses and Certifications

My impressions and study material for the DP-300 - Administering Relational Databases on Microsoft Azure (beta) exam

Three Free Online Events I Will Attend This Week (April 20-24, 2020)

FREE AZ-900 certification exam and beta Azure, SQL Server, and Power BI exams with 80% discount

SQL Server - How to export the content of a column to XML files

Free Online Events I Have Participated in So Far in 2020

How was my talk "I want to work in data. Where should I start?" at the 15th SQL Server ES Meetup

SQL Server - User Can Only Connect with Sysadmin Permission: Login Failed for User, Reason: Login-Based Server Access Validation Failed with an Infrastructure Error

SQL Server - Using STRING_SPLIT to Transform Strings from One Row into Columns

Interview for Live University (01/20) and Big Data live on the Coding Night channel (01/24)

2019 Retrospective and Numbers

Top 10 Technical Articles of 2019 That You Liked Most

SQL Server - Encrypting Passwords with Symmetric Encryption Functions: EncryptByPassPhrase and DecryptByPassPhrase

SQL Server Configuration Manager Disappeared - How to Restore the Shortcut

How was SQL Server ES #14 - SQL Server 2019 and Analyzing Large Data Volumes with Power BI

SQL Server - I set Max Server Memory to 0 and now I cannot connect to the instance

SQL Server - TCP Dynamic Ports vs TCP Port: Dynamic vs Static Port

How was Data Tech Day 4, held in Belém, Pará by SQL Norte

SQL Server - String or Binary Data Would Be Truncated: What It Is, How to Identify the Root Cause and How to Fix It

SQL Server - How to send messages to WhatsApp contacts, groups and broadcast lists via API

How was Power Platform World Tour São Paulo (November 18 and 19, 2019)

Home Office without Guesses - Experiences of those who have worked remotely for more than 1 year

SQL Server - charindexada: A different function to split delimited strings

How to use PowerShell and the API with Agent or SSIS to automate refresh of a Power BI dataset

SQL Server - Power BI Gateway Problem When Using External IP or Hostname to Access the Database

SQL Saturday #906 - Sao Paulo (09/28) - The largest Brazilian event in Microsoft data technologies!

I spoke at the 3rd Petrobras productivity congress with Power BI!

SQL Saturday #900 - Vitoria/ES: A dream that impacted more than 300 professionals and students

SQL Server - How to identify and replace "strange things" (hidden characters) in strings and tables

How I earned 1 MILLION with SQL Server

How to use WhatsApp and Telegram safely and avoid invasions or message leaks

How was the 13th SQL Server ES meeting?

SQL Server - Useful Day-to-Day DBA Queries You Always Have to Search for Online

SQL Server - Avoiding Queries on Specific Columns with Column-Level Security (CLS)

SQL Server - Statements Could Not Be Prepared: Case Expressions May Only Be Nested to Level 10

SQL Server Tools That Every DBA Should Know - Live at SQL Norte

How was Power BI Roadshow - Brasilia 2019

stp_SecurityChecklist - Best Practices and Security Checklist for SQL Server

SQL Server - What Is a Bitwise Operation and How to Store Multiple Values in the Same Column

How was GPDI Data and Tech 2019 in Fortaleza / Ceará

How was the Live on DevelopersBR channel - SQL Server Security - Are you leaving the key under the mat?

SQL Saturday #844 - Belo Horizonte

Power BI - Now I am a Planilheiro!!

SQL Server - Security Checklist - A stored procedure with more than 70 security items to validate your database

How was the 12th SQL Server ES Meetup

SQL Server - How to connect using the DAC (Dedicated Admin Connection) without SQL Browser

SQL Server - Permissions to Use OLE Automation: Yes, the Documentation Is Wrong

How was Global Azure Bootcamp 2019 - Vitória/ES

How was MVPConf LATAM 2019

How was SQL Server ES #11

[Live] - How the webcast "Seven Zomis and One LAW" went - LGPD from the perspective of IT professionals

General Personal Data Protection Law (LGPDP or LGPD) applied to SQL Server databases

ONLINE SQL Server, Power BI and Azure Courses and Training from #TeamFabricioLima: Give your career a boost!

[FREE and ONLINE Event] - On-premises vs Cloud: Advantages and disadvantages (03/14/2019 at 8:30pm)

SQL Server - When You Should Use ORDER BY in Queries and When You Should Never Use It

SQL Server - Understanding the Risks of the TRUSTWORTHY Property Enabled in a Database

SQL Server - How to avoid SQL Injection? Stop using Dynamic Query with EXEC(@Query). Now.

[Live] - Power BI Service vs Power BI Report Server - 02/27/2019 at 8:30 PM

SQL Server - How to identify and collect information from slow queries using Extended Events (XE)

SQL Server - Using Calculated or Computed Columns for Performance Tuning

SQL Server - How to avoid and protect yourself from Ransomware attacks, like WannaCry, on your database server

VMware Player - Using the Independent Nonpersistent Disk Mode

SQL Server - How to avoid brute force attacks on your database

SQL Server Performance Tuning Tips - What Is the Difference Between Seek Predicate and Predicate?

[FREE and ONLINE Event] - 02/07/2019 at 8:00pm - Data Architecture and Governance in BI Projects with Power BI

SQL Server Performance Tuning Tips - Implicit Conversion: Never Again

SQL Server - NOLOCK vs READPAST: Do You Know the Difference Between the Two?

SQL Server 2014 - How to estimate progress and remaining time for index creation

SQL Server - How to identify and change the default schema of database users

[FREE and ONLINE Event] - Power BI Web Scraping - Capturing information from MVPs Brasil - 01/24/2019 at 8:30pm

SQL Server - How to Use Auditing to Map Real Required Permissions for a User

SQL Server - How to identify instance startup parameters using T-SQL

[In-Person Event] - MVPConf LATAM 2019 - April 12 and 13 (São Paulo)

[Online Event] - Roundtable #17 - Relational Databases x NoSQL - Coding Night

SQL Server - What Is the Difference Between @@ERROR and ERROR_NUMBER()?

2018 retrospective - What a year!!

SQL Server Express Challenge - Is It Possible to Exceed the 10 GB Data Limit in a Database?

What changed in SQL Server 2012 regarding T-SQL - from the developers perspective

SQL Server - How to identify the data type of columns and parameters of tables, views, stored procedures, and functions

Power BI - Who are the Microsoft MVPs in Brazil?

SQL Server - How to disable the "sa" login while minimizing impacts

SQL Server Reporting Services (SSRS) - Error Querying Data: There Was a Problem Getting Data from the Report Server Web Service

SQL Server Reporting Services (SSRS) - Which Reports Are Most Accessed and Which Are Not Being Used

How was Microsoft Ignite The Tour (São Paulo) and MVP Get Together 2018

SQL Server - How to hide databases from unauthorized users

SQL Server - How to identify the queries that use a specific index through the plan cache

SQL Server - The Activated Proc dbo.sp_syspolicy_events_reader Running on Queue msdb.dbo.syspolicy_event_queue

SQL Server - How to identify locks, blocks, and blocking sessions

Microsoft Ignite 2018 - The Tour (Sao Paulo) - See you there!

How was Terças de Dados #38 - The Modern and Automated DBA - DBA Brasil

FREE database check-up + security analysis: Do you need it?

Is your SQL Server up to date? Returning the latest Service Pack (SP) or Cumulative Update (CU) version for your instance

SQL Server + AD Authentication - Kerberos + NTLM = Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

How was the 10th SQL Server ES meeting - From Zero to Everything with Tableau and SQL Server

How was the SQL Server 2019 News Live on Canal dotNET?

How was Power BI RoadShow #5 - Vila Velha/ES

SQL Server - How to Use EXECUTE AS to Run Commands as Another User (Impersonate) and How to Prevent It

SQL Server 2016 - How to archive historical tables in Azure with Stretch Database

How was the Microsoft Certifications Webinar in the Data Platform area

Live on Canal .NET - SQL Server 2019 news (11/22/2018 at 9:30 PM)

Video - Power BI vs Reporting Services: Which is better?

SQL Server 2008 - How to encrypt your data using Transparent Data Encryption (TDE)

SQL Server 2016 - How to encrypt your data using Always Encrypted

News - Agenda with ALL Data Platform community events

How was the 1st SQL Server Meetup at Microsoft - Slides and Material

SQL Server - How to change the owner of all jobs for a user in SQL Agent

SQL Server - How to identify data conversion errors using TRY_CAST, TRY_CONVERT, TRY_PARSE, ISNUMERIC, and ISDATE

SQL Server 2019 - Understanding the row estimation changes for table variables

SSRS Reporting Services in Your Company for Free - Meet SQL Server Express with Advanced Services

1st SQL Server Meetup at Microsoft - 10/16/2018 - 7pm (In-person Event in São Paulo)

SQL Server 2019 - List of new features and resources

What changed in SQL Server 2008 regarding T-SQL - From the developers perspective

SQL Server 2012 - How to create data pagination in query results with OFFSET and FETCH

SQL Server - How to Use the MERGE Command to Insert, Update and Delete Data with Just One Command

SQL Server - Using Trace Flag 3226 to Avoid Recording Informational Messages Generated by Backups in the SQL Server Log

SQL Server - How to pass a table as a parameter to Stored Procedures and Functions

FREE and ONLINE Event: Info TI Seminar - 10/20/2018

How was the 9th SQL Server ES meeting (Power BI vs Reporting Services and Performance Tuning)?

SQL Server - How to Use the Management Studio Debugger

9th SQL Server ES Meeting: Power BI, Reporting Services and Performance Tuning – 09/15/2018

SQL Server and Power BI - How to Analyze and Generate Statistics from WhatsApp Group Conversations

SQL Server Reporting Services (SSRS) - How to Log Report Views and Identify Which User Is Accessing

How was the 1st SQL Day - ES?

[Video] - Introduction to SQLCLR

MS SQL Server - A new portal for technical articles and information about events, webcasts and talks

SQL Server - How to create code versioning for your Stored Procedures in HTML with change comments

SQL Server - How to integrate the database with Slack and send messages using Python and sp_execute_external_script

SQL Server - Using CROSS JOIN (Cartesian Product) to Create Rows in the Query Result

SQL Server - How to identify a slow or "heavy" query in your database

SQL Server - How to recover the source code of deleted objects (View, Stored Procedure, Function and Trigger)

SQL Server - How to enable the sa user

Save the date: The 1st SQL Day ES is coming - A full day of learning (08/04/2018)

Congratulations 2018-2019 Microsoft MVP!

SQL Server - Understanding In-Memory OLTP (Hekaton) Tables: Durable vs Non-Durable

SQL Server - How to calculate the distance between two places using latitude and longitude (without API)

How was the 8th PASS Local Group SQL Server ES meeting (Azure CosmosDB)?

SQL Server - Rounding numbers following the ABNT NBR 5891 standard

SQL Server - How to compress and decompress files and directories using 7-zip and xp_cmdshell or SQLCLR (C#)

8th SQL Server ES Chapter Meeting (PASS Local Group of Espírito Santo) – 06/16/2018

SQL Server Express and Developer - How Far Can We Go with the Free Versions of SQL Server?

SQL Server - How to identify deprecated features being used on the instance (Extended Events - XE)

SQL Server - How to capture data from a Web page (Webscraping with HttpRequest) and insert the data into the database with SQLCLR (C#)

SQL Server - How to Use Regular Expressions (REGEXP) in Your Database

HALF A MILLION

SQL Server - How to find how long the instance has been online or when it was started

How was the 7th PASS Local Group SQL Server ES meeting?

SQL Server - How to View the Full Job Execution Return Message Even When It Exceeds 4000 Characters

SQL Server - Study material for the 70-764 Administering a SQL Database certification exam

How was Global Azure Bootcamp 2018 - Vitória/ES

Webcast - 300 posts celebration + SQL Server 2019 News (10/04/2018 - 9PM)

SQL Server - How to standardize the collation of all database columns

Windows 10 - How to Restore the Windows XP / 7 / 8.1 Photo Viewer

SQL Server - How to identify the version and edition of all server instances using xp_regread and PowerShell

SQL Server 2017 - How to pause an index rebuild using Resumable Online Index Rebuilds

SQL Server - Using Resource Governor for Greater Control of Server Resources

SQL Server 2016 - How to protect your data using Row Level Security (RLS)

SQL Server 2016 - How to "travel through time" using Temporal Tables

SQL Server - How to monitor and audit data changes in tables using Change Data Capture (CDC)

SQL Server - Trigger to Prevent and Block Changes in Tables

Microsoft Certifications - Study material in Portuguese to obtain your first certification (MTA)

6th SQL Server ES Chapter Meeting (PASS Local Group of Espírito Santo) - 02/24/2018

SQL Server - How to improve formatting of combined query output with SET STATISTICS IO and TIME

SQL Server - How to create recursive queries with CTE (Common Table Expressions)

SQL Server - Data Masking with Dynamic Data Masking (DDM)

Dev-ES Conference 2017 - 02/12/2017

SQL Operations Studio - The 64-bit Management Studio running on Windows, Linux and Mac

How was the 5th PASS Local Group SQL Server ES meeting?

How to Connect to SQL Server Using PHP (Xampp) and the PDO Driver on Windows

5th SQL Server ES Chapter Meeting (PASS Local Group of Espírito Santo) - 11/11/2017

MCP Professional - How to share your certifications and how to find certified professionals

SQL Server - How to document the database and its objects (tables, procedures, columns) using Extended Property

SQL Server - How to practically share your execution plans on the Web

SQL Server - How to create an email alert for locks and blocked sessions in the instance using DMV's

SQL Server - How to create error and exception monitoring in your database using Extended Events (XE)

SQL Server - Using the FORMAT() Function to Apply Masks and Formatting to Numbers and Dates

How was the 4th PASS Local Group SQL Server ES meeting?

SQL Server groups on Telegram, Whatsapp and Slack: Let's talk about SQL Server?

4th SQL Server ES Meeting (PASS Local Group of Espírito Santo) - 10/07/2017

SQL Server - Introduction to Performance Tuning Study

SQL Server - How to identify and collect information from slow queries using Trace (SQL Server Profiler)

SQL Server - How to generate deadlock history monitoring for routine failure analysis

SQL Server - How to search for a string in the code of stored procedures called by SQL Agent jobs

How was the 3rd SQL Server ES Meeting

SQL Server - Write T-SQL Like a Ninja Using Redgate SQL Prompt

SQL Server - How to read and write events in Windows Event Viewer using CLR (C#)

SQL Server - File Operations Using xp_cmdshell: How to List, Read, Write, Copy, Delete and Move Files

SQL Server - How to query Active Directory (AD) information using Linked Server (ADSI)

SQL Server - How to recover the source code of an encrypted object (WITH ENCRYPTION)

SQL Server - How to identify occurrences of a specific character in a string or table

3rd SQL Server ES Chapter Meeting - 08/26/2017

SQL Server - How to convert an RTF string to text (Remove RTF tags) using CLR (C#) or PowerShell

SQL Server - How to convert an HTML string to text (Remove HTML tags) using CLR (C#)

Analysis Services - How to Use XMLA or PowerShell to Process Cubes and Dimensions via T-SQL or SQL Agent Job

Microsoft MCSA 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Microsoft Excel) free certification exams (beta) until 09/15/2017

SQL Server - Query to Return Active Sessions with sp_WhoIsActive Without Consuming TempDB

SQL Server - How to track Correios packages and items after WEBSRO deactivation

SQL Server - Table-Valued Function to Split a String into Rows with Size Up to N Characters

SQL Server - Audit Trigger for Permissions and Privileges at Database and Instance Level (GRANT / REVOKE)

Microsoft MCSE 70-776 certification exam (Performing Big Data Engineering on Microsoft Cloud Services) for free (beta) until 09/08/2017

How was the 2nd SQL Server ES meeting

2nd SQL Server ES Chapter Meeting - 06/10/2017

Microsoft Certifications - Tips, links and study materials for MCSA and MCSE SQL Server 2016 exams

Microsoft certification exams: 50% discount for students (undergraduate, graduate, master's, doctorate)

Microsoft Certification Exams - 25% Discount for MCP and MCSA Exams

SQL Server 2017 and Azure SQL Managed Instance

SQL Server - How to calculate the difference in years (age) between two dates using T-SQL or CLR

SQL Server - Understanding and Disabling Autocommit

Analysis Services - Querying Catalog Views from SQL Server

Analysis Services (SSAS)

Analysis Services (SSAS) - How to Query Information and Process Commands via XMLA Command Line from SQL Server

Analysis Services (SSAS)

1st SQL Server Community Meeting - ES

SQL Server - Performance Comparison Between Scalar Function (UDF) and CLR Scalar Function

SQL Server - Your Instance Constantly Shows "Starting Up Database" and "Databases in Recovery" Messages: Learn About AUTO_CLOSE

SQL Server - How to export and import tabular data files (for example, CSV) using CLR (C#)

SQL Server - How to query and consume WordPress RSS feeds using CLR or xp_cmdshell (cURL)

SQL Server Management Studio (SSMS) - How to Enable the Dark Theme

SQL Server - How to calculate the distance between two points using the Google API (ZIP code, address, or latitude and longitude)

SQL Server - How to create an Excel-like AutoSum using Window functions (Running totals)

Analysis Services - How to Use XMLA for Backup and Restore of Cubes via T-SQL Command Line

Analysis Services (SSAS)

SQL Server - How to identify and monitor total, free, and used disk space by database datafiles

SQL Server 2016 - How to query ZIP code information using the Bemean API and the JSON_VALUE function

Analysis Services - How to create your first multidimensional cube in the star schema model

SQL Server - Understanding SQL Agent Permissions and Roles: SQLAgentUserRole, SQLAgentReaderRole, SQLAgentOperatorRole

SQL Server - Implementing Access Control and Audit Logs in CLR (C#) Usage

SQL Server - How to Transfer Logins Between Instances Generating Reverse Engineering of Users, Logins and Permissions

SQL Server - How to identify and monitor disks, total, free, and used disk space

SQL Server - How to export a CLR assembly as a DLL and reverse engineer it to C# source code

SQL Server - How to back up all SQL Agent jobs via command line (CLR C# or PowerShell)

SQL Server - How to delete a user from an instance

SQL Server - How to copy/replicate a user's permissions

SQL Server 2016 - Using native JSON support (JSON_VALUE, JSON_QUERY, OPENJSON, FOR JSON, ISJSON, JSON_MODIFY)

SQL Server 2016 SP1 - CREATE OR ALTER in procedures, functions, triggers, and views

SQL Server - Grouping data using ROLLUP, CUBE and GROUPING SETS

SQL Server - How to identify, monitor, and prevent overflow in IDENTITY and SEQUENCE columns of tables with many rows

SQL Server - How to integrate the database with Telegram and send messages using CLR (C#)

SQL Server - How to integrate the database with Slack and send messages using CLR (C#)

SQL Server - How to integrate the database with Ryver and send messages using CLR (C#)

SQL Server - How to send SMS Torpedoes using the CLR (C#) and the Mais Resultado API (PG Soluções)

Microsoft MCSE 70-774 Certification Exam (Perform Cloud Data Science with Azure Machine Learning) for free (beta) until 03/31/2017

Microsoft MCSE 70-775 certification exam (Perform Data Engineering on Microsoft Azure HDInsight) for free (beta) until 03/31/2017

SQL Server - How to rename the server / instance in the database when the machine name is changed in the OS

SQL Server - How to send emails from the database using CLR C#

SQL Server - How to find out when the instance was installed (installation date)

SQL Server - How to send the result of a query by email in HTML format using the CLR (C#)

SQL Server - How to monitor your favorite TV shows by consuming a JSON webservice with JSON_VALUE and CLR (C#)

MCSE 70-773 Certification Exam (Analyzing Big Data with Microsoft R) for free (Beta) until 02/28/2017

SQL Server 2016 MCSA certification exams (70-764 and 70-767) for free (Beta) until 01/31/2017

SQL Server - How to create a Secret Santa draw using Transact-SQL

SQL Server - Msg 443: Invalid Use of a Side-Effecting Operator RAND Within a Function

SQL Server - Using the SQLQueryStress Tool to Optimize Your SQL Queries

SQL Server - Why You Should Not Use SET ANSI_WARNINGS OFF

Reporting Services (SSRS) - Error when deleting mobile reports (Error invoking the authorization extension)

How to Install and Configure Microsoft SQL Server Reporting Services (SSRS) 2016 on Windows Server 2016

SQL Server - How to encrypt and decrypt passwords (with Salt) using CLR (C#)

SQL Server - How to query national, state, municipal, and optional holidays from an API using OLE Automation and CLR (C#)

Useful Things You Can Do with the .htaccess File

SQL Server - How to identify weak, empty, or user-name passwords

Login failed for user error when connecting to SQL Server from a .NET (C#) application

SQL Server - How to integrate with FTP and list, upload, and download files using CLR (C#)

SQL Server - Session Running for a Long Time with the SpreadRequest / DatabaseMail Command

How to Install and Configure Microsoft SQL Server 2016 on Windows Server 2016

How to create a random password generator written in PHP, C# (CSharp) or Transact-SQL (T-SQL)

How to use the Pushbullet API to send SMS messages in C#, PHP, Java or through SQL Server (with CLR)

SQL Server - How to list and kill Windows processes using CLR (C#)

SQL Server - How to run PowerShell and Prompt-DOS (MS-DOS) scripts using CLR (C#)

SQL Server - How to read, list, create, update, and delete Windows Registry keys with CLR (C#)

SQL Server - How to audit permission errors on objects using SQL Profiler (Trace)

SQL Server 2016 MCSA certification exams for free (Beta)

SQL Server - How to export the source code of all Stored Procedures, Functions, Views and Triggers from a database to .sql files

How to validate state registration for all states using C# and SQL Server CLR

SQL Server Reporting Services - Error Saving Report: System.InvalidOperationException - This Implementation Is Not Part of the Windows Platform FIPS Validated Cryptographic Algorithms

SQL Server - How to stop, start, and list Windows services remotely

SQL Server - How to send warnings and error messages to the database using CLR C#

SQL Server - How to Check if a Server is Responding Using Ping and CLR (C#)

How to Compress Directories into ZIP Files Using 7-Zip and CMD

100 Thousand Pageviews

SQL Server - How to create a data change history for your tables (audit logs)

SQL Server - The Data Types Datetime and Time Are Incompatible in the Add Operator

MySQL - How to convert time stored as an integer to a TIME column

CSharp (C#) - How to sort files returned by DirectoryInfo.GetFiles using Natural Sort

SQL Server - Using sp_WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries and Much More

SQL Server - How to concatenate rows grouping data by a column (Grouped concatenation)

SQL Server - How to read, import and export data from XML files

SQL Server - The Server May Be Running Out of Resources or the Assembly May Not Be Trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE

SQL Server - Importing and Exporting Data from Excel Spreadsheets

SQL Server - How to batch run all .sql scripts from a folder or directory with SQLCMD

SQL Server - How to install the Microsoft.ACE.OLEDB.12.0 and Microsoft.Jet.OLEDB.4.0 drivers

SQL Server - How to export database data to a text file (CLR, OLE, BCP)

SQL Server - How to import text files into the database (OLE Automation, CLR, BCP, BULK INSERT, OPENROWSET)

SQL Server - Error Using OPENROWSET: Access to the Remote Server Is Denied Because No Login-Mapping Exists

SQL Server - Cannot resolve the collation conflict between ... in the equal to operation.

SQL Server - How to resolve the Warning Null value is eliminated by an aggregate or other SET operation

SQL Server - Heterogeneous Queries Require the ANSI_NULLS and ANSI_WARNINGS Options to Be Set for the Connection

Analysis Services - Deserialization Failure: The 'AllowedRowsExpression' element in namespace

SQL Server - How to list, read, write, copy, delete and move files with CLR (C#)

SQL Server - How to perform UPDATE and DELETE with TOP x records

SQL Server - The Danger of Using JOIN Between Columns of Different Data Types

Using Sequences in User-Defined Functions in SQL Server

SQL Server 2012 - Working with Sequences and comparisons with IDENTITY

SQL Server - Querying Instance Information from Windows Registry Using sys.dm_server_registry and xp_instance_regread

Using the Default SQL Server Trace to Audit Events - fn_trace_gettable()

SQL Server - The Database Owner SID Recorded in the Master Database Differs from the Database Owner SID Recorded in Database

Monitoring DDL and DCL operations using SQL Server fn_trace_gettable

Monitoring automatic space growth (Autogrowth) events in SQL Server databases

SQL Server 2016 - List of new features and resources

How to retrieve the greatest value among multiple columns in a SQL Server table

How to find the last access date of a table or view and the last execution of a stored procedure in SQL Server

CLR - Solving the System.Security.Permissions.FileIOPermission problem in SQL Server

Visual Studio - Solving the sgen.exe / .NET Framework SDK Build Error

Performing POST and GET requests using CLR (C#) in SQL Server

How to List Jobs (schedules, commands, steps) via Query in SQL Server

Introduction to SQL CLR (Common Language Runtime) in SQL Server

How to Fix the Duplicate MAC Address Problem in VMware

What is the difference between IT higher education degrees?

Querying Correios object tracking through SQL Server

How to split a string into a table of substrings using a delimiter in SQL Server

Consuming the Google Maps API to get address or ZIP code information in SQL Server

Happy 2016!

How to reset and recover the SQL Server Administrator (sa) password

Links to download Microsoft Visual Studio 2015 and SQL Server 2014

Valid CPF and CNPJ generator for SQL Server environment testing