Blog Posts

SQL Notebooks: On the right track to enhance Data Analysis on SQL Server

Since about a couple of versions ago, Azure Data Studio introduced Jupyter Notebooks support for SQL Server (and with SQL Server 2019 “Big Data Clusters” on the horizon, it was about time)

Read More

How to identify the unit of measure of Extended Events durations

Even if I use Extended Events almost every day, I always forget the unit of measure of each duration counter, since they’re basically arbitrary; Seconds, milliseconds, microseconds?

Read More

Quickly move data between instances for testing using only PowerShell

Quick tip, how many times did a dev ask you to move the PROD/QA data to DEV to test a feature?

Read More

Cast any string directly to XML with auto-escaping characters in SQL Server

Recently I had to look up the definition for a bunch of SQL objects and didn’t want to manually retrieve them manually in SSMS (with Create Scripts) or Visual Studio (by searching the object name in my TFS repository).

Read More

How to Show Better Execution Plans in Azure Data Studio

Azure Data Studio is starting to mature and some neat features are coming to the vscode-based (and now multidatabase and multiplatform) tool.

Read More

Load data directly in SQL Server from a xlsx file, without OLEDB or Excel, using Powershell

I don’t know you, but people from other BU are old fashioned guys that do everything by hand, and then send you an Excel file to “put this data in the database” or “find info related to this codes”.

Read More

A SQL Server Permission Report in PowerBI

What it is and how to get it When working with SQL Instances that have lots of databases, sensitive data and equally lots of users/applications that accesses those, it can get pretty troublesome to keep track of every user, for every database, down to the single column/action.

Read More

Why identity values can jump by the 1000's ? Is it normal?

It must have happened you at least once to find identity columns with values that from one row to the next one jump by 1000’s rows, of course without having anyone deleting the rows in between, how this occurs?

Read More

Row Level Security Performance Implications

A conversation had me wondering about performance implications in SQL Server RLS feature, specifically on how to mitigate the performance impact;

Read More

A quick function to remove (or keep only) string patterns from SQL Server Strings

Working with strings in SQL Server isn’t as easy or powerful as using any programming language, but, I’m sure that more than once you had to to some data manipulation directly in the database, this may help you out, and it doesn’t use Loops, CLR or XML

Read More
Categories
Tags