Posts Archive

Why was the Power CLR created? A very common scenario today is the need to create integrations between a SQL Server database and external resources, such as files, FTP and APIs, especially in automatic routines for processing and enriching data through the consumption of information from third-party services or companies. . For complex projects with large volumes ...
Learn more

Hey guys! TODAY, 27/04/2023 at 19:30 pm, I will be participating in a live on Azure SQL Database and Azure SQL Managed Instance on Henrique Eduardo Souza's channel (@cloud4developers). Let's talk about differences, use cases, future of relational banking, On-premises pro cloud differences, optimization and much more! Stream link: I'm waiting for you all there 🙂 ...
Learn more

Hey guys! In this post I will comment on an alerting and monitoring system for SQL Server and Azure Managed Instance, developed by the company PowerTuning, which aims to provide various metrics, analyzes and information to quickly identify the current state of the bank (Health Check), send Email alerts (including charts) when any event occurs in the database and...
Learn more

Introduction Hey everyone! In this article I would like to share with you a little code that I needed to use today to UPDATE a relatively large table (55M+ records) in an Azure SQL Database base and, after 1h and 30mins waiting, I got a connection error and I had to do it all over again. Not just in that case, but it can happen...
Learn more

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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! ...
Learn more

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 ...
Learn more

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...
Learn more

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...
Learn more

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...
Learn more

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...
Learn more

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...
Learn more

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...
Learn more

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...
Learn more

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...
Learn more

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...
Learn more

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...
Learn more

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...
Learn more

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...
Learn more

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...
Learn more

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...
Learn more

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...
Learn more

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 🙂 ...
Learn more

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...
Learn more

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...
Learn more

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...
Learn more

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 ...
Learn more

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...
Learn more

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...
Learn more

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...
Learn more

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...
Learn more

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...
Learn more

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 ...
Learn more

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 ...
Learn more

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, ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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: ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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, ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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: ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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.
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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, ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more

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 ...
Learn more