Table Level Access
Some of the features that seem to make LINQ very attractive also seem to require granting table level access to data, something Steve Jones doesn't like.
SQL Server 2005 log shipping setup using the wizard
Along with some best practices, SQL Server MVP Hilary Cotter shares a log shipping setup process from start to finish.
SQL String User Function Workbench: part 1
Robyn and Phil go back to basics and hammer out some basic String-handling User Functions in TSQL, based on Python examples. Plenty of sample code, and TSQL programming tricks.
The April Energy Update
The bimonthly update on energy news from Steve Jones, focusing mostly this month on wind power.
The April Energy Update
The bimonthly update on energy news from Steve Jones, focusing mostly this month on wind power.
The April Energy Update
The bimonthly update on energy news from Steve Jones, focusing mostly this month on wind power.
The Inmates in Charge
What happens if you allow people to be in control of their own computers? Are we putting the inmates in charge of the asylum?
The Skill Set of the Exceptional DBA
In my previous editorial on this topic, I stated that the An Exceptional DBA is defined more by what they do than what they know. Judging by the responses, there is little disputing this fact among DBW readers. However, before we accept technical knowledge as a "given", and move on, I'd like to consider the […]
Identify SQL Server 2005 Standard Login Settings
Gaining insight into my SQL Server standard and Windows logins has historically been a challenge in terms of determining password changes, failed login attempts, etc. I have noticed that you have experienced the same issue with your tip entitled 'When was the last time the SQL Server sa password changed' and I have noticed some information in the forums on the topic as well.
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