Blog

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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