Prototyping is my favorite part of programming. I like building new stuff and getting things working. It’s no surprise, then, that I am a big fan of MongoDB and NoSQL in general. Don’t get me wrong: I ...

Before you can document your SQL Server environment with SQL Power Doc you'll to meet the following requirements: Permissions - SQL Power Doc makes connections to standalone SQL Server instances using ...

Sometimes it will be necessary to create more dynamic interactions to allow the user to extract any type of information available from the AI agent. With this problem in mind, it is possible to ...

This system stored procedure takes a table name as a parameter and generates a MERGE statement containing all the table data. This is useful if you need to migrate static data between databases, eg.

Ademola is a backend developer with experience with Django, a Python web framework. He enjoys teaching others what he knows about the web; hence he decided to become a technical content writer. Once ...

Four years ago, I created a Query performance insights library (QPI). This is a T-SQL library that enables troubleshooting and monitoring performance on #AzureSQL #ManagedInstance. While I worked on ...

Another week and another useful dbatools snippet for you today. Last week at work I was given a folder of 1,500 scripts – each containing a create table statement. Can you imagine having to open each ...

Immortalized by “Little Bobby Drop Tables” in XKCD 327, SQL injection (SQLi) was first discovered in 1998, yet continues to plague web applications across the internet. Even the OWASP Top Ten lists ...

We are excited to announce the public preview availability of two new command line tools for SQL Server: The mssql-scripter tool enables developers, DBAs, and sysadmins to generate CREATE and INSERT T ...