Choosing the Right Microsoft Reporting Technology Part 4: PerformancePoint
If you’ve followed this blog series from the beginning then you may have started thinking about which tools would be...
2012-03-21
1,563 reads
Blog Posts
Comparing users and role memberships between two databases
The other day I was asked to restore a production database into a development environment and then check the database...
2012-03-21
887 reads
Error: Could not load type 'Microsoft.AnalysisServices.Sharepoint.Integration.ASLinkFilePage'.
To create a PowerView report first we need to create a BI Semantic Model Connection,
but If we did not deploy...
2012-03-21
2,860 reads
Fast Track for SQL Server 2012
When the Fast Track Data Warehouse 3.0 Reference Guide was published, it was based off of SQL Server 2008 R2....
2012-03-21
967 reads
Microsoft DreamSpark Program
Back in 2008, Microsoft rolled out the DreamSpark program as a means to get Microsoft software design and development tools...
2012-03-21
1,370 reads
Microsoft Releases SQL Server 2008 SP3 Cumulative Update 4
Microsoft has also released SQL Server 2008 SP3 Cumulative Update 4. This is Build 10.00.5775.00, and it has ten fixes...
2012-03-21
4,258 reads
Speaking at SQL Saturday Houston
It’s SQL Saturday season again! I found out this morning that I’ll be speaking at next month’s SQL Saturday event...
2012-03-21
602 reads
Spring DevConnections 2012
Hello Dear Reader, this week finds me in beautiful Miami FL. Next week I’ll be in Vegas, for one night...
2012-03-21
657 reads
SQL Lunch - SQL Reporting Services
Tomorrow at 11:30 CST Pam Shaw will be talking SQL Reporting Services (SSRS). If you have time, join us for...
2012-03-21
1,842 reads
SQL Lunch–SQL Reporting Services
Tomorrow at 11:30 CST Pam Shaw will be talking SQL Reporting Services (SSRS). If you have time, join us for...
2012-03-21
943 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
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