My SQL Server Management Studio Setup
We’re all creatures of habit, and work more efficiently when we know exactly where to find the tools we need....
2017-12-18
338 reads
Tim Mitchell
Some Thoughts on Community, Leadership, and Continuous Improvement
The SQL Server community is just awesome. I can’t say that enough. I may sound like a broken record when...
2017-12-17
371 reads
The Value of Shortcuts
Decades ago when I was working as a retail clerk, I had a boss named Billy. Billy was a pragmatic...
2017-12-16
414 reads
To Learn, Teach
Back before I started doing technical presentations or writing blog posts, I frequently found myself in awe at those who...
2017-12-15
601 reads
Picking The Right Team
Years ago, back before I became a consultant, a job search led me to an interview with a technical company....
2017-12-14
412 reads
The Value of Consistent Design
Yesterday I wrote about best practices, illustrating that what may be an assumed technical design standard doesn’t fit every scenario....
2017-12-13
398 reads
When Best Practices Aren’t Best
Most everyone is familiar with the term best practices. This phrase describes an industry-specific design or methodology that can be...
2017-12-12
389 reads
The Eleven Days of Festivus 2017
Last year, I celebrated the holiday season by blogging daily during the 11 days leading up to Festivus, writing about...
2017-12-12
316 reads
The One Piece of Career Advice I Wish I’d Gotten
Over the years, I’ve been approached numerous times with requests for advice from folks who are looking to get started...
2017-12-12 (first published: 2017-11-29)
2,520 reads
Long Live OLE DB!
Back in August of 2011, an announcement from Microsoft started a wave of angst among those who build and support...
2017-11-20
357 reads
Blogs
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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