Treat the Database like Code
Steve Jones reminds us that our databases contain code, and as such, they ought to be under some type of version control.
2012-04-05
215 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
2012-04-05
2,697 reads
My Little Friend
Today Steve Jones talks about his favorite feature in SSMS 2012 and why everyone should use it.
2012-04-04
615 reads
2012-04-04
2,074 reads
Too Many Bricks, Too Much Data
Too much data can be as much of a problem as too little. Today Steve Jones talks about some problems that we have in working with lots of data and how we might address the issues. Those that do well, will succeed in the future.
2012-04-03
186 reads
Skipping April Fools
No April Fool's jokes from SQLServerCentral this year and Steve explains why today.
2012-04-02
274 reads
SQL Saturday #131 – Phoenix Schedule Posted
I got an email today from the SQL Saturday #131 crew with the schedule posted, showing me listed for two...
2012-04-02
934 reads
Which product was purchased the most? T-SQL
Suppose you had a list of product sales and were curious about which one was sold the most? It’s a...
2012-04-02
9,345 reads
2012-04-02
3,214 reads
Backup and Restore
Today's editorial was originally published on May 13, 2007. It is being re-run as Steve is at SQL Server Connections. Today Steve Jones talks about the need to train yourself, just like people in other professions.
2012-03-30
204 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
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
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