Virtual Security
As more and more companies move to virtualized servers, security should be on their minds. Steve Jones talks about that changes that you should consider.
SQL Saturday #93 - Toronto
Come get a free day of SQL Server training in Toronto on Sept 17, 2011 at SQL Saturday #93. The event takes place at Humber College in Toronto.
A Flock of SQL Servers
Do you want to integrate Twitter with your database server? Steve Jones asks the question this week.
SQL Server Restore Tutorial
What good is a backup if you do not know to restore the backup? In this tutorial you will look at what restore options are available and which options are only accessible using T-SQL commands.
PASS Data Architecture Virtual Chapter presents Data Warehouse Architecture
On Thursday August 18th, John Racer will discuss some common architects and practices for Data Warehouses.
The Pencil Analogy
Today we have a guest editorial from Brad Wallace that is an attempt to answer the question 'Why is database engineering so expensive?'
When Did Merge Replication Subscribers Last Sync?
The article presents an automated process to see when remote servers last synced to publisher and send notification reminders.
SQL Server Index Maintenance Performance Tuning for Large Tables
If you think about it carefully, you’ll realise, that index maintenance is necessary and that it makes sense, and that SQL Server is not doing this task automatically according to the book.
Benefits
Benefits for workers seem to be on the decline. Steve Jones talks about the issue, which might be something you give more weight to when choosing your next job.
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers