Deterministic Functions
Do you know what determinism is? It's something that comes up periodically in Books Online as various SQL objects require...
2009-10-27
1,836 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
Expert SQL Server 2008 Encryption
Encryption is a tough subject, but it’s one that’s fascinated me for years. I downloaded PGP when it came out...
2009-10-26
1,055 reads
Low Hanging Fruit
An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?
2009-10-26
57 reads
One Week until PASS 2009
It's one week until the PASS Summit. At this time next week I'll be on a plane, heading to Seattle...
2009-10-26
677 reads
Virtualization and Preparation
The DBA news of the week contains some interesting thoughts on DR and virtualization plans. Steve Jones comments on why you should care about these topics.
2009-10-26
234 reads
Characters
No, I’m not talking about a Dickens novel. I’m talking about the number of characters in a string. I had a painful time recently because of the word “characters.”
2009-10-26
2,193 reads
Low Hanging Fruit
An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?
2009-10-26
474 reads
Low Hanging Fruit
An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?
2009-10-26
479 reads
Low Hanging Fruit
An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?
2009-10-26
720 reads
Not Pointing Fingers - Microsoft and Sidekicks
Someone posted a note on Twitter about the Sidekick fiasco. Apparently the servers that lost data weren't Microsoft servers. They...
2009-10-23
810 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
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
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