SQL Server Security Basics: Logins vs. Users
When I discuss SQL Server security, one of the basic concepts I concentrate on is the difference between logins and...
2009-04-21
22,728 reads
Blog Posts
SQLSaturday #14 in Pensacola Update
Karla just emailed that the schedule is set, details at http://www.sqlsaturday.com/schedule.aspx, but to save you time here are the speakers...
2009-04-21
622 reads
A Proper Response
That sounds like a very British title, so maybe the Red Gate folks are rubbing off on me. I had...
2009-04-20
581 reads
Four new SSIS Videos on JumpstartTV.com
I've got four new SSIS videos published on JumpstartTV.com:
Expression Language Basics
Secure FTP File Transfer in SSIS
SSIS Lookup Transformation Basics
SSIS...
2009-04-20
2,204 reads
Interviewed by Tom Larock
Tom has been doing a series of interviews on his blog lately and I ended up on the list. Interviewing...
2009-04-20
520 reads
Prius Update – Smells Like New
We got the Prius back yesterday. I dropped Kyle off and he drove it home. Today was my first time...
2009-04-20
523 reads
Revisiting the Task List
I've written a few posts in the past about time management, and thought I'd post an update with some lessons...
2009-04-20
590 reads
Security Basics - The C-I-A Triad
In the course of giving my security presentations over the past year, I've learned that quite a few folks have...
2009-04-20
9,093 reads
Simply Dumb Founded - A Non SQL Blog
Blogging is both more fun and harder than it looks, so when someone is getting started I try to offer...
2009-04-20
545 reads
The Death of Email Questions
One of my policies is not to answer questions from people about SQL Server in email. That includes emails to...
2009-04-20
1,056 reads
Blogs
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...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
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...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
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