Contained Databases – Server Setting Matters
In doing some additional testing on contained databases, I decided to create a new database on a new test VM.
CREATE...
2012-07-19
2,144 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
Send me your pictures
If you got some with me at SQL in the City last week I London, or anytime in the last...
2012-07-19
1,059 reads
Using Technology In New Ways
An interesting reuse of technology in a completely new way caught Steve Jones' eye. See if you agree that this is rather amazing.
2012-07-19
144 reads
Geeky Books
Today Steve Jones talks about one of his pastimes: reading. He recommends you read more, and share the books you enjoy.
2012-07-18
239 reads
SQL in the City – London 2012
It’s a wrap. Two days of SQL in the City are complete, and I’m back at home, almost feeling normal....
2012-07-18 (first published: 2012-07-16)
3,062 reads
Time Zones
Today Steve Jones complains a bit about time zone support in SQL Server and why it seems so cumbersome. Shouldn't it be easier in 2012?
2012-07-17
299 reads
T-SQL Tuesday #32 – A Life in the Day
It’s T-SQL Tuesday time again, delayed a week this month, so I had a whole extra week to get ready....
2012-07-17
1,370 reads
A Cool Job
Today's editorial was originally published on August 21, 2007. It is being re-run as Steve is traveling. What a cool job it must be to try and tune and get the most performance out of a system.
2012-07-16
159 reads
Write Better Code
Better security can be achieved by writing better code. Steve Jones agrees, but doesn't think it's as easy as it sounds.
2012-07-16
261 reads
Kill a SPID
This editorial was originally published on Sept 5, 2007. It is being re-run as Steve is traveling. Today Steve talks about the potential problems with killing SPIDs in SQL Server.
2012-07-13
311 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers