Red Gate brings SQL in the City back to London for the third year running
Data professionals are invited to attend Red Gate’s free SQL in the City event for a day of SQL Server training in London.
SQL Server's Auto Update Statistics Async Option
I have been trying to tune my SQL Server and I noticed a few database settings for statistics. I also read the previous tip on automatic statistics updates. Could you please describe the Auto Create Statistics Async option? How is this configured and when should I use it and when should I avoid using it?
Car Data
Today's automobiles might collect more data than you think. All that might data gives us opportunities to find new and interesting ways to use this data with software.
Stairway to SQL PowerShell Level 5: SQL Server PowerShell Building Blocks
You should be on your way with PowerShell with the previous levels and now the topic shifts to using Functions and Assemblies built in to .NET for use with automation. This topic will be used in your PowerShell adventures throughout your career and this Stairway.
What Counts for a DBA: Laziness
Louis Davidson is willing to bet that a relatively small handful of lazy people have done more for the world than all of the hard working people combined.
Data Science Laboratory System - Instrumentation
It is sensible to check the performance of different solutions to data analysis in 'lab' conditions. Measurement by instrumentation makes it easier to develop systems that are efficient.
Toggle Switches
SQL Server has grown and expanded to provide administrators and developers with a great deal of information on how it processes queries. However Steve Jones asks if you want more information and options for tuning.
Use of Identity Property to Resolve Concurrency Issues
This article describes how the identity property was used to resolve contention in a database
Creating Custom T-SQL Conditions and Policies for SQL Server Policy-Based Management
In SQL Server, the built in conditions and policies are a great place to get started with monitoring your environment, but there are no facets for some aspects of SQL Server I want to monitor. How can I check on my environment using Policy Based Management? Check out this tip to learn more.
SQLServerCentral Runs sp_Blitz - Performance Part 2
The second part of our performance examination on the SQLServerCentral database servers using the sp_Blitz script from Brent Ozar, PLF.
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 KCP Taman Aries Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Taman Aries Blok E1 No. 2A & 2 B, Meruya Utara,...
BCA KCP KS Tubun Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jalan Letjen. S. Parman Kav. 28, L No.216-217, RT.12/RW.6, Tj. Duren Sel.,...
BCA KCP Rantai Mulia Kencana Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Pesanggrahan Jl. Puri Kencana No.28 29, RT.2/RW.7, Kembangan Sel., Kec. Kembangan,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers