Gold in the Execution Plan hills
There's more information hidden behind those graphical plans than you might first suspect.
2011-10-31
224 reads
Editorials
Happy Halloween 2011
It's Halloween day, the night for dressing up in costume and being a little silly. Hopefully it's also a fun day without anything going wrong for you at work.
2011-10-31
72 reads
Employee Slurping
This editorial was originally published on Oct 21, 2006. It is being re-run as Steve is out at SQL in the City today. This one talks about the security of USB devices and the potential problems of employees copying data.
2011-10-28
176 reads
Virtualization for Security
This editorial was originally published on Nov 7, 2006. It is being re-run as Steve is at SQL in the City today. Today Steve talks about security using virtualization.
2011-10-27
55 reads
The Good Job
Today Steve Jones talks about jobs, and how life is too short to stick with a crappy job.
2011-10-26
224 reads
The HR Scorecard
If you are looking to gain some BI experience or tackle a project that might help your company, Steve Jones suggests you consider doing something for HR.
2011-10-25
349 reads
Don’t Economize on Processors for Database Servers
In this guest editorial, Glenn Berry argues that, when designing your servers, you need to budget for processing power as your primary concern.
2011-10-24
292 reads
The Cost of Architecture
What's the cost of those architectural decisions that you make? It can be substantial if they aren't good ones, but is that a problem? Steve Jones talks a little about the implications
2011-10-24
161 reads
Which Versions of SQL Server Do You Have?
This week Steve Jones asks about the versions of SQL Server that you have to support in your daily job. Answer this week's poll and let us know the width and breadth of support that you are responsible for maintaining.
2011-10-21
213 reads
Not Only SQL
Steve Jones talks NoSQL today, which should stand for Not Only SQL, according to Dr David DeWitt. The final keynote last week discussed SQL alternatives and their impact on our data world.
2011-10-20
170 reads
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