Latest Blog Posts
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well, I’m sure all of you have been holding your collective breath but I finally have some new updates. I’m particularly excited about the @DropTempTables and @Output options.
Just as a… Read more
People love taking shortcuts because it’s the easiest way to do things faster; computers are no exception. Shortcuts, particularly ones performed by keyboard, can save you hours of time once applied properly. Learning keyboard shortcut saves you a lot of time; you’ll definitely notice a boost the productivity because you’re… Read more
I’ve been catching up on stuff this week, including reading the January 2017 minutes. It was in-person meeting so a lot was covered. I don’t want to summarize it, you should read it, but there were some trends I noticed I wanted to comment on:
- Goals are frequently mentioned, but…
I did a quick review of the 2017 PASS Budget. It’s not a page turner, but it has a lot of good information. I wish there as more context about some of the changes. The following isn’t a summary, just notes about areas I either care about or caught… Read more
With SQL Server vNext CTP 1.4 now available and providing SQL Agent capability on Linux, I wrote here about using Ola Hallengrens scripts on Linux SQL Servers so can Test-DbaLastBackup work… Read more
Hey all, I’m back after attending SQL Saturday in Iceland. This week’s going to be busy!
I’ve said before that SQL Saturday Iceland was the first time that I presented a full hour session. It seemed to go well although having it start at 14:50 wasn’t the best as I… Read more
Continuation from the previous 99 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In Data Warehousing one will not be shocked to find a number of tables using IDENTITY property on a column, a lot of times to create automatic incremental values for the surrogate keys.
What about… Read more
So you look around, and all the cool kids are speaking at SQL Saturdays and PASS Summit and the like. You want to be the cool kids too, so how do you start public speaking? Here in four simple steps, is your roadmap.
Pester provides a framework for running unit tests to execute and validate PowerShell commands from within PowerShell.…
When I agreed to host the T-SQL Tuesday site, I wasn’t sure what to do. I thought about just putting up a static page, one I’d edit, but in some conversations with Adam Machanic, he wanted to have a few people able to manage the site. That makes sense and… Read more
Sharing this without a supporting link, might help someone. During a recent move from SAN to local SSD the storage guy noted that the following has to be done to get best performance.
This command disables SSD Smart Path. You must disable the SSD Smart Path before enabling Controller caching.…
Posting this mostly in case I need it again. I needed a merge tool for Git, Kdiff is free and useful, but you have to get all the switches set up if you want full functionality (three way merge). I found the answer on this blog post (a reminder to… Read more