Posts Archive

In this article

See below for the complete list of blog posts to make it easy to find a specific post.

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

Speak up guys! In this article I would like to share with you a free study material for the DP-900 Microsoft Azure Data Fundamentals certification exam. This is your chance to have a material that will make you pass the exam without too many difficulties and get your Microsoft Certified: Azure Data Fundamentals certification...
Read More

Azure Data Factory (ADF) - How to change the Service Objective and resize an Azure SQL Database using T-SQL commands

Hey guys! In this post I bring you a simple solution, but I really liked it, because it helped me to greatly reduce the processing time of an Azure Data Factory (ADF) pipeline by changing the Service Objective and resizing an Azure SQL Database using T commands -SQL before processing starts, and reverting back to the original tier when ...
Read More

SQL Server - How to synchronize data from a table between different databases using Trigger

Speak up guys! In this post today I'm going to bring a very simple solution, but it solved a problem of a person who asked me for help to synchronize data from a table between different bases, in the same instance, in the simplest way possible, where you insert, update or erases data from the source table and all changes are replicated to...
Read More

Online Event – ​​Database Tips for Developers – SQL Server, PostgreSQL, MongoDB and more!

Speak up guys! I would like to invite you all to another FREE ONLINE event of Canal .NET, where we will demonstrate useful tips, tools, frameworks and solutions in the development of applications that work with database technologies We will address SQL Server, PostgreSQL, MySQL, MongoDB and much more! Event Date 20/07/2022 at 21pm Registration link: https://www.meetup.com/dotnet-sao-paulo/events/286979781/ Speakers already ...
Read More

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

Speak up guys!! In this post I will share some lives I participated where we show how to version and deploy models and reports in Power BI using Azure DevOps. This knowledge is essential today, as it brings us a series of benefits in the development cycle of data projects: Possibility of having different environments for development, testing and production, where the ...
Read More

Live – PostgreSQL, MySQL, MariaDB, Managed Instance and Cosmos DB: Managing PaaS Banks Beyond Azure SQL Database

Speak up guys! The use of databases in the Microsoft cloud goes far beyond Azure SQL Database: We also have alternatives such as PostgreSQL, MySQL, MariaDB, Azure Managed Instance and also multimodel NoSQL solutions such as Cosmos DB. In this live, you will learn the basics of database administration and avoid common mistakes made by professionals with no experience in this...
Read More

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

Speak up guys! Do you work in the Data area? Or are you even a Developer, DevOps Professional or SysAdmin who is interested in technologies in this segment? Would you like to deepen your knowledge about Azure services and different database technologies? Follow this new ONLINE and FREE event from the Coding Night channel (roundtable #102) and learn more at...
Read More

New Microsoft Certified Fundamentals portal for those looking to get their first certification

Speak up guys! TODAY, 01/06/2022, Microsoft has released a new portal focused on foundations certifications, made exclusively for the community of students looking to earn a Microsoft foundations certification...
Read More

SQL Server - How to validate email and email domain using SQLCLR (C#)

Introduction Hey everyone! I imagine that at some point, you must have had to check one or more emails on SQL Server, to see if the email is valid. You must have already thought about validating the email domain, to know if the domain is valid. I'm not referring to whether the domain was typed correctly and doesn't have...
Read More

Voucher to take a FREE Microsoft certification exam – including the Power BI PL-300!

Speak up guys! I would like to share with you a very cool event that Microsoft is promoting, which is the "Microsoft Build Cloud Skills Challenge | May 2022", which starts TODAY, 24/05/2022 and is giving away FREE vouchers for you to take a test Microsoft certification...
Read More

SQL Server - How to unlock a login without having to change/reset the password

Speak up guys! In this article I wanted to share with you a simple solution to unlock a user without having to change/reset the password, which can sometimes be very annoying when having to change a user's password so that he logs back into the bank...
Read More

SQL Server - Password Policies, Password Expiration, Mandatory Password Change, and Login Lockout after N attempts

Speak up guys! In this post I'd like to talk about the SQL Server Security part focused on passwords: Password Policies, Password Expiration, Mandatory Password Change and Login Blocking after N attempts...
Read More

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

Speak up guys! I would like to formally share here on the blog, a live I did at the end of last year, with my friend and great professional, Eduardo Cerqueira, for the MVPConf 2021 event. I was very happy to participate in another edition of MVPConf, my 3rd edition speaking . A big thank you to Renato Groffe and Vinicius Moura for inviting me to speak...
Read More

Invitation to the Live “Is going to college important in the area of ​​technology?” – May 20th at 05pm

Speak up guys!! I would like to invite you all to a great Live that we will do with the theme "Is going to college important in the area of ​​technology?", which will be held on May 20, 2022, at 20:00 pm, on UniversoTi's Youtube channel . We will have great speakers from real life and certified by Microsoft, among them: Renato Groffe - Developer ...
Read More

Live #45: Best Practices in Database Administration in Azure (17/05 at 21pm)

Speak up guys! In this post I would like to invite you all to a live TODAY (17/05), at 21 pm, on the Azure channel in Practice on Best Practices in Database Administration in Azure. It will be a free class on smart ways and everyday tips on how to manage relational databases and you will also have the opportunity to ...
Read More

SQL Server - How to speed up your queries by changing server power setting

Speak up guys! In this post I would like to share with you how to speed up your queries by changing the server power setting...
Read More

TOP 25 best SQL blogs in the world!

What's up guys!! In this post I bring a "new thing" that I ended up forgetting to share with you, which is the inclusion in my blog "dirceuresende.com" in the FeedSpot list of the 70 best SQL blogs in the WORLD, representing our Brazil and occupying the 23rd position in the list! ...
Read More

Azure SQL Database - How to create and manage users and logins with SQL authentication and Azure Active Directory (Azure AD)

Speak up guys! In this post I would like to share with you how to create and manage users and logins. I will explain what is the Azure Active Directory admin user/group, what is the admin server, how to create it and what are the differences between a login created in the instance and a user created in the database. It is worth remembering that the Management Studio interface is still ...
Read More

SQL Server – ISNULL x COALESCE: Knowing the Differences Between the Two Functions

A very common mistake among SQL developers is about the differences between ISNULL and COALESCE functions, where the vast majority of people believe it's just the fact that the ISNULL function allows only 1 input parameter to do the null value analysis, while the function COALESCE allows you to pass N input parameters. However, there is another...
Read More

SQL Server and Azure SQL Database - How to return CPU and Memory usage using T-SQL

A very common day-to-day need for a database administrator is to analyze the instance's CPU usage. For this reason, I will share in this article, a Transact-SQL (T-SQL) query to get this information from a SQL Server 2008+ database or Azure SQL Database. While it is possible to obtain CPU usage using graphical tools, many times...
Read More

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

How to identify the query that triggered a DML trigger on a table? I read this question in a Telegram group and decided to write an article about it...
Read More

SQL Server - How to identify and monitor the execution of triggers

In an environment with many triggers being fired, it is often necessary to be able to identify and monitor the execution of triggers to analyze a certain behavior or understand how data is being changed. This ends up getting even more complex when a trigger changes data from another table(s) and multiple triggers are fired in sequence, nested, from a single...
Read More

SQL Server – Beware of server role securityadmin! Using privilege elevation to become sysadmin

Speak up guys! In this post I would like to share with you an extremely dangerous situation that can end up going unnoticed by most SQL Server DBA's, which is the use of the securityadmin role or the ALTER ANY LOGIN and IMPERSONATE ANY LOGIN permissions without understanding exactly what they are for and what that someone with these permissions can do...
Read More

SQL Server and Azure SQL Database: How to Identify Key Lookup occurrences through the plancache

Speak up guys! In this article I would like to share with you a Kendal Van Dyke script to identify/find Key Lookup occurrences through the plancache, which can be very useful to easily identify possible good candidates for a performance analysis. As you know, KeyLookup occurrences usually have a very big performance impact and can be easily...
Read More

Azure SQL Database - How to view automatic backup history

Speak up guys!! Today (13/04) a novelty was announced in Azure SQL Database, which is Azure SQL DB Backup History, which arrives as Preview. This feature is a new DMV that has been made available in Azure SQL DB to allow you to view the execution history of automatic backups, which was a very common question among DBA's and...
Read More

SQL Server - How to identify all missing indexes (Missing indexes) of a database

Speak up guys! In this post, I would like to share with you a script to identify all Missing indexes of a database in SQL Server, Managed Instance or Azure SQL Database. Remembering that for the execution of this script, you will need the "View server state" permission on the instance. I had already shared this script in the articles Understanding...
Read More

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

The use of different data and technologies are common practices in several areas, as they contribute to strategic and more agile actions in companies. The union of Marketing and IT, for example, adds many benefits, improving the use of technological equipment and systems, as well as the way of dealing with information and access, bringing more efficient flows and more effective strategies...
Read More

Black Friday discounts for Database courses on Azure and SQL Server!

Hello guys! Already in the mood of Black Friday, I would like to announce that my course in Azure Bank Administration, taught in Azure in Practice has undergone some changes and is now called Database Training in Azure, where we will be conducting live classes, answering questions in Whatsapp groups and doing a kind of mentoring of students...
Read More

Azure SQL Database – STRING_SPLIT function finally gets parameter to include number of positions

Speak guys!! I would like to share with you a really cool news that I noticed in Azure SQL Database, which was the inclusion of a new parameter in the STRING_SPLIT function and that has been requested since the function was created in SQL Server 2016, which is the inclusion of the number of positions in the return of text breaks...
Read More

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

Hello guys! In this post, I would like to share how to resolve an error installing SQL Server Data Tools (SSDT) ​​2017 - Setup Failed: Incorrect function (0x80070001), which happens to me frequently whenever I try to install SQL Server Data Tools 2017 version on some computers...
Read More

Azure Data Factory (ADF) – How to create offline documentation (in CSV) of your project

Hello guys! In this article, I'd like to share with you a Powershell script to create a documentation of your project offline (in CSV) in Azure Data Factory, a very common need people have, especially to list and track source datasets in a form. easy, and also list the Integration Runtimes (IR), Dataflows, Linked Services, Pipelines and Triggers...
Read More

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

Hello guys! In this very quick post, I would like to share with you a simple script, showing how to list the largest tables and indexes in the database and return the size of each table and each index, and can also list the objects of all databases of your instance SQL Server...
Read More

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

Hello guys! The theme of today's post is timeout, which consists of a timeout (usually measured in seconds) in which an operation will wait until it forcibly terminates execution, if this timeout is reached. The purpose of this post is to show you how to identify timeout or broken connections using Extended Events (XE) or SQL Profiler...
Read More

SQL Server – Using TRANSLATE to replace multiple REPLACE

Hello guys! In this quick post here, I'd like to share with you some use cases of the TRANSLATE function, available since SQL Server 2017, which can help replace multiple REPLACE commands with just one TRANSLATE command, greatly reducing code size and complexity. Spoiler: Do you use a version before 2017? Calm down. There is a way for everything 🙂 ...
Read More

Certification exam simulations? RUN AWAY FROM THEM!

Hello guys! In this post I would like to talk to you about certification exam "simulations", which promise to have questions similar to the certification exam and serve as a study guide for those who are studying and can be a great risk to your career and the whole technical community, with severe punishments for those who use these...
Read More

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

Hey guys!! In another quick post, I would like to share with you some materials to learn about SQL / Azure Analysis Services (SAAS / AAS) without paying anything - FOR FREE! If its an excuse to learn about this semantic and processing layer, which allows you to use datasets with BILLIONS of rows in few...
Read More

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

Hey guys!! In today's quick post, I'd like to share with you some materials to learn about Azure Data Factory (ADF) for free - FREE! If your excuse for learning the most promising ETL/ELT tool on the market was the cost of courses/trainings, now it's over! For those who don't know, Azure Data Factory is...
Read More

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

Speak guys!! I'm stopping by to invite you all to Power Week! An event organized by PowerTuning, the biggest reference in Brazil in the area of ​​SQL Server and Power BI. This event will consist of 8 lectures, given from Monday to Thursday, starting at 19:00 and ending around 22:28. I will speak TODAY (06/20) at 30:XNUMX pm, with the theme "Getting to know ...
Read More

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

Speak guys! In this very interesting article, I'm going to share with you a very creative solution to identify the store closest to the customer from that customer's zip code, without using an API. All the "magic" is in the fact that the zip code seems to be calculated according to the distance from that location and because of that, finding the nearest store...
Read More

SQL Server – How to filter and separate the number and text of a string

Speak guys! In this article, I'm going to share with you a series of options to filter and separate the number and text of a string using T-SQL functions and commands in SQL Server, which is a very common need in the daily lives of those who develop SQL queries several or want to validate the data of some table...
Read More

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

Speak guys! In this very simple article, I'm going to share with you a script that I developed to meet a very common need in the daily lives of those who create courses and training, which is to create a spreadsheet or CSV file, containing the list of videos, size and duration of each video, so as to maintain the folder structure for...
Read More

SQL Server – How to consult the dollar (USD), euro (EUR) or any other currency in real time with API and SQLCLR

Speak guys! In this post today, I'm going to share with you a solution I developed to query the dollar (USD), euro (EUR), real (BRL) or any other currency in real time (almost) using a WebService (API) and SQLCLR on SQL Server. This can turn out to be very useful depending on your area of ​​expertise and it's something I see...
Read More

SQL Server – How to write a full number in Portuguese and English using T-SQL function

Speak guys! On 07/04 I saw a question in a Whatsapp group about the possibility of SQL Server has a native function to write numbers in full, which doesn't exist. I started looking for some T-SQL functions on the internet that do this and I just managed to find a function that can meet this objective and I would like to share it with...
Read More

SQL Server Reporting Services (SSRS) crashed and does not start (timeout): The requested failed or the service did not respond in a timely fashion

Hey guys !! In this very quick post, I would like to share with you a case that occurred to me during my day to day work. Users were reporting that SQL Server Reporting Services (SSRS) was stuck, not allowing connections. I did an access test quickly and identified that the portal screen was loading and then gave an error ...
Read More

SQL Server is extremely fast. You who don't know how to use it!

Hey guys! TOMORROW, 29/04, starting at 21:00 pm - Brasília time - we will have another FREE and ONLINE event on the .NET Channel. And part 6 of the live arrived that ended up becoming a series! In response to several requests from people who watched the previous live, part 6 of this live has arrived, which aims to disseminate and share tips ...
Read More

Black Friday discounts on SQL Server Trainings (Buy my kkkkk course)

Personal Talk, The PowerTuning Manager has gone crazy !!! Enjoy the last days of the month of discounts for Power Tuning courses. It's your opportunity to reset the platform's courses and study hard to hit the market in 2021. Vouchers will be valid until 30/11/2020, so hurry up and guarantee your favorite course now (buy my course, ...
Read More

SQL Server - The “new” GREATEST and LEAST functions

Hey guys !! In this post I would like to bring a new feature that is already available in Azure SQL Database and I believe that soon, it will be available in SQL Server On-premises too, which are the "new" (For those who already work with other banks, this function is well known and has been available for many years) GREATEST and LEAST functions, which ...
Read More

SQL Server - How to know the date of a user's last login

Hey guys! In this post, I would like to bring you a solution on how to know the date of a user's last login to SQL Server, which is information that I often see someone wanting to know how to obtain, especially to identify the users who access the environment or not , to make data mappings and / or exclude users who are not ...
Read More

Azure in Free Practice # 07 - Administering Databases in Azure

Hey guys !! Are you looking for a new job or to boost your career, learning high technology? How about taking advantage of this moment when we are all at home, doing a FREE and ONLINE training on DATABASE ADMINISTRATION AT AZURE ??? What we will learn in this Azure SQL Database mini-course - Overview - Resource creation - DTU vs ...
Read More

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

Hey guys !! In this post I would like to share with you a problem (and the solution) that I had at work when I was trying to open the .BIM file for an Azure Analysis Services tabular cube project in Visual Studio 2019 and I came across the error message " An error occurred while opening the model on the workspace database. Reason: ...
Read More

Want to learn Azure in Practice? Meet my new training “Databases in Azure”

Hey guys! All right with you? Today I bring a very cool new feature, which is my new Database course in Azure, which I will be teaching for Azure in Practice. It will be a very complete training on MySQL, SQL Server and PostgreSQL running as PaaS on Azure. I will address several themes and modules within these DBMS's, in addition to ...
Read More

SQL Server - How to know how long a specific database has been online

Hey guys! In this post today, I would like to share a solution that I created to answer a question in one of the Telegram groups in which I participate, which was the question of how to know how long a database has been online in SQL Server. This is not how long the instance has been online, but how long a database ...
Read More

I abandoned my blog ???

Hey guys !!! I hope everything is fine with you! I believe that whoever follows me here on the blog must have noticed that I have been missing a lot in the last few months here on the blog. For those who have maintained an average of 80 posts per year since 2016 (1 post every 4,5 days) and have 18 posts in 2020, which is already close to ...
Read More

Connect-PowerBIServiceAccount: Failed to populate environments in settings

Introduction Speak personal !! In this post, I would like to demonstrate to you the solution to a problem that happened to me a few days ago, when the routine of automatic updating of the Power BI data set (How to use PowerShell and the API with Agent or SSIS to automate the updating a Power BI dataset) has stopped ...
Read More

Windows 10 - How to solve Bluetooth headset problem with lag, crashing and cutting audio

Hey guys! Yes, you are on my blog and you are seeing Windows content .. rs Today's post aims to change the lives of many people, just as my life improved a lot after I discovered how to solve a problem with a bluetooth headset failing and cutting the audio, which is something that has bothered me for ...
Read More

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

Hey guys !! In this post I come to bring a solution to a problem that almost every day I see in Whatsapp and Telegram groups: Send the content of one or more tables or queries in the body of an email as HTML. The procedure we are going to use in this post to take the contents of the table and transform it to HTML I ...
Read More

Microsoft Certified Trainer (MCT) FOR FREE until September 2020!

Personal Faala !! I would like to use this post to bring news to those who are STILL unaware: From April 10, 2020 to September 30, 2020, the enrollment and renewal of the $ 350 Microsoft Certified Trainer is DE GRACE!! That's right, free of charge! With that, Microsoft is democratizing the ...
Read More

SQL Server and Power BI: How to load Stored Procedure data into SQL Server with DirectQuery

Introduction Speak up! In this post I would like to share with you a situation that happened to me during a consultation with a client, where he had a need to have a Power BI report connected to a SQL Server database, but the data source was a Stored Procedure that did several data transformations internally and returned ...
Read More

80% DISCOUNT on the new DP-900 certification BETA test: Microsoft Azure Data Fundamentals

Hey guys! In this post I would like to share with you the fact that the NEW BETA DP-900 certification test: Microsoft Azure Data Fundamentals is 80% off for the first 300 people using this voucher. We will take advantage of this discount and the fact that we are in quarantine to study, improve our skills and the curriculum. Remembering that the evidence ...
Read More

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

Hey guys! On Saturday, May 09th, I took the beta test "DA-05 - Analyzing Data with Microsoft Power BI (beta)", which is focused for business analysts and report / dashboard creators in Power BI, replacing the 100- 70 and 778-70 (yes, it is now only 779 test) and I wanted to share my impressions about the test and some study materials. Before ...
Read More

6 more lives I participated for you to watch on Power BI, Big Data, Data Careers, MySQL, Postgres and much more (25/04/2020 to 13/05/2020)

Hey guys! These last 3 weeks were a lot of work and several events where I participated and I believe that I managed to generate a lot of free and high quality content for you. I participated in six lives and would like to share with you, so you can watch if they are of interest to you, where it was covered about Power BI, QlikSense, Tableau, Big Data, ...
Read More

Microsoft Certification - Tips on how to take the test at home without a headache

Hey guys! On the holiday of 01/05, I took the beta test "DP-300 - Administering Relational Databases on Microsoft Azure", which is focused on DBA's who work or want to work with Azure and wanted to share tips to do a quiet test at home, especially because of COVID-19. The first challenge for this test was to perform the exam at home by ...
Read More

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

Hey guys! On the holiday of 01/05, I took the beta test "DP-300 - Administering Relational Databases on Microsoft Azure", which is focused on DBA's who work or want to work with Azure and wanted to share my impressions about the test and some study materials . First of all, if you want tips on how to take certification exams at home ...
Read More

Three FREE and Online Events that I will participate this week (20/04/2020 to 24/04/2020)

Hey guys! This week has already started with several appointments and a lot of free content for you. As I will participate in 3 lives this week, I decided to create a post just to publicize the three. 20/04 at 18:30 pm - PowerLive on Career Ready for a Power Live? ⚡ The MVP's, Fabrício Lima, CEO of Power Tuning, and Dirceu Resende, BI Consultant, will make a ...
Read More

AZ-900 certification test FOR FREE and beta tests of Azure, SQL Server and Power BI with 80% discount

Hey guys! In this post I would like to share with you the AZ-900 test, which is FREE, and some of the data area are in the Beta phase (80% discount). We will take advantage of these discounts and the fact that we are in quarantine to study, improve our skills and the curriculum. Remembering that the tests can be done ONLINE and ...
Read More

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

Hey guys!! On Thursday (09/04), I saw a very cool question in the Telegram SQL Server group - DBA, the largest group of DBA's and SQL Server Developers in the world, where the person had a table in the bank, where a column was from type XML, and he would like to export to the disk, each row of that table as an XML file ...
Read More

Online and Free Events I attended so far in 2020

Hey guys! After a long time without posting anything here, I am slowly returning, adapting to the various changes that are occurring in my life, including a change of country, and that is why it has been a little complicated to maintain the pace that I usually have here in posts, but I'll be right back "I'll take this article to ...
Read More

How was my lecture “I want to work in the data area. Where to start? ” at the 15th SQL Server ES Meetup

Hey guys! On 06/02/2019, I participated in the 15th SQL Server ES Meetup as the event organizer and also speaking with the theme "I want to work in the data area. Where to start?", Together with my friend Elisa Torres, who made her first lecture in the "SQL Server ES" community and it debuted in style: It made an excellent presentation and we hit ...
Read More

SQL Server - User only connects to the instance with sysadmin permission - Login failed for user 'teste'. Reason: Login-based server access validation failed with an infrastructure error

Hey guys! In this post, I would like to share an error that was reported in a Whatsapp group and that I personally had never seen before, which was the error message below and the report that users who used SQL authentication could only connect to the instance if they had sysadmin privileges. Login failed for user 'test'. Reason: ...
Read More

SQL Server - Using STRING_SPLIT to transform strings from a row into columns

Hey guys !! In this article I would like to bring a scenario that I am asked from time to time about how to solve, which is to transform strings from one row to columns, widely used for accounting accounts or cost center, for example, which was exactly the situation I was asked for. help for about 10 days and I decided to take some time to write ...
Read More

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

Hey guys! I hope everything is fine with you. Interview for Live University In this post, I would like to publicize an interview, conducted by Raffael Bilinski and that I had the privilege of participating on 20/01, for the Live University blog on "SQL Banks, because they are still one of the most used" , I could explain a little more about the language ...
Read More

Retrospective and Numbers 2019

Hey guys!! Last post of 2019 and can be no different: Retrospective. This year was an EXCELLENT year from a professional and technical point of view, although it was not good at a personal level. So I'll make a summary of everything that happened this year and come on! Looking coldly at just the numbers, I can say that 2019 was a year ...
Read More

TOP 10 2019 technical articles you liked best

Speak guys !! New Year's Eve coming up, everyone getting ready for New Year's Eve and so I would like to share with you the "TOP 10 Technical Articles of 2019 that you liked best", that is, the articles I published in 2019 and which you most viewed . I hope you enjoy this short list and that some article can be helpful ...
Read More

SQL Server - Encrypting passwords with the symmetric encryption functions ENCRYPTBYPASSPHRASE and DECRYPTBYPASSPHRASE

Hey guys!! In this article, I would like to share with you a very interesting solution to protect and encrypt passwords in SQL Server that have the possibility of recovering the original password (as long as you know the salt used), which are the ENCRYPTBYPASSPHRASE and DECRYPTBYPASSPHRASE functions available since SQL Server 2008. Do you like to study password security and ...
Read More

Is SQL Server Configuration Manager gone? Learn how to recover the shortcut

Hey guys!! In this very quick, objective and short post, I'll share a tip to open SQL Server Configuration Manager when you can't find its shortcut at all. From time to time, I will go into some client environment and when I try to find SQL Server Configuration Manager (that tool for configuring SQL services) and not ...
Read More

How was SQL Server ES # 14 - SQL Server 2019 and Analyzing big data with Power BI

Hey guys! Last Thursday, 19/12, we held the 14th SQL Server ES Meetup (which is no longer an exclusive SQL Server event for a long time .. rs), held at Brooder - Innovation Hub, where Fabricio Lima and Luiz Lima showed the news of SQL Server 2019. Also, the people could watch my talk with Leandro ...
Read More

SQL Server - I changed Max Server Memory to 0 and now I can't connect to the instance

Hey guys! In this post I would like to share with you the solution of a problem that is even common to happen and from time to time someone comes up in the Whatsapp and Telegram groups with this problem, which is incorrect setting of the Max Server Memory parameter, setting a value too low and as a result you can no longer get ...
Read More

SQL Server - TCP Dynamic Ports vs TCP Port (Dynamic vs. Static Port)

Introduction Speak guys !! In this article I would like to share with you what I explained in a Telegram group, which is how SQL Server dynamic ports work, which many people have the misconception of how it works. While some people find that SQL Server has assigned a new port each time the service is ...
Read More

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

Speak guys !! Last Saturday (07 / 12) I was in Belém do Pará to speak at the Data Tech Day 4 event, the largest data event in northern Brazil. The event was organized by Wiluey Sousa, Renata Cascaes, Sandro Cascaes, Sérgio Passos and Cássia Queiroz. Data Tech Day 4 has entered the history of Northern Brazil, bringing innovation and technologies ...
Read More

SQL Server - String or binary data would be truncated: What is, how to identify root cause and how to fix

Hey guys! In this article, I want to explain to you exactly what the message "String or binary data would be truncated" means, how we can identify which string is causing the error, how to hide this error message (if you want), what the The change in sys.messages has impacted this theme from SQL Server 2016 + and more! So ...
Read More

SQL Server - How to send messages to Whatsapp contacts, groups and mailing lists via API

Hey guys! In this article, I'll share with you a solution I've been looking for a long time ago, which is how to send messages to Whatsapp contacts, groups and broadcast lists using WebRequests. I had done something similar using other tools, but never Whatsapp, which does not have an official API and is completely closed on that. Although ...
Read More

How was the Power Platform World Tour Sao Paulo (18 and 19 November 2019)

Hey guys! For those who follow me on social networks know that last week I attended the Power Platform World Tour São Paulo event, one of the largest Power BI events in the world (in addition to Power Automate and Power Apps). It was really an honor to have attended an event so well organized by MVP Pablo Peralta and other members ...
Read More

Home Office without Guesswork - Experiences of remote workers for over 1 year

Introduction Speak guys! For those who follow me on social networks, I should have seen a short post talking about MY view of the advantages and disadvantages of working on the 100% home office (remote) scheme. As this is a very relevant subject and I believe to be the future of various professions, I decided to deepen my analysis and spread this ...
Read More

SQL Server - Charindex: A Different Function to Break Split Strings

Hey guys! A little over 5 years after sharing with you the Split function code, which allows you to retrieve a part of the string broken by a delimiter, this time I come to share a new function, called charindexada, written by Brunno Araújo and kindly gave me the " copyright "to share it here on the blog. Interested in learning more about ...
Read More

Using PowerShell and the API with Agent or SSIS to Automate Updating a Power BI Data Set

Introduction Speak guys! In this article I am sharing with you, I would like to help you with a very common BI problem and need to update Power BI reporting data automatically more than once a day. Usually I see many scenarios where the BI team creates the automatic routine to update the data in the database.
Read More

SQL Server - Power BI Gateway issue using external IP or hostname to access database

Hey guys! In this post, I would like to share with you a situation that I have witnessed in some 4 clients in the last 3 months and always have to explain the same thing when users access the bank using an external IP or hostname, created so that users can connect to these data sources being outside the corporate network ...
Read More

SQL Saturday # 906 - São Paulo (28/09) - The biggest event in Brazil on Microsoft technologies in the data area!

Speak guys !! This week is starting very busy and on Friday I will be leaving for Sao Paulo, because on Saturday of 28 / 09 / 2019 I will be speaking at SQL Saturday #906 - Sao Paulo 2019, Brazil's largest Microsoft technologies event in the area of Dice! There will be 42 lectures, divided into 6 trails, with most of the best known experts in the field ...
Read More

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

Hey guys! In this post I would like to share with you my happiness to have the privilege of lecturing at the 3º Petrobras Power BI productivity congress, held yesterday (17 / 09) at EDICIN (Petrobras University), in Rio de Janeiro. It was a unique experience to be able to talk about Power BI Report Server to these great professionals, from the most diverse areas and in ...
Read More

SQL Saturday # 900 - Vitória / ES: A dream that impacted over 300 professionals and students

Speak guys !! Sorry for the rush of the last months, but it's hard to find time to post ... lol On 24 / 08 / 2019 we had another historic event in Espírito Santo. After SQL Day ES, which we organized last year and had 450 subscribers and 250 present, we were finally able to bring a global technology event to ES, SQL Saturday Vitória, ...
Read More

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

Hey guys! In this article I would like to share a situation that happens from time to time in my day to day consultancy, serving a number of different clients and environments, and that on Friday came back, that is when there are "weird things" in strings and tables (an allusion to the series "Stranger Things"), which is the occurrence of non ...
Read More

How I Got 1 MILLION with SQL Server

Hey guys! Today I would like to dedicate all this post to thank each of you who have visited, liked, commented and / or shared any of my articles. It's thanks to you that a lot has changed in my life over the last 2 years, especially on my blog, where I've been writing mostly about SQL Server since April of 2015. For me it is ...
Read More

Using Whatsapp and Telegram Safely and Avoiding Chat Intrusion or Leakage

Hey guys! In this article, which has nothing to do with SQL Server, I would like to share with you some VERY SIMPLE ways of using Whatsapp and Telegram SAFE and not being a victim of intrusions, as we are observing all the time in every newspaper. and news sites in Brazil, as several authorities ...
Read More

How was the 13 SQL Server ES meeting?

Hey guys! On 18 / 07, I had the honor of participating in the organization of the 13 SQL Server ES Meeting. At this event, we met for the first time at Pag !, which could be the beginning of a great partner of our technical community of Espírito Santo. At this event, we enjoyed the visit of SQL Server expert, Rodrigo Ribeiro Gomes, who lives in ...
Read More

SQL Server - Useful DBA Queries You Always Have to Look for on the Internet

Hey guys! In this article I would like to share with you a number of useful DBA day-to-day scripts that you always have to look for on the Internet when you need to make a particular query. My idea here is to make your life easier and have a multi-purpose article for you to bookmark in your browser and ...
Read More

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

Hello people! In this article I would like to demonstrate a very old feature (available since SQL Server 2005 - or earlier) that few people use or know exists, which is Column Level Security (CLS) or Column Level Security. Unlike Row Level Security, where the user views all columns but only a few rows, in the ...
Read More

SQL Server - Statement (s) could not be prepared. Case expressions may only be nested to level 10

Hey guys! In this article I would like to share with you a question that was sent to a Whatsapp group, which referred to the error message below when an analyst was trying to build a CASE with more than 10 conditions on a SELECT: Msg 8180, Level 16, State 1, Line 1 Statement (s) could not be prepared. Msg 125, Level 15, ...
Read More

Tools for SQL Server that every DBA should know - Live at SQL Norte

Hey guys! Today I had the honor of participating in an edition of the well-known Quintas with Acai and Data, organized by the people of SQL North, with the theme "Tools for SQL Server that every DBA should know". help DBA in her daily life and I was able to test unusual tools or ...
Read More

How was the Power BI Roadshow - Brasília 2019

Hey guys! In this post I would like to share with you a great joy, which was having the pleasure of speaking again at PowerBI Roadshow, this time in Brasilia - DF, with the theme "PowerBI: Cloud vs On-Premisses". I would like to thank Ruy Lacerda and Fernando Garcia for the invitation, as well as Fabricio Lima, for releasing me to participate in this ...
Read More

stpSecurity_Checklist - Best practices and security checklist for SQL Server

Hello guys! This is a special post for me, because it's my first post in English here in my blog. The main goal of this post is to share and show how to use the stpSecurity_Checklist Stored Procedure to perform a complete security checklist on your SQL Server instances. After a big change in my original SP (SQL Server - ...
Read More

SQL Server - What is bitwise operation and how to store multiple values ​​in the same column

Hey guys! In this article, I will show you what bitwise operation is available since SQL Server 2005, and how to store multiple distinct values ​​in the same column, which may even have value matching without the need to create a N: N table. to store the combinations. I've seen on some systems this approach of using bitwise operations ...
Read More

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

Hey guys! In this post I would like to share with you the photos and materials of my presentation at GPDI Data and Tech 2019 in Fortaleza / Ceará, organized by Rafael Mendonça. And it was a pleasure to meet this angry guys from GPDI and Fortaleza. It is always a pleasure to share knowledge about what we like and try to bring some ...
Read More

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

Hey guys! Yesterday I had the honor and pleasure of attending a DevelopersBR group live where I was able to share my presentation "SQL Server Security - Are you leaving the key under the rug?" SQL Server ES #11, MVPConf LATAM 2019 and SQL Saturday #844 - Belo Horizonte ...
Read More

SQL Saturday # 844 - Belo Horizonte

Hey guys! Today, 18 / 05 / 2019, I'm very happy to have attended SQL Saturday #844 - Belo Horizonte (MG), where I had the opportunity to talk about "Security in SQL Server: Are you leaving the key under the rug?" , where I demonstrated the various risks and security holes that we may have on a daily basis and we don't even notice, with some examples ...
Read More

Power BI - Now I'm a Planilheiro !!

Faala guys! Today's post is nothing technical, but it is about a big change in my professional life and career, because through a partnership of #TeamFabricioLima, now I am a Planilheiro !! If you live on Mars or Saturn, and still don't know about the Channel of the Planilheiros, we are talking about the WORLD'S BIGGEST POWER BI CHANNEL, ...
Read More

SQL Server Security Checklist - An SP with more than 70 security items to validate your database.

Hey guys! In this article I would like to share with you a project that I have been developing since November of 2018 and today has more than 4.500 lines of code, which is a very complete Security Checklist (probably the most complete and comprehensive you will find on the Internet) , counting on more than 70 Security items to validate your bank ...
Read More

How Was the SQL Server ES 12 Meetup

Hey guys! On 11 / 05, I had the honor of participating in the organization of the 12 SQL Server ES Meeting. In this event, we met at the Catholic University of Vitória (UCV), which has been a great partner since the beginning of the technical community. Speaking of technical content, we are preparing two very interesting lectures. Ruy Lacerda, from Planilheiros, gave the lecture "Treatment of ...
Read More

SQL Server - How to Connect Using Dedicated Admin Connection (DAC) Connection Without SQL Browser

Speak guys !! In this article I would like to share with you a little study on how to connect using the Dedicated Admin Connection (DAC) connection without SQL Browser. This idea came from a question sent in my SQL Server Security - Module 1 course, where Fabiano Ferreira sent the following question: "in the stpchecklist_security script, there is a validation about ...
Read More

SQL Server - Permissions for Using OLE Automation (Yes, Documentation is Wrong)

Speak peopleALL !! In this very simple and quick article, I will share with you what permissions to use OLE Automation, a feature of SQL Server that lets you use Windows DLLs and APIs through Stored Procedures calls to perform various tasks within the database, such as Operations. with Files, use regular expressions (RegExp) and even make requests ...
Read More

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

Hey guys! In this post I would like to share with you how was the Global Azure Bootcamp 2019 - Vitória, again, along with great IT professionals here at ES and had the honor and pleasure to support the event in the organization and also lecturing. For those who do not know, this event is focused on Cloud solutions ...
Read More

How was MVPConf LATAM 2019

Faala guys! How long huh .. rs These last few weeks I've been very busy finishing my Safety Training - Module 1, which has been ANY WRONG and also been present at MVPConf LATAM 2019, where I had the pleasure and honor of speaking next to the myth. , legend, Junior Galvao, professional for several years and with a ...
Read More

How was SQL Server ES #11

Hey guys! On 23 / 03, I had the honor of participating in the organization of the 11 SQL Server ES Meeting, the first of 2019 after the "vacation" period. At this event, we met at TOTVS ES headquarters, in Vila Velha for the first time, in a very nice structure that they prepared specially to receive them. Speaking of technical content, we have prepared two ...
Read More

[Live] - How was the webcast “Sete Zomis e uma LEI” - The LGPD in the view of IT professionals

Hey guys! In this post, I would like to share with you the recording of the live Seven "Zomis" and a LEI, which I invited at the invitation of Arthur Luz, together with reference professionals in the IT market, from various areas, to discuss LGPD, the Law General Data Protection, which aims to increase the privacy of personal data and prevent ...
Read More

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

Hey guys! In this article, I would like to address a very hot topic in the field of technology in general, which is the General Personal Data Protection Act (LGPDP or LGPD), a GDPR "cousin" that is in force in Europe. , and should become a reality in Brazil from August 2020, bringing several ...
Read More

#TeamFabricioLima SQL Server, Power BI, and Azure ONLINE Courses and Training: Boost Your Career!

Hey guys! ATTENTION!!! New in the area !!! As you know, I work at #TeamFabricioLima and after a few months of hard work, we have lovingly prepared a new ONLINE Training platform for you. Our specialists and partners will provide you with differentiated courses with a lot of experience and everyday cases. To open with a golden key, we already have the first available ...
Read More

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

Hey guys! All right with you ? TODAY, 14 March 2019, at 20: 30, we will be bringing together big beasts of the data community for a roundtable on the subject of On-premises vs. Cloud: Advantages and Disadvantages, openly debating this big dilemma by setting up a data architecture. IT, whether for an application, a company infrastructure, database, ...
Read More

SQL Server - When you should use ORDER BY in the query and when you should not use it at all!

Hey guys! In this article I am going to demonstrate to you when to use ORDER BY and when we should not use it at all, because it has no effect on practice and just makes our query longer and more resource consuming. The main purpose of this article is to break the myth that data is physically ordered in the table when ...
Read More

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

Hey guys! In another security article, which is the subject of my MVPConf LATAM 2019 talk, I will share with you the risks of TRUSTWORTHY ownership of a SQL Server database, which is widely used in environments that use EXTERNAL_ACCESS permission-level SQLCLR libraries or UNRESTRICTED. If you have a SQLCLR library and have enabled the ...
Read More

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

Hey guys! In this article I would like to share with you the risks of using Dynamic Query in SQL Server through the EXECUTE command and demonstrating safe ways to use dynamic query that are not susceptible to SQL Injection attacks. What is Dynamic Query? Feature widely used in system and database routines, ...
Read More

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

Faaaala Guys! All right with you? Going to invite you to another pre-Carnival live (FREE), where we will hold a round table, with open debate about the main differences between Power BI Service x Report Server, as well as when to use one another, licensing, advantages and disadvantages of each solution and more! And at this round table, we will have the ...
Read More

SQL Server - How to identify and collect time consuming query information using Extended Events (XE)

Hey guys! In this article I would like to share with you how to identify and collect long query information using Extended Events (XE), in a very similar article to SQL Server - How to identify and collect long query information using Trace (SQL Server Profiler), which uses Profiler technology (Trace). What motivated me to write this article was ...
Read More

SQL Server - Using Calculated Columns (or Computed Columns) for Performance Tuning

Hey guys!!! In this article, I would like to share with you something I see a lot in everyday life when I am performing Tuning consulting, which are time consuming, I / O and CPU consuming queries that use WHERE or JOIN functions in tables with many records and how we can use a very simple column indexing technique ...
Read More

SQL Server - How to Avoid and Protect Against Ransomware Attacks Like WannaCry on Your Database Server

Hey guys! In this blog article number 350, I would like to share with you my experience during several tests I did about Ransomwares on SQL Server database servers, such as WannaCry, which I downloaded and "infected" my VM just to perform these tests, understand how it works and how we can protect ourselves against this kind ...
Read More

VMware Player - Using independent nonpersistent disk mode

Hey guys! In this article today I will talk about a very different topic from what I usually address here on the site, which is VMware Player, a free virtualization software from VMware that I use to create my study VMs, labs and where I create content for this blog. . A long time ago, when I started in this world of virtualization, I ...
Read More

SQL Server - How to Avoid Brute Force Attacks on Your Database

Hey guys! In this article today I will demonstrate how brute force attacks occur on SQL Server and how to try to defend against such attacks. What is Brute force attack Brute force attack is the simplest and most time-consuming technique to break into systems and databases. It consists of using bases of ...
Read More

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

Hey guys! One more Performance Tuning tip for you, where I will explain and comment on the difference between Seek Predicate and Predicate, where they may look the same, but make a big difference in the performance of your queries. I believe this article should answer a very common question of who is starting in the area right now: The order of the columns in ...
Read More

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

Hey guys! In this post I would like to publicize the event that I will participate on 07 / 02 / 2019 (tomorrow .. lol) at 20: 00, on Rafael Mendonça's channel, alongside Rafael himself and also Claudio Bonel and Arthur Luz, where we will talk about Data Architecture and Governance in BI Projects with Power BI, showing that a project ...
Read More

SQL Server - Performance Tuning Tips: Implicit Conversion? NEVER!

Hey guys! All in peace, right ?! In this article I would like to comment on a query performance problem that we found a lot here in our daily life at Fabrício Lima - BD Solutions, one of the best and most recognized Performance Tuning companies in Brazil. We're talking about something that is often terribly simple to solve ...
Read More

SQL Server - NOLOCK vs READPAST: Do you know the difference between the two?

Hey guys! In this article I would like to demonstrate in practice the use of 2 query hints commonly used by developers to avoid data reading locks, which are NOLOCK and READPAST, and effectively demonstrate the effect of these hints on a query. The idea of ​​writing this article came from a question sent in the group "SQL ...
Read More

SQL Server 2014 - How to Estimate Progress and How Much Time Is Left to Create an Index

Hey guys! In this article, I'd like to share with you a very simple, but very interesting script that helps you estimate the progress of creating an index through the sys.dm_exec_query_profiles DMV, available from SQL Server 2014. If you want to estimate the tempo and how much time is left to finish your BACKUP, RESTORE, or DBCC command, give ...
Read More

SQL Server - How to identify how to change the default schema for database users

Faaala guys !! In this post I would like to address a very common subject in DBA's everyday life, which is the default schema of users in the database, which may or may not differ from the standard (dbo), as defined by TI. What is schema in SQL Server? What is it for? Before proceeding with the main theme of this ...
Read More

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

Hey guys! In this post I would like to disclose the event that I will participate on 24 / 01 / 2019 (tomorrow .. lol) at 20: 30, on Rafael Mendonça's channel, next to Rafael himself and also Orlando Gomes, where we will talk a little bit about the Microsoft MVP program in Brazil and of course demonstrating live how we 3 participate in the development of ...
Read More

SQL Server - How to use auditing to map actual required permissions on a user

Hey guys! In this article, I will demonstrate how to use auditing to map a user's actual required permissions, identifying everything that that user actually did in the database over the observed time, to generate a script granting only the permissions he really needs, thus eliminating need to have integration users and users other than the main ...
Read More

SQL Server - How to Identify Instance Initialization Parameters Using T-SQL

Hey guys! In this post today I will give a very quick tip, which is how to identify the instance initialization parameters using T-SQL, very useful scenario when you have access to connects in the instance, but do not have access to the server operating system. Using SQL Server Configuring Manager For those who don't know, the SQL Server service has ...
Read More