2014-11-24
159 reads
Editorials
Real World T-SQL Tricks
This week Steve Jones wonders if you're taking advantage of the changes in the T-SQL language.
2014-11-21
712 reads
Achievement Unlocked: Balance 0
Steve Jones completed a task this year that he's rarely completed in the past.
2014-11-20
110 reads
The SQL Server Container
There's an interesting idea that exists for lightweight, application separation on a host that's different from virtualization. It's Docker, and Steve Jones talks about it today.
2014-11-19
256 reads
Continuous Learning
It pays to continuously learn more about your job. SQL Server is so large, it really is a lifelong effort to drive yourself forward to master more and more.
2014-11-17
188 reads
Prepping for Winter
As winter approaches, many of us get ready in our personal lives, but Steve Jones notes that we might want to make sure we have regular preparation taking place on our systems for difficult times.
2014-11-17
69 reads
Bucket List Data
This Friday Steve Jones is looking to see what data you're tracking about your life.
2014-11-14
139 reads
2014-11-13
229 reads
Double Up During Trips
When you develop software, it pays to write efficient code. However it doesn't seem that many companies truly believe this as they aren't always investing in their staff.
2014-11-12
140 reads
2014-11-11
119 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