SQLInspireNYC Event - We're giving away SQL MVP Deep Dives Vol.2
Now the PASS has well passed, folks are setting their sites on our upcoming NYC SQLPeople event called SQLInspireNYC .
SQLPeople...
2011-10-18
932 reads
Blog Posts
Understanding Kerberos, Part II
The majority of the time, the problems I see with Kerberos are due to a bad SPN (Service Principal Name)...
2011-10-18
4,056 reads
When was SQL Server restarted?
One of the main goals with this blog is to write stuff when we learn / discover new things or smarter...
2011-10-18
1,471 reads
Extended Events Data
I’ve been working quite a bit over the last week or so with extended events in Denali. The sheer magnitude...
2011-10-17
1,859 reads
Guest Appearance in DBA in Space
Win a trip into space!
The DBA in Space competition continues today with the third question. This time I get to...
2011-10-17
1,444 reads
Implicit Conversions warning
After adding an index, ensuring that an index is actually used is probably the biggest win you will get in...
2011-10-17
1,235 reads
PASS Summit 2011 recap
Recap of my first ever SQL PASS Summit – 2011:
Saturday, Oct 8 – Travel day – I flew from Richmond VA to the...
2011-10-17
1,460 reads
PASS Summit 2011: Wrap-Up
Another Summit done gone by and I’m exhausted. You know you did the Summit correctly if you’re crawling onto the...
2011-10-17
1,430 reads
Performance tips for SSAS
Over the past few years I have developed a list of ways to improve performance in SSAS and in two...
2011-10-17
4,137 reads
SafePeak version 2.1 for SQL Server Performance Acceleration Released!
Our friends at SafePeak has released a Major Update: Introducting SafePeak version 2.1 for SQL Server Performance Acceleration!
This unique caching solution offers...
2011-10-17
1,548 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