PASS 2015 Session Report – Optimize “All Data” with a Modern Data Warehouse Solution
PASS 2015 has kicked off in Seattle, well the precon’s have anyway on Mon & Tue. The actual conference starts on...
2015-10-28
487 reads
Blog Posts
PASS 2015 Session Report – Optimize “All Data” with a Modern Data Warehouse Solution
PASS 2015 has kicked off in Seattle, well the precon’s have anyway on Mon & Tue. The actual conference starts on Wed-Fri! I attended a precon session today called Optimize...
2015-10-28
3 reads
PASS Summit 2015 – Here We Go
Yes, it’s this time of the year again, and I’m very excited about it. Once a year, PASS holds the...
2015-10-28
431 reads
PASS Summit 2015 Keynote – Day 1
Today, I’ll be live blogging the SQL PASS 2015 keynote. Today is the third day of the PASS Summit, and...
2015-10-28
735 reads
Who’s on call
Of all the posts I’ve written I think this one is my favorite, even though it’s not a technical post....
2015-10-28
504 reads
A Great SQL in the City 2015 Seattle
Yesterday was the Seattle edition of the 2015 Redgate Software SQL in the City tour. I was in London a...
2015-10-27
682 reads
A Great SQL in the City 2015 Seattle
Yesterday was the Seattle edition of the 2015 Redgate Software SQL in the City tour. I was in London a...
2015-10-27
508 reads
2015-10-27
381 reads
Exposure to Internals
For me, some of the most fun stuff with SQL Server is diving deep into the internals. Diving into the...
2015-10-27
596 reads
Exposure to Internals
The premise of the article today is to get a little exposure to some of the internals that may cause a bit of curiosity for you. I will share...
2015-10-27
4 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