page.title.tag — Dirceu Resende

SQL Server 2025 - We finally have native regular expression (regex)

December 30, 2025 29 min read

Azure SQL Managed Instance - Warning! Why Shrink Can Destroy Your Performance

December 28, 2025 5 min read

[Live 04/09/2023] - Database Tips for Developers - SQL Server | 6th edition

September 1, 2023 1 min read

SQL Server - How to identify and compress tables and indexes without data compression

August 24, 2023 8 min read

SQL Server - How to identify the date when the trial / evaluation license will expire

August 18, 2023 1 min read

SQL Server - How to generate a script with all database indexes

August 14, 2023 8 min read

SQL Server and Azure SQL - How to Create a Calendar Table Using SQL Including Holidays

August 11, 2023 21 min read

SQL Server and Azure SQL - Challenge for Grouping Data Using Hierarchies

August 11, 2023 4 min read

SQL Server - The SQL Agent Job Execution History Is Disappearing

May 10, 2023 7 min read

SQL Server - How to Synchronize Table Data Between Different Databases Using Trigger

August 13, 2022 4 min read

SQL Server - How to Validate Email and Email Domain Using SQLClr (C#)

May 26, 2022 14 min read

SQL Server - How to unlock a login without changing/resetting the password

May 21, 2022 2 min read

SQL Server - Password Policies: Expiration, Mandatory Change and Login Lockout After N Attempts

May 21, 2022 11 min read

SQL Server - How to increase query speed by changing the server power plan

May 17, 2022 6 min read

SQL Server - ISNULL vs COALESCE: Understanding the Differences Between the Two Functions

May 8, 2022 6 min read

SQL Server and Azure SQL Database - How to Return CPU and Memory Usage Using T-SQL

May 3, 2022 4 min read

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

May 2, 2022 6 min read

SQL Server - How to identify and monitor trigger execution

May 2, 2022 7 min read

SQL Server and Azure SQL Database - How to Identify Key Lookup Occurrences Through Plan Cache

April 14, 2022 7 min read

SQL Server - How to identify all missing indexes in a database

April 8, 2022 8 min read

Azure SQL Database - STRING_SPLIT function finally gets a parameter to include position numbers

November 5, 2021 1 min read

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

October 1, 2021 5 min read

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

September 29, 2021 12 min read

SQL Server - Using TRANSLATE() to Replace Multiple REPLACE() Calls

September 28, 2021 7 min read

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

June 15, 2021 28 min read

SQL Server - How to filter and separate the number and text from a string

June 14, 2021 1 min read

SQL Server - How to write numbers in full in Portuguese and English using T-SQL function

June 10, 2021 7 min read

SQL Server is extremely fast. You just do not know how to use it!

April 28, 2021 1 min read

Black Friday discounts on SQL Server training (Buy my course hahaha)

November 27, 2020 3 min read

SQL Server - The new GREATEST and LEAST functions

November 27, 2020 2 min read

SQL Server - How to Find the Last Login Date of a User

November 9, 2020 9 min read

Want to learn Azure hands-on? Discover my new "Databases on Azure" training

October 30, 2020 2 min read

SQL Server - How to Know How Long a Specific Database Has Been Online

October 30, 2020 2 min read

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

July 6, 2020 11 min read

SQL Server and Power BI - How to Load Stored Procedure Data in SQL Server with DirectQuery

June 16, 2020 7 min read

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

April 13, 2020 5 min read

SQL Server - User Can Only Connect with Sysadmin Permission: Login Failed for User, Reason: Login-Based Server Access Validation Failed with an Infrastructure Error

February 5, 2020 2 min read

SQL Server - Using STRING_SPLIT to Transform Strings from One Row into Columns

February 5, 2020 6 min read

SQL Server - Encrypting Passwords with Symmetric Encryption Functions: EncryptByPassPhrase and DecryptByPassPhrase

December 26, 2019 13 min read

How was SQL Server ES #14 - SQL Server 2019 and Analyzing Large Data Volumes with Power BI

December 23, 2019 1 min read

SQL Server - I set Max Server Memory to 0 and now I cannot connect to the instance

December 23, 2019 3 min read

SQL Server - TCP Dynamic Ports vs TCP Port: Dynamic vs Static Port

December 13, 2019 5 min read

SQL Server - String or Binary Data Would Be Truncated: What It Is, How to Identify the Root Cause and How to Fix It

December 3, 2019 8 min read

SQL Server - How to send messages to WhatsApp contacts, groups and broadcast lists via API

December 2, 2019 35 min read

SQL Server - charindexada: A different function to split delimited strings

November 3, 2019 4 min read

How to use PowerShell and the API with Agent or SSIS to automate refresh of a Power BI dataset

November 3, 2019 7 min read

SQL Server - Power BI Gateway Problem When Using External IP or Hostname to Access the Database

November 3, 2019 5 min read

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

August 18, 2019 5 min read

SQL Server - Useful Day-to-Day DBA Queries You Always Have to Search for Online

July 15, 2019 73 min read

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

July 14, 2019 6 min read

SQL Server - Statements Could Not Be Prepared: Case Expressions May Only Be Nested to Level 10

July 6, 2019 2 min read

SQL Server Tools That Every DBA Should Know - Live at SQL Norte

July 5, 2019 1 min read

stp_SecurityChecklist - Best Practices and Security Checklist for SQL Server

June 23, 2019 3 min read

SQL Server - What Is a Bitwise Operation and How to Store Multiple Values in the Same Column

June 21, 2019 5 min read

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

May 24, 2019 1 min read

SQL Server - Security Checklist - A stored procedure with more than 70 security items to validate your database

May 12, 2019 4 min read

SQL Server - How to connect using the DAC (Dedicated Admin Connection) without SQL Browser

May 10, 2019 6 min read

SQL Server - Permissions to Use OLE Automation: Yes, the Documentation Is Wrong

May 7, 2019 4 min read

SQL Server - When You Should Use ORDER BY in Queries and When You Should Never Use It

February 24, 2019 5 min read

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

February 24, 2019 7 min read

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

February 24, 2019 16 min read

SQL Server - How to identify and collect information from slow queries using Extended Events (XE)

February 19, 2019 11 min read

SQL Server - Using Calculated or Computed Columns for Performance Tuning

February 13, 2019 8 min read

SQL Server - How to avoid and protect yourself from Ransomware attacks, like WannaCry, on your database server

February 12, 2019 10 min read

SQL Server - How to avoid brute force attacks on your database

February 11, 2019 21 min read

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

February 8, 2019 1 min read

SQL Server Performance Tuning Tips - Implicit Conversion: Never Again

February 3, 2019 13 min read

SQL Server - NOLOCK vs READPAST: Do You Know the Difference Between the Two?

January 27, 2019 5 min read

SQL Server 2014 - How to estimate progress and remaining time for index creation

January 26, 2019 4 min read

SQL Server - How to identify and change the default schema of database users

January 26, 2019 10 min read

SQL Server - How to Use Auditing to Map Real Required Permissions for a User

January 20, 2019 8 min read

SQL Server - How to identify instance startup parameters using T-SQL

January 11, 2019 3 min read

SQL Server - What Is the Difference Between @@ERROR and ERROR_NUMBER()?

January 1, 2019 4 min read

SQL Server Express Challenge - Is It Possible to Exceed the 10 GB Data Limit in a Database?

December 30, 2018 14 min read

What changed in SQL Server 2012 regarding T-SQL - from the developers perspective

December 29, 2018 19 min read

SQL Server - How to identify the data type of columns and parameters of tables, views, stored procedures, and functions

December 29, 2018 5 min read

SQL Server - How to disable the "sa" login while minimizing impacts

December 22, 2018 6 min read

SQL Server - How to hide databases from unauthorized users

December 9, 2018 4 min read

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

December 9, 2018 5 min read

SQL Server - The Activated Proc dbo.sp_syspolicy_events_reader Running on Queue msdb.dbo.syspolicy_event_queue

December 9, 2018 4 min read

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

December 6, 2018 7 min read

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

December 1, 2018 9 min read

SQL Server - How to Use EXECUTE AS to Run Commands as Another User (Impersonate) and How to Prevent It

November 13, 2018 29 min read

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

November 11, 2018 17 min read

SQL Server 2008 - How to encrypt your data using Transparent Data Encryption (TDE)

October 20, 2018 13 min read

SQL Server 2016 - How to encrypt your data using Always Encrypted

October 20, 2018 12 min read

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

October 15, 2018 3 min read

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

October 7, 2018 2 min read

SQL Server 2019 - Understanding the row estimation changes for table variables

October 7, 2018 1 min read

SQL Server 2019 - List of new features and resources

October 1, 2018 18 min read

What changed in SQL Server 2008 regarding T-SQL - From the developers perspective

September 26, 2018 6 min read

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

September 25, 2018 2 min read

SQL Server - How to Use the MERGE Command to Insert, Update and Delete Data with Just One Command

September 22, 2018 15 min read

SQL Server - Using Trace Flag 3226 to Avoid Recording Informational Messages Generated by Backups in the SQL Server Log

September 22, 2018 3 min read

SQL Server - How to pass a table as a parameter to Stored Procedures and Functions

September 18, 2018 8 min read

SQL Server - How to Use the Management Studio Debugger

September 10, 2018 1 min read

SQL Server and Power BI - How to Analyze and Generate Statistics from WhatsApp Group Conversations

August 18, 2018 18 min read

[Video] - Introduction to SQLCLR

August 4, 2018 1 min read

SQL Server - How to create code versioning for your Stored Procedures in HTML with change comments

July 16, 2018 10 min read

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

July 15, 2018 8 min read

SQL Server - Using CROSS JOIN (Cartesian Product) to Create Rows in the Query Result

July 14, 2018 4 min read

SQL Server - How to identify a slow or "heavy" query in your database

July 8, 2018 26 min read

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

July 8, 2018 9 min read

SQL Server - How to enable the sa user

July 8, 2018 4 min read

SQL Server - Understanding In-Memory OLTP (Hekaton) Tables: Durable vs Non-Durable

June 24, 2018 16 min read

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

June 20, 2018 3 min read

SQL Server - Rounding numbers following the ABNT NBR 5891 standard

June 15, 2018 7 min read

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

June 10, 2018 9 min read

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

June 9, 2018 1 min read

SQL Server Express and Developer - How Far Can We Go with the Free Versions of SQL Server?

June 2, 2018 7 min read

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

May 26, 2018 4 min read

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

May 23, 2018 18 min read

SQL Server - How to Use Regular Expressions (REGEXP) in Your Database

May 22, 2018 22 min read

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

May 9, 2018 6 min read

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

May 8, 2018 2 min read

SQL Server - How to View the Full Job Execution Return Message Even When It Exceeds 4000 Characters

May 2, 2018 3 min read

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

April 26, 2018 1 min read

SQL Server - How to standardize the collation of all database columns

March 15, 2018 22 min read

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

March 4, 2018 10 min read

SQL Server 2017 - How to pause an index rebuild using Resumable Online Index Rebuilds

February 14, 2018 7 min read

SQL Server - Using Resource Governor for Greater Control of Server Resources

February 14, 2018 15 min read

SQL Server 2016 - How to "travel through time" using Temporal Tables

February 9, 2018 8 min read

SQL Server - How to monitor and audit data changes in tables using Change Data Capture (CDC)

February 7, 2018 9 min read

SQL Server - Trigger to Prevent and Block Changes in Tables

February 4, 2018 3 min read

Microsoft Certifications - Study material in Portuguese to obtain your first certification (MTA)

January 31, 2018 18 min read

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

January 31, 2018 2 min read

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

January 21, 2018 3 min read

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

January 9, 2018 8 min read

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

January 3, 2018 10 min read

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

November 19, 2017 2 min read

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

November 15, 2017 2 min read

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

October 31, 2017 1 min read

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

October 29, 2017 24 min read

SQL Server - How to practically share your execution plans on the Web

October 20, 2017 3 min read

SQL Server - How to create an email alert for locks and blocked sessions in the instance using DMV's

October 17, 2017 8 min read

SQL Server - How to create error and exception monitoring in your database using Extended Events (XE)

October 15, 2017 9 min read

SQL Server - Using the FORMAT() Function to Apply Masks and Formatting to Numbers and Dates

October 10, 2017 15 min read

SQL Server - Introduction to Performance Tuning Study

September 30, 2017 16 min read

SQL Server - How to identify and collect information from slow queries using Trace (SQL Server Profiler)

September 30, 2017 5 min read

SQL Server - How to generate deadlock history monitoring for routine failure analysis

September 30, 2017 12 min read

SQL Server - How to search for a string in the code of stored procedures called by SQL Agent jobs

September 17, 2017 5 min read

SQL Server - Write T-SQL Like a Ninja Using Redgate SQL Prompt

September 3, 2017 6 min read

SQL Server - How to read and write events in Windows Event Viewer using CLR (C#)

September 2, 2017 5 min read

SQL Server - File Operations Using xp_cmdshell: How to List, Read, Write, Copy, Delete and Move Files

August 29, 2017 6 min read

SQL Server - How to query Active Directory (AD) information using Linked Server (ADSI)

August 23, 2017 5 min read

SQL Server - How to recover the source code of an encrypted object (WITH ENCRYPTION)

August 22, 2017 8 min read

SQL Server - How to identify occurrences of a specific character in a string or table

August 15, 2017 6 min read

3rd SQL Server ES Chapter Meeting - 08/26/2017

August 10, 2017 1 min read

SQL Server - How to convert an RTF string to text (Remove RTF tags) using CLR (C#) or PowerShell

August 8, 2017 8 min read

SQL Server - How to convert an HTML string to text (Remove HTML tags) using CLR (C#)

August 8, 2017 3 min read

Analysis Services - How to Use XMLA or PowerShell to Process Cubes and Dimensions via T-SQL or SQL Agent Job

August 6, 2017 10 min read

Microsoft MCSA 70-778 (Analyzing and Visualizing Data with Power BI) and 70-779 (Analyzing and Visualizing Data with Microsoft Excel) free certification exams (beta) until 09/15/2017

July 28, 2017 2 min read

SQL Server - Query to Return Active Sessions with sp_WhoIsActive Without Consuming TempDB

July 25, 2017 13 min read

SQL Server - How to track Correios packages and items after WEBSRO deactivation

July 21, 2017 6 min read

SQL Server - Table-Valued Function to Split a String into Rows with Size Up to N Characters

July 21, 2017 2 min read

SQL Server - Audit Trigger for Permissions and Privileges at Database and Instance Level (GRANT / REVOKE)

July 19, 2017 2 min read

Microsoft MCSE 70-776 certification exam (Performing Big Data Engineering on Microsoft Cloud Services) for free (beta) until 09/08/2017

July 14, 2017 2 min read

2nd SQL Server ES Chapter Meeting - 06/10/2017

May 25, 2017 1 min read

Microsoft certification exams: 50% discount for students (undergraduate, graduate, master's, doctorate)

May 10, 2017 1 min read

SQL Server 2017 and Azure SQL Managed Instance

April 21, 2017 6 min read

SQL Server - How to calculate the difference in years (age) between two dates using T-SQL or CLR

April 9, 2017 4 min read

SQL Server - Understanding and Disabling Autocommit

April 3, 2017 5 min read

Analysis Services - Querying Catalog Views from SQL Server

April 2, 2017 3 min read

Analysis Services (SSAS) - How to Query Information and Process Commands via XMLA Command Line from SQL Server

April 2, 2017 4 min read

1st SQL Server Community Meeting - ES

March 30, 2017 1 min read

SQL Server - Performance Comparison Between Scalar Function (UDF) and CLR Scalar Function

March 24, 2017 14 min read

SQL Server - Your Instance Constantly Shows "Starting Up Database" and "Databases in Recovery" Messages: Learn About AUTO_CLOSE

March 23, 2017 5 min read

SQL Server - How to export and import tabular data files (for example, CSV) using CLR (C#)

March 20, 2017 8 min read

SQL Server - How to query and consume WordPress RSS feeds using CLR or xp_cmdshell (cURL)

March 19, 2017 8 min read

SQL Server Management Studio (SSMS) - How to Enable the Dark Theme

March 12, 2017 3 min read

SQL Server - How to calculate the distance between two points using the Google API (ZIP code, address, or latitude and longitude)

March 7, 2017 4 min read

SQL Server - How to create an Excel-like AutoSum using Window functions (Running totals)

March 6, 2017 4 min read

Analysis Services - How to Use XMLA for Backup and Restore of Cubes via T-SQL Command Line

March 5, 2017 3 min read

SQL Server - How to identify and monitor total, free, and used disk space by database datafiles

March 5, 2017 8 min read

SQL Server 2016 - How to query ZIP code information using the Bemean API and the JSON_VALUE function

March 5, 2017 4 min read

SQL Server - Understanding SQL Agent Permissions and Roles: SQLAgentUserRole, SQLAgentReaderRole, SQLAgentOperatorRole

February 28, 2017 7 min read

SQL Server - Implementing Access Control and Audit Logs in CLR (C#) Usage

February 28, 2017 5 min read

SQL Server - How to Transfer Logins Between Instances Generating Reverse Engineering of Users, Logins and Permissions

February 27, 2017 15 min read

SQL Server - How to identify and monitor disks, total, free, and used disk space

February 26, 2017 10 min read

SQL Server - How to export a CLR assembly as a DLL and reverse engineer it to C# source code

February 25, 2017 4 min read

SQL Server - How to back up all SQL Agent jobs via command line (CLR C# or PowerShell)

February 22, 2017 9 min read

SQL Server - How to delete a user from an instance

February 21, 2017 3 min read

SQL Server - How to copy/replicate a user's permissions

February 19, 2017 11 min read

SQL Server 2016 - Using native JSON support (JSON_VALUE, JSON_QUERY, OPENJSON, FOR JSON, ISJSON, JSON_MODIFY)

February 19, 2017 16 min read

SQL Server 2016 SP1 - CREATE OR ALTER in procedures, functions, triggers, and views

February 12, 2017 3 min read

SQL Server - Grouping data using ROLLUP, CUBE and GROUPING SETS

February 12, 2017 9 min read

SQL Server - How to identify, monitor, and prevent overflow in IDENTITY and SEQUENCE columns of tables with many rows

February 8, 2017 6 min read

SQL Server - How to integrate the database with Telegram and send messages using CLR (C#)

February 5, 2017 8 min read

SQL Server - How to integrate the database with Slack and send messages using CLR (C#)

February 4, 2017 9 min read

SQL Server - How to integrate the database with Ryver and send messages using CLR (C#)

February 4, 2017 5 min read

SQL Server - How to send SMS Torpedoes using the CLR (C#) and the Mais Resultado API (PG Soluções)

February 4, 2017 7 min read

Microsoft MCSE 70-775 certification exam (Perform Data Engineering on Microsoft Azure HDInsight) for free (beta) until 03/31/2017

February 2, 2017 2 min read

SQL Server - How to rename the server / instance in the database when the machine name is changed in the OS

February 2, 2017 1 min read

SQL Server - How to send emails from the database using CLR C#

January 31, 2017 8 min read

SQL Server - How to find out when the instance was installed (installation date)

January 29, 2017 1 min read

SQL Server - How to send the result of a query by email in HTML format using the CLR (C#)

January 28, 2017 9 min read

SQL Server - How to monitor your favorite TV shows by consuming a JSON webservice with JSON_VALUE and CLR (C#)

January 25, 2017 4 min read

MCSE 70-773 Certification Exam (Analyzing Big Data with Microsoft R) for free (Beta) until 02/28/2017

January 12, 2017 2 min read

SQL Server 2016 MCSA certification exams (70-764 and 70-767) for free (Beta) until 01/31/2017

January 6, 2017 3 min read

SQL Server - How to create a Secret Santa draw using Transact-SQL

December 27, 2016 3 min read

SQL Server - Msg 443: Invalid Use of a Side-Effecting Operator RAND Within a Function

December 26, 2016 3 min read

SQL Server - Using the SQLQueryStress Tool to Optimize Your SQL Queries

December 25, 2016 4 min read

SQL Server - Why You Should Not Use SET ANSI_WARNINGS OFF

December 23, 2016 5 min read

Reporting Services (SSRS) - Error when deleting mobile reports (Error invoking the authorization extension)

December 4, 2016 5 min read

SQL Server - How to encrypt and decrypt passwords (with Salt) using CLR (C#)

December 2, 2016 4 min read

SQL Server - How to query national, state, municipal, and optional holidays from an API using OLE Automation and CLR (C#)

December 1, 2016 4 min read

SQL Server - How to identify weak, empty, or user-name passwords

November 24, 2016 4 min read

Login failed for user error when connecting to SQL Server from a .NET (C#) application

November 23, 2016 6 min read

SQL Server - How to integrate with FTP and list, upload, and download files using CLR (C#)

November 6, 2016 18 min read

SQL Server - Session Running for a Long Time with the SpreadRequest / DatabaseMail Command

October 31, 2016 3 min read

How to Install and Configure Microsoft SQL Server 2016 on Windows Server 2016

October 31, 2016 11 min read

How to create a random password generator written in PHP, C# (CSharp) or Transact-SQL (T-SQL)

September 18, 2016 3 min read

How to use the Pushbullet API to send SMS messages in C#, PHP, Java or through SQL Server (with CLR)

September 11, 2016 9 min read

SQL Server - How to list and kill Windows processes using CLR (C#)

September 11, 2016 5 min read

SQL Server - How to run PowerShell and Prompt-DOS (MS-DOS) scripts using CLR (C#)

September 11, 2016 6 min read

SQL Server - How to read, list, create, update, and delete Windows Registry keys with CLR (C#)

September 10, 2016 7 min read

SQL Server - How to export the source code of all Stored Procedures, Functions, Views and Triggers from a database to .sql files

August 25, 2016 6 min read

SQL Server - How to stop, start, and list Windows services remotely

August 7, 2016 8 min read

SQL Server - How to Check if a Server is Responding Using Ping and CLR (C#)

August 6, 2016 1 min read

SQL Server - How to create a data change history for your tables (audit logs)

July 17, 2016 7 min read

SQL Server - The Data Types Datetime and Time Are Incompatible in the Add Operator

July 16, 2016 3 min read

SQL Server - Using sp_WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries and Much More

June 26, 2016 15 min read

SQL Server - How to concatenate rows grouping data by a column (Grouped concatenation)

June 19, 2016 9 min read

SQL Server - How to read, import and export data from XML files

June 18, 2016 27 min read

SQL Server - The Server May Be Running Out of Resources or the Assembly May Not Be Trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE

June 16, 2016 2 min read

SQL Server - Importing and Exporting Data from Excel Spreadsheets

June 15, 2016 5 min read

SQL Server - How to batch run all .sql scripts from a folder or directory with SQLCMD

June 14, 2016 3 min read

SQL Server - How to install the Microsoft.ACE.OLEDB.12.0 and Microsoft.Jet.OLEDB.4.0 drivers

June 5, 2016 7 min read

SQL Server - How to export database data to a text file (CLR, OLE, BCP)

June 3, 2016 16 min read

SQL Server - How to import text files into the database (OLE Automation, CLR, BCP, BULK INSERT, OPENROWSET)

May 29, 2016 7 min read

SQL Server - Error Using OPENROWSET: Access to the Remote Server Is Denied Because No Login-Mapping Exists

May 28, 2016 3 min read

SQL Server - Cannot resolve the collation conflict between ... in the equal to operation.

May 25, 2016 6 min read

SQL Server - How to resolve the Warning Null value is eliminated by an aggregate or other SET operation

May 22, 2016 2 min read

SQL Server - Heterogeneous Queries Require the ANSI_NULLS and ANSI_WARNINGS Options to Be Set for the Connection

May 22, 2016 3 min read

SQL Server - How to list, read, write, copy, delete and move files with CLR (C#)

May 7, 2016 11 min read

SQL Server - How to perform UPDATE and DELETE with TOP x records

May 7, 2016 2 min read

SQL Server - The Danger of Using JOIN Between Columns of Different Data Types

April 29, 2016 2 min read

Using Sequences in User-Defined Functions in SQL Server

April 28, 2016 2 min read

SQL Server 2012 - Working with Sequences and comparisons with IDENTITY

April 28, 2016 7 min read

SQL Server - Querying Instance Information from Windows Registry Using sys.dm_server_registry and xp_instance_regread

April 23, 2016 3 min read

Using the Default SQL Server Trace to Audit Events - fn_trace_gettable()

April 23, 2016 5 min read

SQL Server - The Database Owner SID Recorded in the Master Database Differs from the Database Owner SID Recorded in Database

April 21, 2016 3 min read

Monitoring DDL and DCL operations using SQL Server fn_trace_gettable

April 4, 2016 3 min read

Monitoring automatic space growth (Autogrowth) events in SQL Server databases

April 4, 2016 2 min read

SQL Server 2016 - List of new features and resources

April 3, 2016 9 min read

How to retrieve the greatest value among multiple columns in a SQL Server table

April 2, 2016 2 min read

How to find the last access date of a table or view and the last execution of a stored procedure in SQL Server

April 2, 2016 3 min read

CLR - Solving the System.Security.Permissions.FileIOPermission problem in SQL Server

March 30, 2016 2 min read

Performing POST and GET requests using CLR (C#) in SQL Server

March 29, 2016 20 min read

How to List Jobs (schedules, commands, steps) via Query in SQL Server

March 28, 2016 5 min read

Introduction to SQL CLR (Common Language Runtime) in SQL Server

March 24, 2016 18 min read

Querying Correios object tracking through SQL Server

January 3, 2016 3 min read

How to split a string into a table of substrings using a delimiter in SQL Server

January 3, 2016 2 min read

Consuming the Google Maps API to get address or ZIP code information in SQL Server

January 3, 2016 4 min read

How to reset and recover the SQL Server Administrator (sa) password

November 29, 2015 4 min read

Valid CPF and CNPJ generator for SQL Server environment testing

November 22, 2015 3 min read

How to Convert Integers to Hexadecimal, Octal and Binary (and Vice Versa) in SQL Server

November 22, 2015 2 min read

How to Convert Numbers to Roman Numerals in SQL Server

November 21, 2015 1 min read

How to convert milliseconds, seconds or minutes to TIME in SQL Server

November 18, 2015 1 min read

Identifying tables with IDENTITY columns in SQL Server

November 16, 2015 1 min read

Mapping Dependencies Between Objects in SQL Server

October 24, 2015 10 min read

Auditing in SQL Server (Server Audit)

October 22, 2015 11 min read

Understanding how indexes work in SQL Server

October 11, 2015 18 min read

How to identify, delete and recreate Foreign Keys (FK) of a table in SQL Server

October 6, 2015 2 min read

Enabling and using dedicated remote administrator connection (DAC) in SQL Server

October 4, 2015 4 min read

Solving .NET Framework DLL Assembly signature problems in SQL Server

September 10, 2015 1 min read

SQL Server - How to learn from basics to certification (Courses, Virtual Labs, Virtual Academy)

September 8, 2015 2 min read

Checking Permissions, Privileges and Accesses of a Database User in SQL Server

September 7, 2015 21 min read

Enabling OLE Automation via T-SQL in SQL Server

September 7, 2015 1 min read

How to identify the port used by the SQL Server instance

August 30, 2015 3 min read

SQL Server undocumented extended procedures

August 28, 2015 6 min read

How to Query SQL Agent Startup History in SQL Server

August 23, 2015 2 min read

How to Calculate Shipping Cost and Delivery Time Using Correios WebService in SQL Server

August 23, 2015 5 min read

How to Query Postal Code (CEP) Information in SQL Server

August 23, 2015 2 min read

How to Identify Inactive Sessions with Open Transactions in SQL Server

August 22, 2015 2 min read

How to identify connected users in SQL Server

August 22, 2015 1 min read

How to identify running jobs via Query in SQL Server

August 22, 2015 6 min read

How to calculate business days in SQL Server (dCalendario Table)

July 29, 2015 7 min read

Free SQL Server ebooks for Download

July 29, 2015 3 min read

How to create a table with the national, state and movable holidays in SQL Server

July 28, 2015 5 min read

How to remove accents and special characters from a string in SQL Server

July 27, 2015 2 min read

Consuming the Google Maps API using OLE Automation in SQL Server

July 27, 2015 3 min read

How to use JSON in SQL Server 2008, 2012 and 2014 - Reading JSON strings, importing into the database and exporting to XML

July 25, 2015 14 min read

How to kill all connections to a database in SQL Server

July 19, 2015 3 min read

SQL Server - How to Implement Login Audit and Control (Logon Trigger)

July 19, 2015 9 min read

How to create an audit trigger to log object manipulation in SQL Server

July 18, 2015 6 min read

How to export data from a SQL Server table to HTML

July 12, 2015 7 min read

How to create an audit to monitor the creation, modification and deletion of Jobs in SQL Server

June 5, 2015 4 min read

How to validate state registration using a T-SQL function in SQL Server

May 18, 2015 15 min read

SQL Server - Timeout When Executing a Query on a Linked Server

May 8, 2015 1 min read

How to convert the run_date and run_time columns from job_history to datetime in SQL Server

May 7, 2015 2 min read

How to estimate the remaining time for a backup in SQL Server

May 6, 2015 1 min read

How to register and create server groups in SQL Server Management Studio (and set a color for each server)

March 19, 2015 2 min read

SQL Server - How to enable and configure Database Mail to send and monitor emails through the database (sp_send_dbmail)

March 19, 2015 12 min read

Compressing all tables in a database in SQL Server

March 17, 2015 8 min read

Running a Command in All Databases of the SQL Server Instance

March 8, 2015 3 min read

Working with cryptographic functions (MD4, MD5, SHA1, SHA2_256 and SHA2_512) using the HASHBYTES function of SQL Server

February 18, 2015 2 min read

Working with the Base64 encryption algorithm in SQL Server

February 18, 2015 2 min read

Validating CPF, CNPJ, Email, Phone and ZIP Code in SQL Server

February 17, 2015 6 min read

Similarities and Differences Between DELETE, TRUNCATE and DROP TABLE

February 17, 2015 4 min read

Identifying and resolving orphaned users in SQL Server with sp_change_users_login

February 8, 2015 9 min read

Arithmetic Overflow in the SQL Server 2008 sys.syscolumns catalog view

February 8, 2015 3 min read

Working with Service Broker in Microsoft SQL Server

December 31, 2014 30 min read

SQL Server SET commands

December 20, 2014 8 min read

SQLCMD - The SQL Server command-line utility

November 30, 2014 5 min read

Installing and configuring SQL Server 2014 on Windows Server 2012 R2

November 29, 2014 9 min read

Searching for a string in a job (or step) in SQL Server

June 14, 2014 3 min read

SQL Server - Splitting strings into substrings using a separator (Split string)

June 14, 2014 9 min read