• SQL Server
  • Log Shipping Tricks Demo
  • SQLCruise Alaska 2012 Pics
SQLSoldier News From the Frontlines

Tag Archives: Ssas & Bi

Day 4 of 31 Days of Disaster Recovery: Back That Thang Up

January 4, 2013 2:20 pm / 11 Comments / SQLSoldier
31 Days of Disaster Recovery

Day 4 of 31 Days of Disaster Recovery: Back That Thang Up Here we are at day 4 in my series focusing on disaster recovery. It’s Friday, so this will be a quick one for today. I want to talk about the importance backing up everything that needs it and point out some of the … Read More →

Posted in: SQL Server / Tagged: 31 Days of Disaster Recovery, Disaster Recovery, Security, SSAS & BI, SSRS

Using Dynamic Values in XMLA

December 18, 2011 4:23 pm / Leave a Comment / SQLSoldier

Using Dynamic Values in XMLA A question was raised on Twitter today via the #sqlhelp hash tag about passing parameter values to XMLA for a backup script. The popular answer at the time I saw it was to dynamiclly create and drop a SQL job to run the script every time you need it to … Read More →

Posted in: SQL Server / Tagged: SSAS & BI, T-SQL, Tips & Tricks, XML in SQL

T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs

November 8, 2011 4:40 pm / Leave a Comment / SQLSoldier

T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs This blog entry is participating in T-SQL Tuesday #024, hosted this month by Brad Schulz (Blog). You are invited to visit his blog to join the blog party. You are welcome to write your own participating blog post for the party or just … Read More →

Posted in: SQL Server / Tagged: Dynamic Management Views, SSAS & BI, T-SQL Tuesday

SQL PASS Summit 2011: Session Files

October 17, 2011 7:06 am / Leave a Comment / SQLSoldier

SQL PASS Summit 2011: Session Files This past week was the SQL PASS Summit 2011 in Seattle, WA. I presented three sessions (regular session, lightning talk, panel discussion) plus ran a focus group on advanced certification and hosted a Birds of a Feather lunch table on disaster recovery. It was a busy, busy week. Below … Read More →

Posted in: SQL Server / Tagged: Disaster Recovery, Dynamic Management Views, Replication, SQL PASS, SQL PASS Summit, SSAS & BI, Tips & Tricks, Troubleshooting, Undocumented Stuff

Presentation Files: 10 Things All BI Administrators Should Know

September 29, 2011 9:44 pm / Leave a Comment / SQLSoldier

Presentation Files: 10 Things All BI Administrators Should Know I was very excited to get to present to the Pensacola SQL Server User Group tonight. I lived in Pensacola for a few years when I was a kid. I have a lot of memories from Pensacola like dancing to disco music on the dance floor … Read More →

Posted in: SQL Server / Tagged: SQL PASS, SSAS & BI, SSIS
<

Remote DBA Services
- serious SQL Server expertise for less than a full-time DBA
My Articles
 
My Book
Check out my interview on

Extreme Data Recovery (with Argenis Fernandez)
10 Things all BI System Administrators Should Know
Upcoming Events
    All events shown in Pacific Time

    No events to show

RSS My SQL Server Magazine Articles

  • Database Mirroring for Disaster Recovery September 16, 2011
  • Comparative Review: Database Schema Comparison Tools August 24, 2011
  • 3 Log Shipping Techniques June 22, 2011
  • Hardening SQL Server June 20, 2011
  • Review: ScriptLogic Security Explorer for SQL Server February 8, 2011

Tags

31 Days of Disaster Recovery Architecture Automation CDC & Change Tracking Data Architecture VC Database Mirroring DBCC Denali Disaster Recovery Dynamic Management Views Extended Events Gamers & Geeks General Discussion High Availability How do I ... ? Humor Idera ACE Program Internals MCM Meme Monday Performance & Optimization PowerShell Professional Development Replication Security SQLBits SQL PASS SQL PASS Summit SQLRally SQL Saturday SQL Server Magazine SQL University SSAS & BI SSIS SSMS SSRS T-SQL T-SQL Tuesday tempDB Tips & Tricks Travel Troubleshooting Undocumented Stuff Whitepapers XML in SQL

News

Download my Powershell Scripts

The following scripts can be downloaded as text files. You will need to change the file extension to .ps1 in order to execute them.

Backup a database
Restore a database
Scan a server to find a free port
Query DNS to get the FQDN of a server


To see some examples of my other forms of writing, please visit my page on WritersCafe.org. It is almost exclusively horror fiction, but I sometimes throw other things in there too from time to time. There's one science fiction story, a couple of poems, and quite a few humor pieces as well.


Look for me in the SQL Q&A section of the August, 2007 issue of TechNet Magazine.
August issue of TechNet Magazine's SQL Q&A column

Protect our Heroes

© Copyright 2012 - Robert L Davis
Infinity Theme by DesignCoral / WordPress

Twitter Twitter 
LinkedIn LinkedIn 
TLF TLF RSS RSS 
WritersCafe WritersCafe 
SQLPASS SQLPASS 
Facebook Facebook
grab this