Subscribe to this blog
The Kind of DBA I Want to Be
The Kind of DBA I Want to Be
I was a big fan of the original Iron Chef tv show, as in the original show from Japan. And my favorite Iron Chef was Iron Chef Japanese Rokusaburo Michiba. If you don’t know the show,… Read more
0 comments, 1,728 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 22 January 2012
Including Missing Values in Data Ranges Without a Lookup Table
Including Missing Values in Data Ranges Without a Lookup Table
One of the ways that I learn new things is by helping others with their issues or questions. In my career, this has served me well by exposing me to a vast array of experiences that I… Read more
0 comments, 638 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 14 January 2012
Webcast: Putting a Better SQL Server in Production
Webcast: Putting a Better SQL Server in Production
Webcast: Putting a Better SQL Server in Production
Date: Wednesday, January 18, 2012 3:00 PM to 4:00 PM Eastern Time / 2:00 PM CT / 12:00 PM PT
Problems come up everyday that could have been avoided by simply configuring… Read more
0 comments, 374 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 26 December 2011
Using Dynamic Values in XMLA
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… Read more
0 comments, 442 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 18 December 2011
Undocumented Gotchas of Transactional Replication
Undocumented Gotchas of Transactional Replication
This discussion started on Twitter via the #sqlhelp hash tag. The question that was asked is, “What are the undocumented gotchas of Transactional Replication? #SQLHelp”. I responded with several things that came to mind. I thought these would be good… Read more
5 comments, 447 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 17 December 2011
PASS Data Arch. Virtual Chapter: Row Versioned Data Warehouses
PASS Data Arch. Virtual Chapter: Row Versioned Data Warehouses
| Subject: | Row Versioned Data Warehouses |
| Start Time: | Thursday, December 15, 2011 6:00 PM US Pacific Time (December 16, 2011 2:00 AM GMT) |
| End Time: | Thursday, December 15, 2011 7:00 PM US Pacific Time (December 16, 2011 3:00 AM GMT) |
| Presenter: | Jeremy… |
0 comments, 293 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 14 December 2011
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
| Subject: | On beyond Zebra AdventureWorks or where did I go wrong? |
| Level: | 200 (Intermediate) |
| Start Time: | Thursday, November 17, 2011 8:00 PM US Eastern Time (November 18, 2011 1:00 AM GMT) |
| End Time: | Thursday, November… |
0 comments, 491 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 15 November 2011
T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs
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… Read more
0 comments, 521 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 8 November 2011
How Do I Spell #SQLFamily? #SQLNomz Of Course
How Do I Spell #SQLFamily? #SQLNomz Of Course
Nomz (Doma Kun)
It’s time for Meme Monday again, and this month’s theme is #SQLFamily. One of the overwhelming themes of this year’s SQL PASS Summit was community. And that’s what most people mean when they talk about SQL family. When… Read more
0 comments, 464 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 7 November 2011
SQL PASS Summit 2011: Session Files
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… Read more
0 comments, 568 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 17 October 2011
Presentation Files: 10 Things All BI Administrators Should Know
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… Read more
0 comments, 816 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 30 September 2011
The Barking Dog Analogy
The Barking Dog Analogy
A discussion started today on Twitter about CXPacket waits. There had been a heated debate on the subject on Twitter the previous night (wow, does that sound geeky), so many of us got looped into today’s discussion. Someone had experienced a problem with…
0 comments, 486 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 20 September 2011
Auditing Users in a Failover Partner Database
Auditing Users in a Failover Partner Database
I read a question on a discussion list today asking if it is possible to audit SELECT queries on a log shipping secondary in stand-by mode. His attempts to set it up had obviously failed because the database is…
0 comments, 539 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 20 September 2011
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
| Subject: | Architecture Career Paths for SQL Server Professionals |
| Level: | 200 (Intermediate) |
| Start Time: | Thursday, September 15, 2011 7:00 PM US Central Time (September 16, 2011 12:00 AM GMT) |
| End Time: | Thursday, September 15, 2011 8:00 PM US… |
0 comments, 412 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 12 September 2011
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
| Subject: | Architecture Career Paths for SQL Server Professionals |
| Level: | 200 (Intermediate) |
| Start Time: | Thursday, September 15, 2011 7:00 PM US Central Time (September 16, 2011 12:00 AM GMT) |
| End Time: | Thursday, September 15, 2011 8:00 PM US… |
0 comments, 243 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 12 September 2011
Session Files for Replication Magic Presentation to WSSUG
Session Files for Replication Magic Presentation to WSSUG
I presented my session on Replication Magic: Initializing from Backup to the Wichita SQL Server User Group last night. I took a little longer to post my session files so I could add comments to the SQL scripts. Session files… Read more
0 comments, 509 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 26 August 2011
August 18 Data Arch VC Meeting: John Racer on Data Warehouse Architecture
August 18 Data Arch VC Meeting: John Racer on Data Warehouse Architecture
| Subject: | Data Warehouse Architecture |
| Level: | 200 (Intermediate) |
| Start Time: | Thursday, August 18, 2011 1:00 PM US Central Time (August 18, 2011 6:00 PM GMT) |
| End Time: | Thursday, August 18, 2011 2:00 PM US Central Time (August 18, 2011… |
0 comments, 564 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 15 August 2011
T-SQL Tuesday #21 – Bringing Ugly Back
T-SQL Tuesday #21 – Bringing Ugly Back
This blog entry is participating in T-SQL Tuesday #21, hosted this month by Adam Machanic (Blog|@AdamMachanic). You are invited to visit his blog to join the blog party. You are… Read more
0 comments, 414 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 10 August 2011
The Best Part of My New Job
The Best Part of My New Job
If you had told me a year ago that I would be a Program Manager today, I would have told you that you’re dillusional. Obviously when the program is something you’re really passionate about,… Read more
0 comments, 410 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 4 August 2011
Meme Monday: SQL Horoscope: Finding Your Chinese Zodiac
Meme Monday: SQL Horoscope: Finding Your Chinese Zodiac
It’s time for July’s Meme Monday post, and this month’s topic is SQL Horoscopes. I read Jen McCown’s post, Meme Monday SQLstrology – Table Valued Zodiac Function, and it inspired me to write a simple… Read more
0 comments, 192 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 11 July 2011