Browse by Tags

Log Shipping + Database Snapshots == Bummer, dude!!
So, like most funny stories (involving me), this one starts with “Yesterday, I had this bright idea...” and goes downhill from there. Database mirroring is great. Full stop. But there’s this one little catch: it can only have a single mirror copy of the Read More...
Thanks, Brian! A couple minor nits to pick, though.
Brian, I'm glad y'all are doing videos like this for SQL School!! I realize that you probably recorded this last year; however, the details (specifically of download file selection on CodePlex ) in that video about AdventureWorks for SQL Server 2008 have Read More...
Sybase loves AdventureWorks2008?
A SQL Ranger friend of mine in the UK gave me the heads up to this yesterday. (Thanks, Ben!!) Apparently, back in December 2008, Sybase ported some of our samples to SQL Anywhere. Needless to say, I’ve got mixed feelings about Sybase porting AdventureWorks Read More...
Tweeting AdventureWorks?
Earlier this week, the gravitational pull of Twitter got the better of me. Jimmy May emailed me that Paul Nielsen was trying to sort out the gender of the fictitious IT Manager of AdventureWorks (Jean Trenary) for the next edition of the SQL Server Bible Read More...
Who are you and what do you want with my data?
If you’ve got data, there are probably people who want to use it, analyze it, do things with it... that you never imagined and possibly don’t want them to. “Those people” might even be government agents. Who can put you in jail. If you’re not careful Read More...
We don‘t need yet another database security czar.
I was reading this article about recent data breaches that was recommending Yet Another Government Agency® and (no surprise) I started getting mad: A program to share best practices among agencies at all levels of government and create cybersecurity templates, Read More...
Simplifying AdventureWorks setup
FYI, we’re actively working on improving the setup experience for the SQL Server 2008 sample databases (aka AdventureWorks). We’ve heard your feedback and we’re acting on it. Here are some of the salient points you’ll see for the Halloween update (Samples Read More...
INSERT your.own.data INTO election.spreadsheet
No, this isn’t a Schneier-induced rant about electronic voting machinas… Kevin just dropped a template into Office Online for those of you who would like to model your own election results. Simple Electoral College Election Predictor - Templates - Microsoft Read More...
Thank you, Captain Obvious.
Actually, my oldest son is the original Captain Obvious in my life, but Michael Campbell does a good impression of him in Performance Secrets for SQL Server Developers (sqlmag.com) . Heh. Not that it's a bad thing. Being reminded of the obvious every Read More...
Cool (Free, Open) Tools: SQL RSS
Even if nobody has asked you for an RSS feed of data in one or more of your databases, it won't be long before they do! When they do, you can grab this configurable, easy to use data-driven RSS feed widget. A couple ideas for using this application: Business Read More...
Contrary to the FUD, The Relational Database™ is far from dead...
I've gotten questions over the past month or two from folks (mostly DBAs and trainers) who have attended FUD dissemination events where various "experts" have declared The Relational Database™ to be dead. Ha! I've had a good laugh at most Read More...
Breaking News! AdventureWorks abandoned for Katmai in favor of Northwind, pubs and...
In a striking change of direction, I'm happy to announce that AdventureWorks is being deprecated and abandoned for SQL Server 2008 samples in favor of long-time favorite databases of simple-minded data modelers: Northwind and pubs. Also, I can gleefully Read More...
Tracking Politicians Like Bugs?
The suggestion is to track politicians positions like software products and file bugs against them to determine their suitability for installation in office. Nope, not April 1st yet! Whaddya think? If a candidate takes a position I disagree with, such Read More...
How do I use Feature X in SQL Server?
Buck's got a great point about how SQL Server's development themes are managed from the top down: It isn't a matter of thinking up single features or changes to the product, it's a cohesive direction we all want to go. Carpe Datum : Why on earth are you Read More...
Hi, Mom! (And everybody else.)
"So, what do you do?" It's a common enough question, right? Usually immediately subsequent to "Where do you work?" People ask it to break the ice. They ask it because they're interested. They ask it because they can't believe somebody Read More...
More Posts Next page »

Search

This Blog

Syndication

Page view tracker