Tampa IT Pro Camp Coming on September 22,2012
The Tampa IT Pro Camp will be held September 22 at New Horizons in Tampa (different location than last time)....
2012-07-25
659 reads
SQLAndy
Fortune Cookie Marketing
I took a break from work today to look in on an informal event a friend was hosting at his...
2012-07-25
715 reads
Should We Customize the SQLSaturday Hashtag on Twitter?
The question was posed on Twitter recently (or perhaps more along the lines of “why can’t we”), suggesting that our...
2012-07-23
775 reads
Presentations That Exceed The Allotted Time
Back in February I did a presentation for MagicPASS that ran long, maybe 30 minutes over the time allotted. It...
2012-07-20
829 reads
Stacia Misner and Kevin Kline Doing All Day Sessions for SQLSaturday #151
If there is anything better than a SQLSaturday it’s a SQLSaturday with a choice of great pre-con speakers. This year...
2012-07-19
703 reads
Notes from the July 2012 MagicPASS Meeting
Quick notes from the MagicPASS meeting:
Kendal Van Dyke still the king when it comes to explaining what’s going on with...
2012-07-19
719 reads
The Mentoring Experiment–New Call for Mentees
With both Steve Jones and I done with our summer break, we’re ready to continue with several experiments we’ve been...
2012-07-23 (first published: 2012-07-19)
2,564 reads
Should Apps Use a Dedicated Port?
Most applications connect on whatever the default port is, typically 1433 for SQL, though it’s common to change that to...
2012-07-24 (first published: 2012-07-18)
1,972 reads
Attending SQLSaturday #164 in Cleveland
I’ll be back on the road again in August, heading up to Cleveland for SQLSaturday #164. It’s my first time...
2012-07-17
624 reads
I’ll Be Presenting at the PASS Summit 2012
I’m a little late posting this, but I had two sessions accepted out of four I submitted. I’ll be doing...
2012-07-16
541 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
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...
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