SSRS – Embedding Refreshable Reports in Office Tools
Have you ever experienced this?
You have developed a set of Reporting Services report that your users love and they often...
2012-02-20 (first published: 2012-02-14)
2,695 reads
Whitepaper – Extending Reporting Services with Custom Code
Today Pragmatic Works released a whitepaper I wrote and I thought I would share it with you. Prepare for Marketing...
2012-02-08
1,643 reads
SQL Saturday Jacksonville and Precon with Kevin Kline
I’m so excited to tell you about SQL Saturday 130 in Jacksonville coming April 28th. This is the 5th year...
2012-02-07
1,044 reads
SSRS – Using Analysis Services Dynamic Management Views to Build Dynamic Reports
Dynamic Management Views are a very powerful tool that are part of Analysis Services in 2008 and 2008 R2. They...
2012-02-01
2,318 reads
SSRS - Custom Code with External Assemblies
In a previous post I wrote about how you can use embedded custom code to extend the capabilities of Reporting...
2012-01-31 (first published: 2012-01-26)
24,233 reads
Session Code – Extending Reporting Services with Custom Code
This is my wish list of things I’d like to cover in todays session at 11 AM EST https://www1.gotomeeting.com/register/935071481 but...
2012-01-19
3,516 reads
SSRS - Embedded Custom Code
When developing reports in Reporting Services you will often use the built-in
expression language to make report data and formatting...
2012-01-12 (first published: 2012-01-05)
4,597 reads
January 2012 Speaking Events
It has been a quiet past few months while my family has adjusted to having
two new additions (twins!), but...
2012-01-10
913 reads
SSAS – Display Folders
Display folders are an often used tool in Analysis Services to help end users navigate through a cube or dimension...
2011-12-27 (first published: 2011-12-20)
6,439 reads
SSAS – Deployment Wizard
The Analysis Services Deployment Wizard is an often under utilized but important tool when moving your OLAP database throughout your...
2011-10-26
7,396 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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...
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