Blog

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

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

[Face-to-face event] - MVPConf LATAM 2019 - April 12 and 13 (São Paulo)

Hey guys! Here comes MVPConf LATAM 2019, the biggest technology event created by MVPs in the world! For those who do not know, MVPConf LATAM is created and maintained by the largest influencers of technical communities in Brazil and aims to bring together all people who have a passion for knowledge and want to expand their networking. MVPConf LATAM brings together the largest number ...
Read More

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

Speak guys !! Next Friday (11 / 01), at 21: 30, I will be attending the online event "Round Table #17 - Relational Banks x NoSQL - Coding Night", together with great and recognized professionals from the technical community. Attendance confirmed: - André Secco (Microsoft MVP, MTAC) - Luiz Carlos Faria (Microsoft MVP, MTAC) - Renato Groffe (Microsoft MVP, MTAC) - Thiago Adriano (Microsoft MVP) - ...
Read More

SQL Server - What is the difference between @@ ERROR and ERROR_NUMBER ()?

Hey guys! 2019's first post! In this article, I will explain the difference between @@ ERROR and the ERROR_NUMBER () function, which in theory bring the same result, that is, the error number caused by some operation in the current session. The idea of ​​writing about it came from a doubt of a Nigerian in the SQL Server - DBA group of Telegram and ...
Read More

Retrospective 2018 - What a year !!

Hey guys! In the last post from 2018, I would like to thank you all very much, who comment, like, rate my articles, visit and share on their social networks. It is a great privilege to have a space to share the things I study and test with so many people. Reading your comments makes me very excited to continue ...
Read More

SQL Server Express - CHALLENGE: Is it possible to exceed the 10 GB data limit on a single basis?

Speak guys! Is it possible to exceed the limit of 10GB of data on one basis? As I already mentioned in the article SQL Server Express and Developer – How far can we use the free versions of SQL Server?, the Express version has a series of technical limitations, whether hardware, as SQL Server uses only 1 CPU and 1 GB . ..
Read More

What has changed in SQL Server 2012 in relation to T-SQL - In the view of Developers

Hey guys! All right ? In today's post, I will share with you some research I have been doing for some time about the new features of SQL Server with each release, focusing on query developers and database routines. In the environments I work in, I see that many end up "reinventing the wheel" or creating UDF functions ...
Read More

SQL Server - How to identify the data type of columns and parameters of Tables, Views, Stored Procedures and Functions

Hey guys! In this quick post today, I would like to share with you how to use DMV's to identify the data type of columns in tables, views, and return tables in Table Valued Functions (TVF) functions and also the data type in parameters of Functions and Stored Procedures in SQL Server, both custom and primitive types ...
Read More

Power BI - Who are the Microsoft MVP's in Brazil?

Hey guys! In one of the latest posts from 2018, I would like to share with you a Power BI dashboard with information from all MVP's in Brazil, which is available on the Find a MVP portal. What is MVP? For those unfamiliar with the Microsoft Most Valuable Professional (MVP) program, it recognizes community leaders who have already demonstrated a commitment ...
Read More

SQL Server - How to disable “sa” login minimizing impacts

Speak, my dear readers! In this article, I would like to extend the security issue a bit and share with you how to disable "sa" login minimizing impacts. As I already commented in the SQL Server article - How to enable / enable sa user, it is a good security practice to keep user "sa" deactivated and renamed, since this user ...
Read More

SQL Server Reporting Services (SSRS) - Error querying data: There was a problem getting data from the Report Server Web service

Hey guys! While Creating My SQL Server Reporting Services (SSRS) Article - Which Reports Are Most Accessed? And which are not being used? (which I just published) I found some errors while testing database connectivity through the Power BI Report Server, which I had installed a few minutes ago for this article, where ...
Read More

SQL Server Reporting Services (SSRS) - Which reports are most accessed? And which are not being used?

Hello guys! In this article, I would like to share with you how to use SQL Server Reporting Services (SSRS) views and catalog tables to identify which reports are most accessed and which are not being used. This need came to me during the service to a customer, who is in the process of migrating RDL reports from Reporting Services to ...
Read More

How was Microsoft Ignite The Tour (Sao Paulo) and MVP Get Together 2018

Hello guys! In this post, I would like to share with you how my experience was on Microsoft Ignite The Tour (Sao Paulo) and MVP Get Together 2018, held in the 2 days following Ignite at Microsoft, as I announced I would participate in this post on here. Held in various locations around the world, São Paulo was the 2º on the list ...
Read More

SQL Server - How to Hide Databases from Unauthorized Users

Hey guys!!! In this article I would like to demonstrate how to improve the security of your SQL Server instances very simply and using a combination of Concealment and Access Restriction techniques (remembering that in Security we have 3 main techniques: Concealment, Access Restriction and Encryption) . What I would like to discuss in this article is about the privilege ...
Read More

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

Hey guys! In this article I would like to share with you a query that allows you to identify which queries are using a particular index. This type of analysis can be especially useful for identifying which queries that are indexing have the most scan operations you are looking for, for example. The idea of ​​this post came from a doubt to ...
Read More

SQL Server - The activated proc '[dbo]. [Sp_syspolicy_events_reader]' running on queue 'msdb.dbo.syspolicy_event_queue'

Hey guys! In this article I would like to share a situation that occurred during a customer service where I work, that is, another real case of daily life. We had a database instance that went into suspect mode (nothing to do with this post) and when I went to parse the SQL Server log for more information ...
Read More

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

Hey guys! In this article, I would like to demonstrate how to use SQL Server DMV's to identify locks, blocks, and blocking sessions in your environment. I had the idea of ​​writing this post, when I was serving a client in person on a BI demand and from my side I saw some users complaining about "slow" problems in their reports, when what ...
Read More

Microsoft Ignite 2018 - The Tour (São Paulo) - See you there!

Hey guys! From 11 to 14, I will be in São Paulo for Microsoft Ignite 2018 - The Tour, together with Fabrício Lima, where we will update with the news that Microsoft is making available in several areas, such as AI, Big Data, Azure SQL Database, Security and more! Who is there at the event and wants to talk ...
Read More

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

Hey guys! In this post I would like to share with you my excellent experience participating in the Tuesdays of Data #38, event held almost every Tuesday by Fabio Cotrim, where I could bring to the participants, my view on the Modern and Automated DBA, as it is this professional's new profile, some new tasks and activities he has ...
Read More

FREE Database Check-Up + Security Analysis: Do You Need It?

Hello guys! It's okay with you, right? In this post I would like to introduce you to something really different, which is a FREE Check-up of your database + security analysis, processes developed and carried out by the PowerTuning consulting team, specialists in the database area, using the best market practices, combined with experiences during the ...
Read More

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

Hey guys! In this article I want to bring you a solution I created yesterday to include in a checklist I'm developing, which allows me to identify the latest version of Service Pack (SP) and Cumulative Update (CU) for the version of SQL Server where I am running this code. To identify the latest updates for each version, I will use the ...
Read More

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

Hey guys! In this article, I would like to document and share an experience I had TODAY, in the consulting where I work, in which we had a problem with a client that caused all Linked Servers pointing to a particular instance to start showing the error below, for both trying to query data and trying to alter objects (like Stored Procedures) ...
Read More

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

Hey guys! All right with you ? Last Saturday, 24 / 11, I had the pleasure of participating once again in organizing the monthly SQL Server ES meeting, this time, our 10th meeting (in addition to SQL Day). In this event, we brought from São Paulo, BI specialist Nilton Kazuyuki Ueda, who held a workshop "From Zero to Everything ...
Read More

How was SQL Server 2019 What's New Live on the dotNET Channel?

Hey guys! As I had already announced in the post Live on the .NET Channel - SQL Server 2019 News (22 / 11 / 2018 at 21: 30), yesterday I participated in a dotNET Channel live, invited by MVP Renato Groffe. The live was very well organized by Groffe (aka BOT) and many very interesting questions were asked by the almost 550 people who ...
Read More

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

Hey guys! That's fine with you, right ?! Today I had a golden opportunity to speak at the Power BI RoadShow #5 - Vila Velha / ES, at the invitation of Fernando Garcia and Ruy Lacerda, creators of Planilheiros, Latin America's largest Power BI channel on Youtube and soon, The largest in the world. 08 Event Schedule: 00 - ...
Read More

SQL Server - How to use EXECUTE AS to execute commands as another user (Impersonate login and user)

Speak up guys! In this article I would like to share with you a feature available since SQL Server 2005 that allows you to run T-SQL code on behalf of another user. I'm talking about the EXECUTE AS command...
Read More

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

Introduction In today's post, I would like to demonstrate to you how to archive historical tables in Azure with Stretch Database, available from SQL Server 2016. Stretch Database is a feature of the DBMS that migrates your cold data (data that is not changed or consulted frequently) automatically, transparently and securely to the data.
Read More

How was the Microsoft Certification Data Platform Webinar (Data Platform)

Hey guys! I would like to share with you how it was the experience of hosting the Microsoft Certification Webinar in the Data Platform, an online event that I attended with MVP and MCSE Caio Amante, MCSE Danilo Cardoso, MCSE Maruan Aawar and MCSE Meirieli Ribeiro. It was really a really cool experience to share some of my experience ...
Read More

.NET Channel Live - SQL Server 2019 What's New (22 / 11 / 2018 at 21: 30)

Hey guys! On 22 / 11 / 2018, at 21: 30, I will participate in a live held by the .NET Channel where I will be able to comment and demonstrate the main news of SQL Server 2019. To make your registration, click this link here. Be sure to attend the event and stay on top of SQL Server 2019 news! The event is ONLINE and FREE! ...
Read More

Video - Power BI vs. Reporting Services: Who's Better?

Hey guys! In this post, I would like to share with you the video of the online webcast that we held on 20 / 10, at the Info TI Seminar event, which I had already shared with you that would participate in this post here. I would like to thank the invitation of the event organizer, Gilberto Breyer Júnior, who, by the way, did a great job in organizing ...
Read More

SQL Server 2008 - How to Encrypt Your Data Using Transparent Data Encryption (TDE)

Introduction With the advent of GDPR, data security concerns for businesses are growing, and an area that was once overlooked is in evidence more than ever now. As a result, IT professionals, particularly DBAs, have been looking for ways to reduce the risk of data exposure ...
Read More

SQL Server 2016 - How to Encrypt Your Data Using Always Encrypted

Hey guys! Ready for one more article? Introduction With the advent of GDPR, data security concerns for businesses are growing, and an area that was once overlooked is in evidence more than ever now. As a result, IT professionals, especially DBAs, have been looking for ways ...
Read More

New - Agenda with ALL Data Platform community events

Hey guys! Today I bring you one more news, which is a Data Platform Event Agenda, where everyone will have access to the online and in-person events that occur in the Microsoft data community (Power BI, SQL Server, SSIS, SSRS, SSAS, Azure, CosmosDB, etc). This agenda is maintained by all community leaders and speakers from ...
Read More

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

Hey guys! On 16 / 10, I had the pleasure of speaking at the 1º SQL Server Meetup, held at Microsoft headquarters, in São Paulo, at the invitation of the event organizer, Caio Amante. No words to describe the satisfaction and happiness in being able to share a little about my vision of the role of dba these days, to know personally several ...
Read More

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

Hello guys! Let's go for another article. Introduction Working as a DBA in environments where bank BI developers and analysts are not sysadmin (amen), but create jobs in the bank using their own users (SQL Server - Understanding SQL Agent Permissions and Roles (SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole) )), do you know how common are demands of change of ...
Read More

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

Hey guys! In this article, I would like to share with you a question you posted a few minutes ago in a Whatsapp group about a very common SQL Server problem, especially in the areas of BI and / or development, which are errors. data type conversion, that is, trying to convert a ...
Read More

SQL Server 2019 - Knowing the Changes in Row Estimation in Table Variables

Hey guys! In today's post, I'd like to share this video I just made, demonstrating in practice the changes we've had in SQL Server 2019 regarding row estimation in table-type variables, where the query optimizer always estimated 1 row , independent of data volume, when using table-like variables, making it possible to ...
Read More

SSRS - Reporting Services in your company without paying anything? Meet SQL Server Express with Advanced Services

Hey guys! In this article, I would like to comment on some very interesting information that Vithor Silva shared in a Whatsapp group in which I participate (he has given me the "rights" to this post .. kkkkkkk) and that many people (including myself) do not have / were aware that is the use of SQL Server Reporting Services in corporate environments for free, ...
Read More

1st SQL Server Meetup at Microsoft - 16/10/2018 - 19 pm (On-site Event in São Paulo)

Hey guys! On 16 / 10 / 2018, at 19h, I will attend the 1º Meetup SQL Server, in São Paulo (capital), a face-to-face event at Microsoft headquarters where I, Fabiano Amorim and Thiago Alencar (two monster guys in SQL Server) ) We will be discussing issues that are currently hot, such as DBA Tools and SQL Server 2019. This is a ...
Read More

Webcast - 300 Celebration posts + SQL Server 2019 What's New (04 / 10 / 2018 - 21h)

Hey guys! All right with you right? In today's post, I would first like to thank everyone who came here and enjoyed it, commented, showed it to a colleague, who is a regular or shared one of my articles on some social network. It is these feedbacks that motivate me to continue writing, studying and seeking content ...
Read More

SQL Server 2019 - News and Features List

Hey guys! In this mega expected post, I will comment on the news we can expect from SQL Server 2019, which has long since gone from being a Database Management System (DBMS) to becoming a true Microsoft data platform, joining database. data, BI, Machine Learning and Big Data / Analytics. I would like to see news about the ...
Read More

What has changed in SQL Server 2008 in relation to T-SQL - In the view of Developers

Hey guys! All right ? In today's post, I will share with you some research I have been doing for some time about the new features of SQL Server with each release, focusing on query developers and database routines. In the environments I work in, I see that many end up "reinventing the wheel" or creating UDF functions ...
Read More

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

Hey guys! In this post, I would like to demonstrate to you how to create data pagination in SQL Server, so that only a limited amount of records are returned by queries, so less data is processed on output and queries have a response time. smaller. This scenario, which is quite common in applications, which usually ...
Read More

SQL Server - How to use MERGE command to enter, update and delete data with 1 command only

Hello guys! In this post, I would like to demonstrate to you how to use the MERGE command, available since SQL Server 2008, to perform INSERT and UPDATE commands between two tables in a single statement. For the examples in this post, I will use a base that I will create using the script below: IF (OBJECT_ID ('dbo.Sale') IS NOT NULL) DROP TABLE dbo.Sale CREATE TABLE ...
Read More

SQL Server - Using traceflag 3226 to avoid writing informational messages generated by backups to the SQL Server log

Hey guys! In this post, I would like to share with you the solution of a question sent to me today on Telegram, where they asked how to hide the informational messages that the BACKUP DATABASE command produces while it is running and also writes them to the SQL Server log. . Introduction If you have never backed up SQL ...
Read More

SQL Server - How to Pass a Table as a Parameter for Stored Procedures and Functions

Hey guys! In this post today I would like to demonstrate a feature available since SQL Server 2008 and that I see very few day-to-day use cases in the companies I worked with, which is the use of "tables" as parameters for Stored Procedures. Introduction If you are a guy who likes gambiarras, I'm sure you thought I was ...
Read More

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

Hey guys! Today I had the pleasure of speaking at the 9 SQL Server ES Meeting: Power BI, Reporting Services and Performance Tuning - 15 / 09 / 2018, where I could share how the event was on this link here, but I don't want to stop there. On 20 / 10 / 2018, I will attend the Info TI Seminar, a free and ONLINE event, which aims to bring together professionals ...
Read More

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

Hey guys! All quiet? On 15 / 09, I had the pleasure of participating in the organization of the 9 meeting of PASS Local Group SQL Server ES and lecturing on the theme "Power BI x Reporting Services: Who's Better?", Along with MVP Fabrício Lima, who introduced us the lecture "Step by step of how I made a Tuning in 7 real queries of ...
Read More

SQL Server - How to use Management Studio debugging

Hey guys! In this video that I will share with you, I would like to demonstrate a very interesting feature in the development of T-SQL queries and code, especially functions and Stored Procedures, which is DEBUG. A very common and popular tool for developers (and almost unused when context is programming in the database), Debug allows you to ...
Read More

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

Hey everybody, all beauty with you? The 9th Meeting of the Local Group SQL Server ES is coming and it's very cool! This time, we will have as speakers Fabrício Lima - MVP and me, Dirceu Resende. This is an excellent opportunity to learn more about Power BI and Reporting Services, two competing Microsoft BI solutions, ...
Read More

SQL Server and Power BI - How to analyze and generate WhatsApp group conversation statistics

Hey guys! In this blog post, I'd like to share with you a solution that allows you to analyze and generate Whatsapp group conversation statistics using SQL Server and Power BI. Unlike Telegram, which has an integration API and task automation bots, Whatsapp is fully delayed closed and does not allow any kind of legal integration ...
Read More

SQL Server Reporting Services (SSRS) - How to log the report view and identify which user is accessing

Hey guys! In this post I would like to show you how to log the report view and identify which user is accessing, that is, how to write to a database table, which user is accessing a particular report and when it was done. The idea of ​​this post came from a doubt in a group of Telegram and I found ...
Read More

How was the 1st SQL Day - ES?

Hey guys! All quiet? On 04 / 08 / 2018, I had the great pleasure of participating in the organization of 1º SQL Day ES, PASS Local Group SQL Server ES, together with Tiago Neves, Fabrício Lima and Vithor Silva, where we had the presence of a large team of speakers recognized throughout Brazil for their excellent technical skills and contributions to the ...
Read More

[Video] - Introduction to SQLCLR

Hey guys! All in peace? In this post, I'd like to share with you a video I recorded explaining what SQLCLR is, the advantages and disadvantages of using this solution, and demonstrating how to create your first SQL Database Project in Visual Studio. Introduction to SQLCLR I had already lectured on this topic of DEV-ES Conf 2017 and solved ...
Read More

MS SQL Server - A new portal for technical articles and information on events, webcasts and lectures

Hey guys! I would like to share with you a very cool news that I developed together with the technical community of Data Platform, which is the MS SQL Server portal. This new portal acts as an aggregator of technical articles from various data specialists, separated by technology (SQL Server, Power BI, Reporting Services, Azure, Analysis Services, etc.) ...
Read More

SQL Server - How to create a code version of your Stored Procedures in HTML and with comments on the change

Hey guys! In this article I will share with you how to create a code version of your Stored Procedures in HTML and with comments on the change. In the past, I had already created the post How to Create an Audit Trigger to log object manipulation in SQL Server, which shows how to write to a database table, all ...
Read More

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

Faaaaala guys !! Today I am very excited about this post. My first using Python on SQL Server 2017, and you can expect a lot more. On February 04 of 2017, I had released the post SQL Server - How to Integrate Database with Slack and Send Messages Using CLR (C #) and this ...
Read More

SQL Server - Using CROSS JOIN (Cartesian product) to create rows in the query result

Hey guys! In this post I would like to share with you the operation of an operator that I rarely see anyone using, which is CROSS JOIN, and which in certain scenarios may be useful. What is CROSS JOIN? CROSS JOIN returns the combination of each row between the tables involved, also known as Product ...
Read More

SQL Server - How to Identify a Slow or “Heavy” Query in Your Database

Hello guys! In this post, I would like to demonstrate some ways to identify slow or heavy queries that end up consuming a lot of machine resources and take a long time to return results, whether due to excessive CPU, memory or disk usage. The purpose of this article is to help you identify queries that have potential performance issues. An ...
Read More

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

Hey guys! All right ? In this article I will share with you a life-saving solution in desperation when someone deletes a database object (View, Stored Procedure, View or Function), you don't have a database object versioning routine and you need to try to retrieve this object quickly without having to ...
Read More

SQL Server - How to enable / enable sa user

Hey guys! All in peace right? Through this article, I am going to open a new category on my blog called "What not to do", which are some database management bad practice articles that I am going to start gathering here and so, show you all that you shouldn't Be done. To debut this category, I will write ...
Read More

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

Hey guys !!!! On 04 / 08, we are organizing the first SQL Day of ES, where we will hold a full day of various lectures, bringing in professional specialists from various specialties (DBA's, Data Engineers, Data Scientists, BI Analysts, etc.), recognized all over Brazil. At this event we had the idea of ​​asking (it will not be mandatory) that each participant bring some food ...
Read More

Congratulations 2018-2019 Microsoft MVP!

Hey guys! Today is a very special and happy day for me, because I was watching a series on NetFlix and when I get my phone, I see this email: It is a great satisfaction and honor to receive such a cool and important prize, and with this, I join a team of excellent data professionals by ...
Read More

SQL Server - Knowing the In-Memory OLTP (Hekaton) Durable vs Non-durable tables

What's up guys! Ready for one more tip? Introduction In this article I would like to demonstrate to you some ways to load data quickly and efficiently into the database using as little logging as possible. This is especially useful for staging scenarios in BI / Data warehouse processes where data must be loaded quickly and a possible ...
Read More

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

Hey guys! In this post, I will show you how to calculate the distance between two locations using latitude and longitude (without API). In March 2017, I demonstrated how to do this using the Google Maps API in the post SQL Server - How to calculate the distance between two points using the Google API (zip code, address or latitute and longitude), but ...
Read More

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

Hey guys! All quiet? On 16 / 06, I had the pleasure of participating in the 8 PASS Local Group SQL Server ES meeting, next to Tiago Neves, where we had the presence of MVP Igor Santos and Daniel Braga as speakers. Igor is DevSQL Local Group Leader in Rio de Janeiro, SQL Saturday speaker in Brazil, currently works as a ...
Read More

SQL Server - Rounding numbers according to ABNT NBR 5891

Hey guys! In this article, I will share with you some tips and explanations about number rounding in SQL Server using ROUND, FLOOR, CEILING and also using a custom function to meet ABNT NBR 5891 definitions. Introduction Present in virtually all information systems, rounding functions are widely used to deal with fractional numbers and ...
Read More

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

Hey guys! In this post I would like to share some solutions on how to compress and unzip files and directories through SQL Server. This is especially useful for creating ETL routines where you need to utilize these features using T-SQL scripts or even for compressing backup files generated in the Express version (which does not support compressed backups). If you have ...
Read More

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

Hey everybody, all beauty with you? The 8th Meeting of the Local Group SQL Server ES is coming and is a must see! This time, we will have as speaker Igor Santos - MVP, directly from Rio de Janeiro, bringing a very cool lecture for those who would not have the opportunity to travel to RJ or SP. Igor is Local Group Leader of ...
Read More

SQL Server Express and Developer - How far can we use free versions of SQL Server?

Hello guys! After much reading and answering questions in Whatsapp and Telegram groups about limitations of SQL Server Express and Developer, I decided to write this article explaining about these two free versions *** of SQL Server and trying to answer any questions. SQL Server Developer Edition Is SQL Server Developer Edition free? On 31 / 03 / 2016, it was announced ...
Read More

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

Hey guys! One issue I don't often see much in everyday life is DBA's and developers' concern about the use of features marked "deprecated" by Microsoft, that is, they are set to be removed in some future version of SQL Server according to Microsoft roadmap. Although we can observe that some features are from the ...
Read More

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

Hey guys! All right with you ? In this post I would like to share a solution that I needed to develop in my company to do a web scraping and extract agency data from the Post Office website (http://www2.correios.com.br/sistemas/agencias/). As you might imagine, to achieve this solution and bring data into my database quickly, I used my old ...
Read More

SQL Server - How to use regular expressions (RegExp) in your database

Hello guys! Excited for another post ??? In this article I would like to show you how we can use regular expressions (RegExp) in your database through queries, whether to create some monitoring or even to create BI reports and indicators or some system. The regular expression (or the regex or regexp foreigners, short for regular English ...
Read More

HALF A MILLION

Faaala guys! All in peace? Hope so! In this non technical post, I would just like to thank everyone who visits or has visited my blog. Know that I do this work here with great affection and willingness to share the things I learn in my daily life, so that it can help other people who may have ...
Read More

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

Hey guys! All in peace?? With this article, I would like to show you how to find out how long the instance has been online or when the instance was started. This information can be used in a variety of ways, such as monitoring when the SQL service was restarted and then starting an audit of who restarted or why ...
Read More

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

Hey guys! All quiet? On 05 / 05, I had the pleasure of attending the 7 PASS Local Group SQL Server ES meeting, along with Tiago Neves and Fabrício Lima where we had the presence of MVP Vitor Fava as a speaker. Vitor is Local Group Leader of SQLManiacs SP, one of the largest Local Groups in Brazil. He is a speaker of ...
Read More

SQL Server - How to view the entire return message from Job execution (even when it exceeds 4000 characters)

Hey guys! Is everything great with you? In this post, I would like to share with you how to view the entire Job execution return message when the job output is longer than 4.000 characters. Understanding the Scenario and the Problem If we look at the structure of the msdb.dbo.sysjobhistory table, which is where job log messages are written, ...
Read More

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

Hey guys! All quiet? In this post I would like to share with you the work of Brunno Araújo, who took the reference links I posted in the Microsoft Certifications post - Tips, links, and study materials for SQL Server 2016 MCSA and MCSE exams and created separate PDF files by category and subject, greatly facilitating the ...
Read More

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

Speak guys !! All in peace?? Last Saturday (21 / 04), I was pleased to be able to speak at Global Azure Bootcamp 2018 - Victoria / ES and talk about Database as a Service, especially about the non-Microsoft DBMS that are supported by Azure as PaaS (or DBaaS). ), which are MySQL and PostgreSQL, as well as several other DBMSs that are supported as ...
Read More

SQL Server - How to standardize the Collation of all columns in the database

Hello guys! All quiet? In this article, I would like to share with you a problem I had recently, which several columns from various tables in a given database used a different collation from the DB standard, causing joins and WHERE conditions between VARCHAR / CHAR / columns. NVARCHAR with different collations, the bank returns us the following error message: Cannot ...
Read More

Windows 10 - How to redeem the Windows XP / 7/8 / 8.1 photo viewer

Hey guys! All right ? In this very short and quick post, which has nothing to do with development or database, I'll talk about solving a problem I had when upgrading Windows 8.1 from my personal computer (which I use to make my posts) to Windows. 10 (finally) and I had a great resistance to using ...
Read More

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

Hey guys! In this post, I would like to share with you some ways to identify the version and edition of all server instances using xp_regread and Powershell. I saw a user sending this question to a Whatsapp group and I didn't find many solutions on the internet, which motivated me to write this article...
Read More

SQL Server 2017 - How to Pause Rebuild an Index Using Resumable Online Index Rebuilds

Hey guys! All quiet with you? In this post, I would like to demonstrate to you an innovative feature of SQL Server 2017 (Enterprise, Trial and Developer editions only), which is Resumable Online Index Rebuilds, which allows you to start an index rebuild process and be able to pause this operation in middle of processing and then continue where you left off, ...
Read More

SQL Server - Using Resource Governor for greater control over server resources

Hey guys!! This time, I am bringing a very useful feature in administering SQL Server instances on shared servers (which have more than 1 instance), which is Resource Governor. What is Resource Governor Resource Governor is nothing more than a feature available from SQL Server 2008 Enterprise that gives us the ability to ...
Read More

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

Speak guys !! In this article, I would like to introduce to you a very interesting security feature that Microsoft SQL Server has gained from the 2016 release, which is Row Level Security (RLS) or Row Level Security. How Row Level Security (RLS) Works Row Level Security lets you control access to rows in a table ...
Read More

SQL Server 2016 - How to “Time Travel” Using the Temporal Tables Feature

Hey guys!! Through this post, I would like to show you a very interesting and useful feature, which is the Temporal Tables. As I already commented on them in the post SQL Server 2016 - List of news and new features, where you can retrieve data from a table at any point of time. That means you can do ...
Read More

SQL Server - How to Monitor and Audit Data Changes in Tables Using Change Data Capture (CDC)

Hello guys! In this post, I will demonstrate to you how to monitor and audit data changes in tables using Change Data Capture (CDC) in SQL Server. I had already written the post SQL Server - How to create a history of data changes for your tables (logs for audit), which uses the table triggers feature to accomplish this task, ...
Read More

SQL Server - Trigger to prevent and prevent changes to tables

Hello guys! A common need for DBA's is to avoid improper or misleading access and operations, which even the DBA itself may end up with being careless and performing the wrong operation. My idea in this post is to demonstrate some solutions using triggers. Creation of IF test table (OBJECT_ID ('dbo.Test_Trigger') IS NOT NULL) DROP TABLE dbo.Test_Trigger CREATE TABLE dbo.Test_Trigger (Id ...
Read More

Microsoft Certifications - Portuguese Study Material for Your First Certification (MTA)

Hello everybody, How are you ? Continuing My Post Microsoft Certifications - Tips, links, and study materials for the SQL Server 2016 MCSA and MCSE exams, where I covered broadly Microsoft certifications at all levels (MTA, MCSA, and MCSE), In this post I would like to focus especially on certification ...
Read More

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

Hey everybody, all beauty with you? Once again, we are preparing and organizing the 6th Meeting of the Local Group SQL Server ES. This time, we will have as speaker Rafael dos Santos - MVP and a round table with some Data Plataform specialists, talking, asking questions and discussing about various technical subjects to choose from the event participants ...
Read More

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

Hello guys! All quiet with you? In this post, I would like to present to you a very useful tool in the performance tuning routine of the people who constantly needs to activate the STATISTICS TIME and / or IO options to view some information about these queries that can help in the activity of Query Optimization (Want some tips on Performance ...
Read More

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

Hello guys! How are you ? In this article I would like to demonstrate to you How to Create Recursive Queries with Common Table Expressions (CTE) in SQL Server. The CTE feature has been available since the 2005 release, and even today, many people are unaware of this interesting and useful feature on a daily basis. Introduction ...
Read More

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

Hello everyone, all right? Introduction In this post I would like to demonstrate a very interesting feature of SQL Server, available from the 2016 release, which is Dynamic Data Masking (DDM) and allows us to quickly and conveniently mask and hide sensitive information from certain users. Unlike the encryption features of SQL Server Transparent Data Encryption (TDE) and ...
Read More

Dev-ES Conference 2017 - 02/12/2017

Hello guys! All in peace? Today I would like to invite you all to participate in the Dev-ES Conference 2017 event, a regional event, which is spread across social networks, universities, technical schools and technology companies. The purpose of the conference is to foster the technology market in Espírito Santo and provide the community of technology professionals with contact with other ...
Read More

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

Hey guys! On November 15, Microsoft publicly released a preview (beta) version of SQL Operations Studio, a modern 64-bit tool that has been revamped for managing SQL Server instances, whether they are Windows, Linux, Mac, running on Virtual Machines. , Docker, Azure, or physical machines. Developed from Visual Studio Code and packaged through Electron, the ...
Read More

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

Hey guys! All quiet? On 11 / 11 I had the pleasure of participating in the 5 Meeting of PASS Local Group SQL Server ES, with Tiago Neves, Vithor Silva and Fabrício Lima. If you did not see the event post, check it out by clicking this link. As always, the structure of the Catholic University Center of Victoria was sensational, serving us ...
Read More

How to connect to SQL Server using PHP (Xampp) and PDO driver in Windows

Hello guys! All right? In this post, I would like to demonstrate how to connect to SQL Server using PHP (Xampp) and PDO driver on Windows. Many people end up having trouble installing and configuring the drivers due to small technical details that eventually go unnoticed and make it impossible to connect PHP to the database.
Read More

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

Hey everybody, all beauty with you? Once again, we are preparing and organizing the 5th Meeting of the Local Group SQL Server ES. This time we will have as speakers Fabricio Lima - MVP and Vithor Silva - MCSE and we will be back at the Catholic University Center of Vitória. The lectures If you are a Developer, you work with BI, it is ...
Read More

MCP Professional - How to Share Your Certifications and How to Find Certified Professionals

Hello everybody, How are you ? In this non-technical post, I would like to talk to Microsoft Certified Professional (MCP) professionals who visit and follow my articles about a very cool resource that is made available to MCP's and which few use. The MCP professional is one who has passed at least one certification exam from the ...
Read More

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

Hello guys! All right with you ? In this post I would like to comment on something very important in the everyday life of DBA's and Query Developers, which is the database documentation. I hardly see environments where columns or tables have a clear description of what this bank object is all about. Introduction For who ...
Read More

SQL Server - How to Practically Share Your Execution Plans on the Web

Speak guys !! All quiet? In this post I will share with you a very nice tool to practically share your execution plans on the Web, whether in forums, Whatsapp groups, Telegram groups, etc. Often when someone asks for help in groups or comments from blogs / forums, there is no option to attach the execution plan or ...
Read More
/ Database, Tools,