A SQL script to automatically infer the data types of data that someone just dumped in your DB with no effort
Do you know the feeling when someone gives you a flat file to import, without any schema information?
Read MoreHow to configure a Linked Server to a modern version of Oracle in SQL Server
It definitely was his plan, all along Following an Oracle migration to a new version (19c on AWS RDS), I had to update the related linked server in a SQL Instance, upgrading the Oracle Client to the latest version.
Read MoreHow to ship SQL Jupyter Notebooks and Books directly to Azure Data Studio by creating an extension in the Marketplace
The recently released Extension Generator for Azure Data Studio has opened up yet another way to ship Notebooks and Books to ADS allowing you to easily author your extensions.
Read MoreThe SQL Server Diagnostic Book is now on the Azure Data Studio Marketplace!
Great News Everyone! As detailed in my previous article , you can now create extensions containing SQL (note)books and publish them on the Azure Data Studio Marketplace!
Read MoreYou can now script your database objects as a Notebook using SQL Server Management Studio 18.5+
Great News Everyone! Microsoft just dropped SSMS 18.5 after almost 5 long months without any updates; this new release fixes a lot of bugs and introduces a few new features, above them all I’m now showing you the following.
Read MoreA Self-deployable TICK Stack for ingesting data, monitoring and alerting for any service (including SQL Server)
Oh boy, this is a spinoff of my previous post on “How To Use Grafana (On Docker) To Monitor Your Sql Server (Eventually On Docker Too) – Feat.
Read MoreHow to update a SQL Server container on Docker for Windows (spoiler - there is a catch)
With the 1st CU for SQL 2019 released just yesterday, and Microsoft updating the docker image right away, the only natural response for me was to update the docker instance that I showed you how to deploy a few months back.
Read MoreUse SQL Server on Docker for Windows, the easy way
I wanted to install and test SQL Server 2019 on a new machine, without the hassle to create a VM from scratch, since I had none of my resources from this new place, that’s when I remembered about Docker and how Microsoft is slowing reaching feature parity for SQL on LInux , moreover, I didn’t need any of the unsupported stuff, so.
Read MoreHow 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 MoreLoad 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 MoreRow 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 MoreA 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 MoreA PowerBI Report for SQL Server Agent Jobs
As my “community service” this month, I’ve worked on this neat (I hope!
Read MoreCreating a Perfmon and Filestats reports in PowerBI [Part 1]
If you work for a big company, you may have a bunch of instances/databases under your control, you ran whatever monitoring tool has been provided and everybody is happy; But if your’re like me and you’re working for a big number of customers, each one with a different version of SQL and own configuration/security policies, with no monitoring tool directly available, and have to answer the question “what happened to the instance the other night” you may be a little bit overwhelmed.
Read MoreHow to avoid the traps when dealing with parallelism
I work with a vendor application which needs to do all sorts of data crunching in some nightly batches, and, depending on the size of data, this process may take a lot of time.
Read More