ANSI_NULLS and QUOTED_IDENTIFIER, two potentially dangerous SET options that stored procedures inherit from your session when created

ADOdb is a database abstraction layer for PHP. Compatible with most supported databases, it provides an easy way to use the same code against all databases, Portable code can be written that runs unch...

This walkthrough demonstrates how common Microsoft SQL Server misconfigurations can be chained to achieve full OS-level compromise during penetration tests and red team engagements. Using Impacket's mssqlclient.py, an attacker can authenticate, enumerate databases and logins, escalate to SA via IMPERSONATE or linked servers, enable xp_cmdshell, execute OS commands, and upload files — defenders must harden MSSQL instances to prevent these vectors. #MicrosoftSQLServer #mssqlclient

このブログ記事ではAmazonWebServicesAWS上のMicrosoftSQLServerデプロイメントをスケーリングするための戦略について紹介しますこの戦略ではクラウド上でフルマネージドの高性能なファイルシステムを提供するAmazonFSxを使用しますこの戦略によりAWS上でのSQLServerのパフォーマンスが大幅に改善され分あたりのトランザクション数TPMは従来比で倍になりますまたトランザクションあたりのコストを低減することでコスト効率も向上します全体としてこの戦略は最高性能のSQLServerデータベースをクラウドで実行するコスト効率の高い方法をお探しのお客様にご利用いただけます

このブログ記事はMicrosoftSQLServerのライセンスに関する推奨を生成するAWSCom

Hello guys, If you're preparing for SQL interviews or working on real-world reporting tasks, mastering window functions is no longer optional. They are one of the most powerful tools in SQL which allows you to perform calculations across rows related to the current row without collapsing your result set like GROUP BY does. Window functions like ROW_NUMBER(), RANK(), LEAD(), LAG(), and SUM() OVER help you write cleaner, faster, and more expressive queries—ideal for performance tuning and analytical processing. Let’s dive into the Top 10 SQL window function queries that you must know. --- Java, Unix, Tibco RV and FIX Protocol Tutorial

Hello guys, you might know that along with Oracle and MySQL, Microsoft SQL Server is one of the most popular relational databases in the tech world. It's used in many big organizations like Investment Banks, Insurance companies, and particularly at firms that use Microsoft technologies like Windows Server. With the growing popularity and market share of Microsoft Azure, there is a good chance that the demand for Microsoft SQL Server will also increase, particularly in the cloud. There is already a high demand for both Microsoft SQL Server DBA and Programmers who have SQL Server experience, and that's why it's an excellent decision to learn MSSQL in 2025. --- Java, Unix, Tibco RV and FIX Protocol Tutorial

SQL Server Management Studio 22 just went GA this week, so I figured I'd document my new configuration in a blog post.

In this post I cover the process of setting up, connecting to and interacting with an Azure SQL DB container in QNAP's Container Station.

In this post I cover the process of setting up, connecting to and interacting with an Azure SQL DB container in Podman.

In this post I'm querying Shodan's REST API directly from SQL Server using SQL Server 2025's sp_invoke_external_rest_endpoint.

In this post I dig through some data that Shodan.io provides for internet-exposed SQL Server instances, their versions and locations.

This month's T-SQL Tuesday invitation comes from Brent Ozar, and it's titled "When I’m looking at a query, I bet it’s bad if I see __.".