Latest Blog Posts
I hope everyone is having a good time gearing up for the holidays. Throwback Thursday is a bi-weekly blog series where I dig deep into my evernote collection and find some great content on a single subject and share it with you. In the third installment of the Throwback Thursday… Read more
Consider this sample setup, where we are stuck importing values from a varchar data source into an integer data…
As I have been giving demos on Power BI for Office 365, I have received a tremendous amount of positive feedback, with many clients really loving it. There are common questions that I hear, and I thought I would list them here with answers:
Will there be an on-premise… Read more
8 Hours of High Quality…
Full database backups in SQL Server include all of the data, objects, tables, rows, functions, stored procedures, etc. If something is in the database when the data reading portion of the backup concludes, it’s in there.
Note that “in there” means committed in a transaction.
If someone tells you the… Read more
I’m absolutely in love with the concept of being able to create a backup directly to a protected, off-site location. Yeah, you can spend all sorts of money on terribly wonderful technology to enable that within your enterprise. And if you have that kind of money, great. But, what if… Read more
For those that attended the webcast I did last week for Idera the companion whitepaper is now available for download. You can view the recording and/or get the whitepaper by just entering basic contact information.
Also, one of the things I mentioned in the webcast but omitted from the slides… Read more
Database snapshot is really a useful feature. As we know, Snapshot database file will keep increasing parallel to the DML operations on database. But if disk containing snapshot file run out of space then what will be the impact on new transactions, database & snapshot?
Microsoft design snapshot in very… Read more
This past weekend I had the opportunity to go visit Washington DC. It was the first time I got to stay in the Nation’s capitol for more than just a few hours. It is also the first time that I was able to see any of the monuments in the… Read more
Just in time for Christmas the Microsoft product teams responsible for Power BI have a slew of amazing updates. The list of updates can be found here but for my notes specifically on Power Query updates continue reading!
Power Query now has 3 new data sources that you… Read more
Congratulations for winning a free month of PluralSight. I'm E-Mailing you the code right now.
We still have two free months to give away and a great book on the 30th!
Update: Everyone is eligible for the book drawing on the 30th. You can enter…
Today I ran through the first tutorial at Code.org. It has 20 very short lessons that use Angry Birds and zombies to teach the very basics of programming – instructions, loops, and conditionals. It was very well done, a nice UI supplemented with some short and interesting videos as you… Read more
0 comments, 94 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 10 December 2013
Info from Microsoft on how the MCSA and MCSE certifications will be altered for SQL Server 2014:
In reviewing the SQL Server 2014 product, the Microsoft Learning Experiences team determined that the new features focus on performance tuning and high availability. As skilling and testing around these features is best… Read more
It’s T-SQL Tuesday again and this time it’s being hosted by the SQL Soldier. He’s picked the subject of Waits. As in, why am I having to wait for my query to finish. Or more specifically what is my query waiting for. Waits are a popular subject. You can… Read more