Introducing PowerView with Excel 2013
In this blog post we show video that introduces PowerView with Excel 2013. You provide an overview of the tool...
2012-07-25
1,752 reads
Blog Posts
Sacramento SQL Saturday Here I Come
Packing for SQL Saturday #144 in Sacramento, CO. Dan Hess, one of the organizers, asked me last November at the...
2012-07-25
1,198 reads
SQL Server 2012 AlwaysOn Availability Groups – Part 3: Setting up AlwaysOn through T-SQL
In the last blog posting about AlwaysOn you have seen how you can deploy your first
Availability Group through the AlwaysOn...
2012-07-25 (first published: 2012-07-23)
7,106 reads
SQL Server Performance Tuning & Troubleshooting Workshop
Der Sommer 2012 ist schon ein interessantes Phänomen
– gestern Sonnenschein mit 34°, und heute wieder Regen mit 20°. Gestern war...
2012-07-25
1,293 reads
SSIS aggregate transformation
In this SSIS 2012 tutorial we will show you how to use data flow Aggregate Transformation and we will use...
2012-07-25
1,761 reads
Tampa IT Pro Camp Coming on September 22,2012
The Tampa IT Pro Camp will be held September 22 at New Horizons in Tampa (different location than last time)....
2012-07-25
659 reads
Transact-SQL Script to Monitor Replication Status
Today, I’ve written the following T-SQL script which you can use to monitor the status of transactional replication and performance...
2012-07-25
7,019 reads
Visual Studio 2012 does not support BI
In the same vein as my post Watch out, Visual Studio 2010 does not support BI, Visual Studio 2012 does not...
2012-07-25
16,076 reads
Why You Should Speak at SQLSaturday (Or Any Other Free Event)
I talk to people about career planning and professional development quite a bit. It’s common to find them wanting to...
2012-07-25
1,068 reads
Backups in SQL Server Analysis Services
Analysis Services databases should be backed up at regular intervals like any other database. Here are the basics.
Using the GUI:...
2012-07-24 (first published: 2012-07-19)
2,754 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