Enable/Disable a table to be read only on the fly
Wouldn't be nice if we can set the "read only" property of any table to be on or off easily with one simple stored procedure call?
Flying high on the Big Data hot-air
Today Phil Factor talks about Big Data, and all the hype that's in the news.
Baselining with SQL Server Dynamic Management Views
When you're monitoring SQL Server, it's better to capture a baseline for those aspects that you're checking, such as workload, Physical I/O or performance. Once you know what is normal, then performance tuning and resource provisioning can be done in a timely manner before any problems becomes apparent. We can prevent problems by being able to predict them. Louis shows how to get started.
SQL Saturday #236 St Louis, MO
SQL Saturday is returning to St Louis for a full day of free SQL Server training and networking. This year's event will be on August 3, 2013 at the Saint Louis University's Center for Workforce & Organizational Development. We hope to see you there.
Configuring Database Mirroring
This article contains a set of instructions for configuring SQL Server mirroring, including pre-requisites. It also includes notes on how to resolve a few issues that I have encountered.
Finding lost or forgotten SQL Servers
This article will show a way to find all SQL Servers, particularly those that have been forgotten about or lost.
How to understand NoSQL Databases
Today we have a guest editorial from Phil Factor that looks at NoSQL databases.
Some Relevant PowerShell Books
Phil Factor leafs through a few of his PowerShell books in his library, and considers which are his favorites
SQLServerCentral Webinar #24: Prepare for When Disaster Strikes
Steve Jones presents some disaster stories with ideas on how you might prevent, or mitigate the effects, of those problem situations.
Using Lookup Function to Bridge Datasets in Report Builder
The report function, lookup, can be used to link two independent datesets.
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