Blog

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hey guys, how are you? In this post, I want to share with you a solution (many possible) to create a SQL Server instance lock monitoring and alerting that can let you know when one or more sessions have been in lock (waiting for some feature) for more than X minutes . Anyone who works in critical environments knows how impactful ...
Learn more

Hello everybody, How are you ? In this post, I'd like to share with you a way to create error and exception monitoring in your database using Extended Events (XE), allowing you to capture and generate a history of errors that occur in your SQL Server instance, these errors, which may have been generated by ...
Learn more

Hello everyone, everything good ? In this post today I would like to show you the T-SQL FORMAT function, available since SQL Server 2012, which until today few people use in day to day formatting of dates and numbers. When I look at Queries, Functions and Stored Procedures, I see that even today, many developers insist on using CAST, ...
Learn more

Hello guys! All right with you ? On 07 / 10 I had the pleasure of participating in the 4 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. With a phenomenal structure, ISH Tecnologia welcomed us ...
Learn more

Hello guys! All right with you ? Today we had another SQL Server ES meeting and I was able to talk to a lot of people about the IT market, have a nice networking and I realized that a lot of people have very interesting questions or knowledge to share, but I'm not joining any Telegram group, Slack or Whatsapp, ie no ...
Learn more

Hello guys! All right with you ? Once again, we are promoting the 4 Chapter SQL Server ES Meeting, which will be held on 07 October 2017, in order to prepare and form a community able to host major events such as SQL Saturday, which has already occurs in several other cities around the ...
Learn more

Hello everyone, everything good ? In this post I would like to start talking about a subject I really like, which is Performance Tuning, which I have already lectured on at the 2 Chapter SQL Server ES Meeting - 10 / 06 / 2017. This theme is always among the most sought after by database professionals, developers and companies looking for database consultants.
Learn more

Hello guys! How are you ? In this post I will demonstrate to you how to identify and collect information from time consuming queries using Trace (SQL Server Profiler). This is very useful to assist you in performance tuning analysis, making it easy to identify routines that have high response time, both procedure execution and ad-hoc queries. In the day to ...
Learn more

Hello everybody, How are you ? Hope so! In this post I would like to share with you a situation where a deadlock occurred at dawn, disrupting a critical routine, and I needed to identify which session caused the deadlock to plan actions to avoid this situation. To help identify these situations and have a history of deadlocks, I will ...
Learn more

Hello everyone, everything good ? In this post I will share with you a need I had on Friday, where a file server would be down for a few hours for maintenance and needed to identify which jobs were accessing that server and therefore would be impacted by this maintenance, ie search for a string in the code of SP's that are called by ...
Learn more

Hello people! All right ? On 26 / 08 I had the pleasure of participating in the 3 SQL Server ES Meeting with Tiago Neves and Fabrício Lima. If you did not see the event post, check it out by clicking this link. Once again, we got some really cool giveaways to raffle to the event attendees. The speaker Alexandre Paiva has drawn ...
Learn more

Hello people!! How are you? Ready to reach a new level when it comes to writing queries quickly and with quality? In this post I would like to comment and give my opinions on a tool that has been in the market for a long time and that maybe many of you already know or have heard, but never got to ...
Learn more

Hello everyone, everything good? In this post, I would like to show you how to read and write events in the Windows Event Viewer using CLR (C #). To learn more about CLR, this powerful feature that lets you create and execute code written using the C # programming language and the .NET Framework to extend the functionality of ...
Learn more

Hello people! In this post, I will demonstrate how to perform file operations using the xp_cmdshell procedure, how to copy files, delete, rename, move, create directories, etc. This post is a complement to other file operations using other solutions: File Operations Using OLE Automation in SQL Server SQL Server - How to List, Read, Write, Copy, Delete and Move Files with ...
Learn more

Hey guys! All right with you ? In this post I will show you how to query Active Directory (AD) information through SQL Server using a simple Linked Server and Active Directory Service Interfaces (ADSI) interface. Once again, Microsoft has been providing capabilities for SQL Server to integrate with more and more tools and interfaces ...
Learn more

Hello everybody, How are you ? In this post I would like to demonstrate to you How to retrieve the source code of an encrypted object (WITH ENCRYPTION) in SQL Server. How many times have I seen programmers encrypting objects in SQL Server in the false hope that this code will really be protected from changes and previews by other users. Introduction To ...
Learn more

Hey guys! All right with you ? In this quick post I will show you how to identify the occurrences of a specific character in a string or table ie count how many times the character "X" appears in each row of a table. For the examples below, I will use 2 SP's from the CLR that I demonstrated how to create (besides other alternatives, ...
Learn more

Hello people! All right with you ? Once again, we are preparing and organizing the 3 Chapter SQL Server ES Meeting, which will be held on 26 August 2017. The community is being formed with the goal of becoming a Chapter of Pass in Victoria. This will enable us to organize major events like SQL Saturday, ...
Learn more

Hello everyone, everything good? In this article, I will show you how to convert an RTF string to text (Remove RTF tags) using CLR (C #) or Powershell, which was a necessity I had last week, where a system would write the information to a table and the data would be Rich Text Format (RTF). I searched the internet a lot to find solutions ...
Learn more

Hey guys! All right with you? I hope so, huh! In this post, I will demonstrate to you how to convert an HTML string to text (Remove HTML tags) using CLR (C #). If you are new to the blog or have never heard of CLR or don't know how to create your first project using this powerful SQL Server tool, which allows you to ...
Learn more

Hello everyone, how are you doing today? In this post, I will demonstrate how to use the XML for Analysis (XLMA) language to be able to process Analysis Services cubes and dimensions through Transact-SQL (T-SQL) queries, which can be used in a SQL Agent job to automate this processing. , which, together with ETL loads for dimension data generation and ...
Learn more

Hello everyone, everything good ? In this post today, I will share with you two more promo codes for taking the Microsoft MCSA 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Microsoft Excel) certification exams for free ( beta), which can be scheduled up to 15 / 09 / 2017. Profile for the 70-778 test You consume and ...
Learn more

Hello guys! How are you? In today's post, I will show you how to return active SQL Server sessions, showing CPU usage, read and write quantity, which user is performing the query, what is being performed by this session, which software is used , what is the hostname and a lot of other session information ...
Learn more

Hello guys! All right ? In this post today I will bring something very cool, which is a Transact-SQL stored procedure where you can query and track order information and objects using data from the Post Office site in SQL Server. For this, I will use the MSXML2.ServerXMLHTTP object and OLE Automation procedures for a solution and the CLR for ...
Learn more

Hello everybody, How are you ? In this post today, I will share with you a Table-valued UDF function that lets you break strings into lines, forcing the maximum length of each line to be N characters separated by a separator character defined in the function call. This function arose out of a need in a critical project where I work, ...
Learn more

Hello everybody, How are you ? After A LOT of time without posting any technical articles, I am starting to have time again to bring in more cool scripts and articles that I would like to share with you. In this post, I will demonstrate how to create a trigger to audit grant and remove events (GRANT and REVOKE) on objects, databases, ...
Learn more

Hello everyone, everything good ? In this post today, I will share with you one more promo code for the free Microsoft Performing Big Data Engineering on Microsoft Cloud Services (Microsoft) certification test that can be scheduled by 70 / 776 / 08. Candidates for this exam are for professionals implementing analytic solutions in Azure, ...
Learn more

Hello guys! All right ? After making my debut as a speaker at SQL Server ES, the PASS Chapter of Vitória / ES, I will comment a little about how the event was, in which I also participated in the organization, along with Tiago Neves, Fabrício Lima and Vithor Silva . If you didn't see the event post, check it out by clicking ...
Learn more

Hello everybody, How are you ? I'm a little absent here on the blog, but soon I'll be posting more often as soon as I finish some projects and consulting I'm doing. In the meantime, I couldn't help but share with you some tips, materials and links that can help you prepare for exams and certification exams ...
Learn more

Hello guys! All right with you ? In this post I would like to share great news for you, who is a student (Undergraduate, Graduate, Master, Doctorate, etc.), is looking to take Microsoft certifications, but doesn't want to spend much. Since 2009, Microsoft has had an incentive program for students who want to take certification exams, giving them a discount of 50% ...
Learn more

Hello guys! All right with you ? After a long time of planning and organization, MTAC Tiago Neves, together with MVP Fabricio Lima, managed to organize the first meeting of the SQL Server Community - ES. The community is being formed with the goal of becoming a Chapter of Pass in Victoria. This will enable us to organize ...
Learn more

Guys, Good afternoon! I will make this post very quickly, to spread the word soon: Microsoft decided to distribute a voucher of 25% discount on MCP and MCSA certification exams! Do not waste time and schedule your certification test. This discount is only valid for those who make the appointment between 03 / 05 / 2017 and 06 / 05 / 2017 and ...
Learn more

Hello everybody, How are you? SQL Server 2017 Once again, Microsoft surprises us with its innovations in the SQL Server product. Less than a year after the release of SQL Server 2016, Microsoft is already preparing to release a new version of the product, which is SQL Server 2017. If we think about the previous versions ...
Learn more

Hello everyone, everything good ? In this post I would like to show how to calculate the difference in years (age) between two dates in SQL Server, showing some solutions and a performance analysis between these options in order to identify the most performative way to perform this calculation. As you know, to solve this question is not enough to perform a simple DATEDIFF (YEAR, ...
Learn more

Hi guys how are you ? In this post I will talk about a session-level configuration that many people are unaware of and in many cases can be of great help in preventing accidental data loss, which is Autocommit. In some other DBMS's (Oracle, Postgree, etc) this is not enabled by default, which ends up generating a ...
Learn more

Hello guys, how are you doing? In this post, I would like to write about querying Analysis Services catalog views, either with queries through SQL Server or using the SQL Server Management Studio MDX or DMX query interface. My purpose in this post is just to demonstrate SQL Server Analysis Services (SSAS) catalog views (DMV). Case ...
Learn more

Hello everyone, how are you doing today? In this post, I will demonstrate how to use the XML for Analysis (XLMA) language to be able to query and send commands to Analysis Services through Transact-SQL (T-SQL) queries, which can be used in a SQL Agent job to automate this process, allowing you to automate backup / restore routines, for example, from ...
Learn more

Hey guys from ES, all right? After a long time of planning and organization, MTAC Tiago Neves, together with Fabrício Lima, managed to organize the first meeting of the SQL Server Community - ES. The community is being formed with the goal of becoming a Chapter of Pass in Victoria. This will enable us to organize major events ...
Learn more

Hello everybody, How are you ?? In this post, which will be the blog's 200 number, I would like to talk about two subjects that I particularly like about SQL Server, which is the creation of .NET (CLR) routines within the SQL Server database and performance tuning. Coincidentally or not, my post number 100 was the Introduction ...
Learn more

Hello guys! All beauty? In this post I would like to write about a feature of SQL Server that even today, we see being implemented in instances of various companies and which causes all resources (CPU, Disk, Memory ..) to be released after the last user. get rid of the databases. I'm talking about the Auto-Close property, which is considered ...
Learn more

Hello people. Hope all is well with you. In this post, I would like to demonstrate a very interesting and commonly used feature of those who create cross-system integration routines using tabular data files, ie text files that use a delimiter to separate information into "columns", such as for example, the CSV file type ...
Learn more

Hello everybody, How are you ? I was watching Fabricio Lima's latest video, where he wrote about the blogs he usually follows by feedly, an RSS reader. I found the idea cool and decided to create a small RSS reader running on SQL Server using CLR or cURL running with xp_cmdshell. In this case, as the return ...
Learn more

Hello everybody, How are you ? Today I was checking the news of blogs that I recommend and ended up seeing a super cool tip on Leka Blog that I decided to share here with you too, which is to enable the Dark theme in the interface of SQL Server Management Studio (SSMS), as well as already exists in Visual Studio already ...
Learn more

Hi guys how are you? In this post, I will demonstrate how to calculate the distance and time between two points, either by entering the zip code, address or latitude and longitude. To meet this need, I will use the Google Maps API, which will perform the calculations and the CLR (C #) or OLE Automation to perform web requests to query and ...
Learn more

Hi guys how are you ? Today I am going to introduce an interesting feature of SQL Server that most people don't know about, which is the use of Window functions to perform cumulative calculations on a SQL Server result set, similar to Excel's Auto Sum feature. This need came to me through a request similar to the one I am going to ...
Learn more

Hello everyone, how are you doing today? In this post, I will demonstrate how to use the XML for Analysis (XLMA) language to be able to back up and restore Analysis Services cubes and dimensions through Transact-SQL (T-SQL) queries, which can be used in a SQL Agent job. to automate this process by letting you automate the backup / restore routines of ...
Learn more

Hi guys how are you ? In this post, I will demonstrate how to identify and monitor the total, free, and used disk space of your instance databases. This post is a complement to my SQL Server post - How to identify and monitor disks, free and used total disk space, where I demonstrated how to identify, analyze and monitor disk space ...
Learn more

Hello guys! All right with you ? In this quick post, I will once again demonstrate the use of OLE Automation and CLR procedures to consume information on the Web and bring it to our SQL Server database so that we can work with this information as needed. This time, I will show you how to query the city, state, neighborhood, and ...
Learn more

Hello guys! How are you ? In this post I will demonstrate how to create your first multidimensional cube in the star schema. This post ended up being done without the idealization that I usually do, because I was writing another blog post and I needed to create a simple Analysis Services cube for the demo and I understood it as an opportunity to talk a ...
Learn more

Hi guys how are you ? Lately, I've been seeing a considerable number of DBA's with questions about SQL Server Agent role permissions, and a lot of questions come up about this topic in Whatsapp groups, including: How to make a non-sysadmin user view jobs? How to make a user other than ...
Learn more

Hello guys! How are you ? In this post I would like to demonstrate how to implement access control and audit logs in using CLR (C #). This has been found to be very useful during auditing processes or when there was a problem due to misuse of the CLR, especially where the SQL Server service user is domain admin or has ...
Learn more

Hello everybody, How are you ? In this post I will demonstrate a very cool script that I developed that aims to generate SQL scripts to back up (reverse engineer) permissions, users, logins and roles of an instance in SQL Server. This script is designed to be used for instance migrations, either for a new server or for ...
Learn more

Hello everybody, How are you ? In this post I will demonstrate a very interesting and common feature in the everyday life of a DBA, which is monitoring disk space on the server. As a DBA, you should always have control over server disk space, so you don't let that space reach critical levels ...
Learn more

Hello everybody, How are you ? In this post I will demonstrate how to export a CLR assembly in SQL Server as a DLL and reverse engineer it to C # source code. The first time I needed to use this feature was when there was an assembly already created and compiled in the database and I needed to change the source code of a procedure, but the version ...
Learn more

Hello guys! All right? In this post I will demonstrate how to back up all SQL Server Agent jobs via command line (CLR C # or Powershell) and export the results to SQL scripts. You can choose to generate 1 script for each job or 1 single script with all jobs in your instance. During SQL Migration ...
Learn more

Hello everyone, everything good? In this post I will demonstrate how to delete a user from a SQL Server instance, which involves deleting users from all databases and then deleting the user's login to the instance. If the user is owner of any database, change the owner of that database (s) and if the user is owner of any job, do the ...
Learn more

Hello guys, In this post I will demonstrate a script that I developed and that has been very useful in my day to day and has the function of copying permissions from one user to another, with the option to just generate the SQL script or actually copy the permissions, which can be at the level of a specific database or in the ...
Learn more

Hello everybody, How are you ? In this post I will demonstrate how to use native SQL Server database support for JSON, a document standard widely used in integrations and Webservices today. This feature is available from the 2016 version of SQL Server and is intended to allow database data to be exported to a string ...
Learn more

Hello everyone, Good afternoon! In this post I will demonstrate a new Transact-SQL feature available from SQL Server 2016 SP1, which is the CREATE OR ALTER command, which can be applied to procedures, functions, triggers and views. For those who work or have worked with Oracle, you know that this is a copy of CREATE OR REPLACE, existing in this DBMS for ...
Learn more

Hi guys good morning! In this post I will talk about something that is not new to SQL Server, is present since SQL Server 2008, but I do not see many people using in their queries, which is the grouping (summarization) using ROLLUP, CUBE and GROUPING SETS . This type of feature is especially useful for generating totals and subtotals ...
Learn more

Hello everyone, Good afternoon! In this post I will show you how to prevent a type of SQL Server problem that can cause a lot of disruption to a DBA's life, takes a long time to resolve, and can be easily avoided and monitored, which is when an IDENTITY column reaches the limit value of your data type and ...
Learn more

Hi guys good morning! In this post I will demonstrate how to do a database integration with Telegram and send messages using CLR (C #), which is Whatsapp's main competitor. Earlier, I demonstrated how to do this same integration in posts: SQL Server - How to do a database integration with Slack and send messages using ...
Learn more