MVP Deep Dives 2 – Pre-Order
Every couple days, I’ve been checking for it and finally tonight I saw that the upcoming edition of SQL Server...
2011-09-22
551 reads
StrateSQL
SQL Saturday in Kalamazoo This Weekend
If you are going to be in Kalamazoo this weekend and don’t have anything planned. Because, yeah, that happens. Or...
2011-09-13
438 reads
PASS 2011 Countdown – 4 Weeks To Go
One week down and we are now 4-weeks from this years PASS Summit. Hopefully, you have already registered for the...
2011-09-12
621 reads
September Monthly SQL Server Checklist
First day of the month and first Tuesday of the month. Yup, the list is late this month because for...
2011-09-06
1,372 reads
PASSMN September Meeting Announced
It’s time to start looking deeper at the next release of SQL Server. As such, the September PASSMN meeting will...
2011-09-06
1,092 reads
PASS 2011 Countdown – 5 Weeks To Go
We are now 5-weeks from this years PASS Summit. It’s time to start getting ready for the event. Hopefully, you...
2011-09-05
861 reads
PASSion Award Nominations
PASSion Award
One of the things that makes PASS a successful organization is the volunteers. To show it’s appreciation for these...
2011-09-04
1,489 reads
Re-blog – August 26-September 1
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-09-02
651 reads
Book Status #1: Indexing for Performance
As some of you may know, I am writing a book on indexing. So far I’ve written and submitted four...
2011-08-31
1,406 reads
Re-blog – August 19-August 25
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-08-26
570 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