Trusting Systems
The trust we build by ensuring our computer systems work is important. If we can't maintain that trust, Steve Jones sees a problem for our careers.
2013-05-23
110 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
The Bicentennial SQLSaturday–#200 Philadelphia
When Andy Warren (b | t | Li)started SQL Saturday with #1 in Orlando, we weren’t sure it would succeed. After a...
2013-05-22
905 reads
Understanding HA
Dealing with disaster situations or trying to maintain an HA environment can be stressful. However knowledge about your goals and the capabilities of each technology, along with practice, can make things much easier.
2013-05-22
233 reads
How do you solve T-SQL problems?
It's good to have a methodology for solving problems, and T-SQL is no exception to this. Steve Jones notes that all too often we look at solving a problem, but only doing half the job.
2013-05-21
426 reads
Connecting to AdventureWorks on Azure
A quick guide for connecting to our free copy of AdventureWorks on the Azure platform.
2013-05-20
12,181 reads
Getting Information from a Database using Dynamic SQL
I ran across someone that was building a restore script to automated their restores. This person wanted their script to...
2013-05-20
955 reads
Morphing Microsoft
Is Microsoft trying to move away from just being a software vendor? It seems they'd like to and that's a goal, but are they moving in the right direction? Steve Jones has a few ideas to help them.
2013-05-20
131 reads
Powershell for DBAs
Powershell is a great tool for helping you work with multiple instances of SQL Server. This week Steve Jones talks about how and why you might want to get started.
2013-05-20
515 reads
Software Design and Schizophrenic Windows 8 Part 2
I know it’s not schizophrenic, but that sounds better. It’s really a split personality.
I wrote recently about Windows 8 and...
2013-05-17
1,164 reads
Honeywords in SQL Server
There's an idea of using false passwords with real accounts, honeywords, that can help us detect security issues with our servers. Is that worth implementing in SQL Server?
2013-05-16
203 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers