Latest Blog Posts
The SSIS Project Deployment Model is great! It really is the best thing since sliced bread! I specifically appreciate the package execution logging and reporting that is provided by this model but …. (there is always a but :), right), lately I’ve been looking for ways to execute all packages… Read more
I frequently see statements on forums along the lines of “I don’t have a test server, so I’m going to do something I’ve never done before directly on my production servers…” This is usually followed by questions along the lines of:
- But that’s OK and I won’t get fired, right?
I love keyboard shortcuts. I’d rather keep my hands on the keyboard than move back and forth to the mouse. Not that I won’t use the mouse, but only when I have to. One frequent (and annoying) task that I haven’t been able to find a keyboard shortcut for is… Read more
Database Console Command CHECKDB (DBCC CHECKDB)is used to check the integrity (physical & logical) of objects in a SQL Server database.The command is supported in databases that contain memory-optimized tables but the validation is only supported in disk-based tables. The DBCC repair option is unavailable in memory-optimized tables and therefore,… Read more
With my travel schedule, I don’t always get out to events where I can see a community speaker. Sometimes, I just see pros. That’s the case this month. Instead of skipping the month entirely, which feels wrong, I’ve decided to do a special award.
Speaker of the Month for June… Read more
August and September are going to be some busy weeks!
In those two months I will be speaking on three SQLSaturday events:
- SQLSaturday #414 Oslo – 29th of August
Efficient Indexing Strategies (level 100)
- SQLSaturday #411 Cambridge – 12th of September
Efficient Indexing Strategies (level 100)
- SQLSaturday #434 Holland –…
No no, I didn’t say temporary, but temporal! SQL Server 2016 introduces a great new feature called Temporal Tables. Or in other words, system-versioned tables. We’ll see what catches on. In a gist, such a table keeps track of the history of its rows by the use… Read more
Well, it has finally happened. In the 7+ years that I helped to run the Omaha SQL/BI User Group, I never once gave a presentation of my own. Of course I spoke, but it was usually about house keeping items for the group or helping to facilitate a “Bring Us… Read more
First came the in-person roadtrip.
Two weeks riding the highways from Nashville, TN to Chicago, IL to St. Louis, MO and back.
One thousand four hundred miles in a minivan with my wife and four daughters.
Eight… Read more
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
How many of you can define a foreign key when you create the table? Probably a few of you, but I bet most of you are like me… Read more
Originally appearing at ForITPros.com.
A world-class violinist was on campus for an artist-in-residence program. While at lunch he was discussing what he perceived to be the similarities between management and great music. Said the violinist, “I have glorious music, a splendid instrument, and an exquisite bow. All I need… Read more
I’ve been hosting this blog on Azure for a while, running WordPress on top of MySQL. Works fine, gives me a reason to use Azure here and there to gain experience. No good reason to change. Still, why not?
A while back a give a session at the element61 Microsoft Business Analytics Day, a free event where the capabilities of the Microsoft BI platform is demonstrated alongside client testimonials. I gave a session called “Drilling across Analysis Services cubes using Power Query”, which talked about how you can use… Read more
“Microsoft Most Valuable Professional “ – MVP is one of the prestigious tag. It is one of the dreams which came true today.
Today , I got the E-mail that I am an MVP in SQL SERVER.
I am speechless but would like to… Read more
Choosing the right data type for your columns is first of all a design decision that has tremendous impact on the correctness of the database schema. It is not just about performance or space usage: the data type is the first constraint on your data and it decides what can… Read more