Better SQL is a Good Career Investment
Today Steve notes that learning to be better at SQL is a good career investment, more for you than your boss.
2021-08-18
435 reads
Career Growth
Leading without Managing
Learning to lead is a valued skill to have, and you can do this no matter what your role. You don't need to be a manager to become a leader.
2021-07-28
290 reads
Messy Job Descriptions
Job descriptions can be messy and intimidating, but Steve notes that they aren't ever going to be perfect. Work with that to find the job or candidate you need.
2021-07-16
269 reads
Do We Need to Learn Linux?
An announcement on Windows containers has Steve noting that Linux might be a more desired skill in the future for SQL Server professionals.
2021-07-10
204 reads
Learning Intentionally with a List
We're coming up on the middle of the year, and I wonder if you are improving your career this year? Did you make plans and are you sticking to them? I've been tracking progress on my goals, and so far mediocre progress. It's tough to learn, but even tougher to learn when you don't have […]
2021-07-02
139 reads
Evaluting a DBA
Steve has a few thoughts on hiring and the way in which you might want to evaluate a DBA candidate.
2021-06-18
347 reads
Living Life
It's a holiday weekend in the US this weekend. As such, many of you will be taking a break from work and enjoying time with family, as well as remembering some history in the US. If you're in the rest of the world, hopefully you have a holiday coming up soon you can enjoy. One […]
2021-05-29
70 reads
2021-05-28
156 reads
2021-05-22
142 reads
2021-05-14
243 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers