Unstructured Data
Unstructured data can be misleading. Steve Jones has a few thoughts today on how he sees this term.
How to Hire a Junior DBA
Brent Ozar covers some questions you need to ask yourself before hiring a Junior DBA.
SQL Server R Services: Working with ggplot2 Statistical Graphics
It is when you use R in SQL Server with one of the huge range of packages that comes with it that you can begin to appreciate the power of the system. With a package such as ggplot there are many 'knobs one can twiddle' in order to get spectacular and informative visualisations. Rob Sheldon continues his beginners series for R in SQL Server by showing how to refine the output to get it as you need it.
A Freecon Halloween at the PASS Summit
If you're attending the PASS Summit in 2017, there's a Freecon day on Tuesday you can attend.
DBAs and the ITIL Framework
Most IT departments are moving toward ITIL-aligned practices. Gain a general understanding of the ITIL framework and how Database Administrators can take advantage of it.
Parameter Sniffing In Action
This article will demonstrate what is parameter sniffing and how can it can kill performance
How to determine SQL Server database transaction log usage
One crucial aspect of all databases is the transaction log. The transaction log is used to write all transactions prior to committing the data to the data file. In some circumstances the transaction logs can get quite large and not knowing what is in the transaction log or how much space is being used can become a problem. So how to you determine how much of the transaction log is being used and what portions are being used?
Tell the Judge You Have No Backup
The NYPD is claiming there isn't a backup for one of their databases.
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
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers