Track Your Consultants
It's possible to perform a man-in-the-middle attack against SQL Server. Steve Jones notes you should be aware these attacks could take place inside of your network.
2016-03-29
90 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
Dexterity Matters
The individual's dexterity can impact how we use software. Perhaps we need ways to undo mistakes in various systems.
2016-03-28
69 reads
SQL Nexus in Copenhagen
The Nordic SQLNexus conference is taking place in Copenhagen on May 2-4. I’ve never been to the event, or the...
2016-03-28
592 reads
2016-03-28
1,246 reads
Protecting sa
Today Steve Jones talks about the issues with the sa account, and how you might protect this on all your instances.
2016-03-25
109 reads
SQL Data Generator –Specific Domains for a Column
I was mocking up some test data and wanted to limit my list of values to specific items. In this...
2016-03-25 (first published: 2016-03-21)
1,551 reads
2016-03-25
1,424 reads
Do Less
One way to make code run faster is to have less of it. Or ensure the code you have does less work.
2016-03-24
110 reads
2016-03-24
1,709 reads
2016-03-23
1,128 reads
Blogs
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Finding the Next Sequence Value: #SQLNewBlogger
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
Forums
DB Design Methods
I've read a few posts regarding what we use to design DB models and...
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers