2020-01-11
279 reads
Database Weekly
The Art of Commenting
This week Steve talks about the ways in which comments are important in our code.
2020-01-04
281 reads
The New Year: A Chance to Start Over
January 1st is the beginning of a new year thanks to Julius Caesar and Pope Gregory XIII. This date is somewhat arbitrary, and many religions and cultures celebrate their own beginning of a new year at different times. Even though these celebrations don’t fall at the same time, I think the sentiment is similar. The […]
2019-12-28
112 reads
Learn to Change
This week Grant talks about the need for change and growth to adapt to the changing world.
2019-12-21
156 reads
Using All Your Tools
Steve looks at a number of tools that you should spend time learning and building a level of comfort that enables you to use them in your daily work.
2019-12-07
313 reads
How SQL Server Can Just Go Faster
It’s rare to get a call from a customer telling you that the application is fast today and thanks for taking such good care of the database. Instead, you are more likely to hear complaints when things go wrong like slow running queries and timeouts. There is a lot to consider when trying to figure […]
2019-11-30
566 reads
A Big Week for the Data Platform
Steve highlights a few items from a busy Microsoft and SQL Server news week.
2019-11-09
223 reads
A Faster tempdb
I like to call tempdb the “workhorse” of SQL Server. I’ve heard some other people call it other terms that were not so flattering, but since I like to keep things positive, I’ll stick with workhorse. SQL Server uses tempdb for many things. The obvious uses are temp tables and table variables, but tempdb is […]
2019-11-02
1,124 reads
Become a Technological Historian
This week Grant muses on how history can impact our decisions moving forward, and having a little empathy can be useful when re-examining the past.
2019-10-26
132 reads
2019-10-12
216 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.
Comments posted to this topic are about the item Attaching an SQL Server database...
Superseded Indexes
Comments posted to this topic are about the item Superseded Indexes
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers