PASS Business Analytics Conference Live Blog
Apologies if you went to my site this morning to see my blog from the bloggers table at PASS Business Analytics...
2013-04-12
732 reads
Apologies if you went to my site this morning to see my blog from the bloggers table at PASS Business Analytics...
2013-04-12
732 reads
The PASS Business Analytics Conference is almost here! Check out the sessions to be presented at the conference and you will see...
2013-04-08
918 reads
A quick list of how each of these Microsoft BI tools handles the two data sources “SQL Server” (relational-based) and...
2013-04-02
1,263 reads
My first article in SQL Server Pro magazine has been published. It is entitled “SQL Server 2012 Business Intelligence Enhancements”...
2013-03-28
1,567 reads
I had someone ask me the other day if they are using SSIS 2012 Project Versions, is there any benefit...
2013-03-26
4,088 reads
Using SQL Server views throughout a Business Intelligence (BI) solution can provide a tremendous amount of benefits. Here is a...
2013-03-19
734 reads
First lets define what Business Intelligence (BI) is. My favorite definitions:
Forrester Research: “Business Intelligence is a set of methodologies, processes,...
2013-03-14
2,052 reads
Thanks to everyone who attended my session “Top BI Enhancements for SQL Server 2012” at the Houston Area SQL Server User Group Monthly Meeting.
Here...
2013-03-13
996 reads
Version 2 of Parallel Data Warehouse (PDW) is apparently due this month (and can be ordered as of March 1st). The official...
2013-03-12
2,707 reads
Next Tuesday, March 12th at 1:15pm CST, I will be presenting the session “Top BI Enhancements for SQL Server 2012” at...
2013-03-08
832 reads
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
By Vinay Thakur
it has been a year since i have not written much on the blog...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
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