Another Lunch Story
Lately I’ve been having some unusual lunches, starting with the bbq fiasco from last week. For this one I have...
2010-12-20
583 reads
SQLAndy
Unusual BBQ
Recently some friends invited me to try a BBQ place that they enjoyed, so I went along hoping for the...
2010-12-17
594 reads
The Bar Where Everyone Queries Your Name?
Sent by a friend (yes, it’s a mild fake), but still, shouldn’t someone open a SQL bar or coffee place?
2010-12-17
582 reads
Notes from the December 2010 OPASS Meeting
Our December meeting was a time for a lot of changes:
New location, the Hampton Inn in Lake Mary. It’s further...
2010-12-16
589 reads
Email Pruning
Email consumes a pretty significant chunk for me. Email for my day job, email for my blog, email from friend...
2010-12-15
873 reads
Soft Skills Matter More Than You Think
Over my career I’ve seen interviews fall into three categories:
The technical part. Questions on trace flags, wait states, backups, etc,...
2010-12-14
612 reads
More Networking Thoughts
I’ve happened to have a few networking events happen recently that I thought I’d share, all part of trying to...
2010-12-13
648 reads
IT Education Part 2
For those thinking about an IT career the options are bewildering, and I think the education establishment doesn’t do a...
2010-12-10
697 reads
Book Review: The Way We Work Isn’t Working
The Way We Work Isn’t Working by Tony Schwartz ($19 @ Amazon) is a holistic approach to work and a work...
2010-12-09
600 reads
SQLSaturday #62–Too Many Speakers
I received the email this week that I won’t be getting a place on the schedule, nor will the other...
2010-12-08
785 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