Latest Blog Posts
I have previously written about finding what the big space consumers are within the database. I even shared scripts in those articles on how to find those big consumers (read all about it here).
That is grand when it comes to quickly finding which objects happen to be… Read more
This is a bit of an off topic post from the technical stuff, but there’s a bit of a tie-in, so stick with me.
I had to get a tire fixed this morning. I actually owned a replacement tire, so I just needed someone to mount it on the existing… Read more
This is I believe the 7th SQLSaturday in Baton Rouge. Please come out this Saturday at the LSU Business Center to enjoy free training, prizes and networking with over 500 IT professionals.
Here is the schedule.
I’ve been doing a lot of research recently for my permissions session and for a project at work. During said research I came across three great sets of posters about permissions. I’m going to list them here and on my Study and Reference Materials
A client called us with the following issue:
He had a table of a few dozen million rows. The table had a few GUID columns that had to be indexed.
He had an ETL process that inserted a few thousand rows every few minutes. When the table had only a… Read more
Users were aware of PowerView / Power…
Power BI is released to the public on Friday, 07/24. There’re both free and Pro versions. For full details about products, downloads, and pricing, go to https://powerbi.microsoft.com/. This is how the community reacted to the release on Twitter.
An exciting news was announced a day prior to GA. The… Read more
Whenever we develop application of maintain application we define sets of rules or policies like naming convention , data type, database & SQL SERVER properties (like which property should be unable or disable) but the problem is to cross check or to enforce these properties is very tedious.
To… Read more
Error Message 1 :
Executed as user: Domain\UserName. SSIS error. Component name: DFT – Upload collection snapshot, Code: -1071636372, Subcomponent: RFS – Read Current Upload Data , Description: String too long. The adapter read a string that was 50331648 bytes long, and expected a string no longer than… Read more
Yesterday I participated in PASS Performance Palooza.
I had a lot of fun delivering my session Columnstore Indexes – Questions and Answers.
The recording is already up:
The scripts and slide deck can be downloaded from here.
Today Microsoft officially released the new development tool for Power BI called Power BI Desktop. First of all let me share my excitement in what this release means for Power BI. The team at Microsoft has done an incredible job and the results are something they can truly be proud… Read more
I have enjoyed the trips I’ve made to New Orleans and Baton Rouge in the past. It’s a good getaway, stopping in the French Quarter for a few minutes before an easy drive up the road. However it’s warm, and I can’t ever get my wife or kids to come… Read more
Today we can already say with certainty that the most striking innovation in the MS SQL 2014 is the In-Memory OLTP. In-Memory OLTP (project Hekaton) functionality was designed to expedite the processing of typical OLTP-operation in SQL Server. As you know, server load can be divided into… Read more
This weekend I was creating some Azure VMs to test and was required to use the GUI for some screenshots. I have always used my Powershell scripts described here to create my test systems and with a new job taking up a lot of my time had missed the announcement… Read more