oPASS Meeting Tonight, July 13, 2010
Our regular monthly meeting is tonight featuring David Pless from Microsoft. Here are some notes about his presentation:
This discussion will...
2010-07-13
230 reads
SQLAndy
Access Annoyance – Bit Columns
Here’s another one that I’ve run into when linking to a SQL Server table that has a bit column. Maybe...
2010-07-13
332 reads
Old McDonalds and The Cow Store
As a child did you have a place that was your ‘thing’, something that just the mention of it would...
2010-07-12
507 reads
SQLSaturday #49 Pre-Con Announced
We’re pleased to announce that Louis Davidson will be our pre-con speaker this year at SQLSaturday #49 in Orlando. Louis...
2010-07-09
219 reads
PASS Update #36
We had our monthly Board of Directors call on July 8th and as is fairly common, the call went smooth....
2010-07-09
1,151 reads
PASS Summit 2010 Sessions Accepted
Excited to get the email yesterday that two of my sessions were accepted, Introduction to SQL Server Statistics and Building...
2010-07-09
412 reads
Why Would They Coach Me?
During a recent call I was talking with someone about achieving a career goal (coaching in itself, though unplanned) and...
2010-07-08
764 reads
Life Lesson: Pay Your Dues
This is one of the lessons you don’t want to hear when you’re 18, or the newest member of a...
2010-07-07
292 reads
SSC Editorial – Learning From Experts
Another story with a lesson today, this one about learning to work smarter and not just harder. Easy to say,...
2010-07-07
255 reads
MS Access Annoyance: Yes, Save the Password, Again
Here’s another quirk that has been there forever. Open up the linked table UI and select a handful of tables,...
2010-07-06
302 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