Connecting to AdventureWorks on Azure
A quick guide for connecting to our free copy of AdventureWorks on the Azure platform.
2013-05-20
11,707 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
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
952 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
122 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
509 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,158 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
197 reads
Not My Google Reader Replacement
Someone suggested Newsblur to me, and I went to their home page. Like many sites, it asks you to sign...
2013-05-15
813 reads
The Challenger
There is plenty of competition in the database platform space for SQL Server. There's a new NuSQL platform, whose vendor hopes will replace SQL Server as the platform of choice in the cloud. However Steve Jones isn't sure this will be the case.
2013-05-15
173 reads
Webinar: Forgotten Rings and Other Monitoring Stories
In this session, Grant Fritchey, Microsoft MVP, drills down into a few of the more obscure monitoring metrics that can give you very precise information about exactly what's happening within your server. He'll also show you how you can use custom metrics to enable these metrics in Red Gate's SQL Monitor.
2013-05-15
180 reads
Webinar: Using SQL Storage Compress by Steve Jones and Brad McGehee
Steve Jones and Brad McGehee lead you through real-world examples of working with SQL Storage Compress
2013-05-15
304 reads
Blogs
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Leading Through the Noise: Harnessing Data in the Age of Digital Overload
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Forums
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
AI Steals Joy
Comments posted to this topic are about the item AI Steals Joy
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers