Stairway to U-SQL Level 4: U-SQL and Data Lake Tooling with Visual Studio
A guide to using Visual Studio to create U-SQL projects and scripts.
The Relentless Cloud
The march to the cloud is ongoing and Steve Jones says you should prepare yourself. Even if your company doesn't move.
Number of Rows Read / Actual Rows Read warnings in Plan Explorer
Rob Farley looks at information exposed in query plans about residual predicates and actual rows read, showing how Plan Explorer helps identify the issue.
Databases in Azure: Copy and Exports
Toady we are going to make a copy and export your DB to Azure Storage. Lets get started.
Scary Deployments
Today Steve Jones talks about the problem of having code that people are afraid to change or deploy.
Planning for a Successful Database Lifecycle
Although it is well-known that the best efforts of a development team can be derailed by mistakes in the architecture, design and general governance of a development project, few attempts have been made to describe what needs to be done to increase the chances of success in the development of a database application. William Brewer steps into the breach to itemise what a delivery team needs to succeed.
Delivering Rapid Improvements to SSMS
SSMS has spent years being neglected, merely being kept compatible with SQL Server and its features: But now we have, instead, the promise of monthly delivery of new functionality
Security is Getting Serious
Today Steve Jones notes that back doors could be inserted into chips, which would be a huge problem.
SQL Authentication Via AD Groups Part III: What About Orphaned Users?
With AD Authentication via groups, SQL Server is vulnerable to orphaned Windows users' logins being added to SQL Server at a later date. This article gives an improved user audit script that detects orphaned DB Users and also a delete script.
Encrypting and Decrypting SQL Server Stored Procedures, Views and User-Defined Functions
You work in a shop that puts business or application logic in SQL Server using stored procedures, views and functions to return values to the calling applications or perform tasks. This is not unusual for companies that use the SQL Server layer to perform
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCU THAMRIN Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta...
BCA KCP Gatot Subroto Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit C, Karet...
BCA KCP Kapuk Kamal Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 No. 1A, Jl. Kapuk Kamal Raya Blok DEF, Kamal Muara, Kecamatan Penjaringan,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers