Latest Blog Posts
0 comments, 95 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 17 February 2017
Is it me or is February dragging? Anyway, mixed in with this crazy week I’ve been reading: –
SQL Server vs SQL Server vNext
Henrico Bekker runs through a performance comparison of SQL Server against SQL Server on Linux
It is an open secret that in SQL Server, we can “create a system object” by using an undocumented stored procedure sp_MS_marksystemobject as explained here.
The benefit is that when you put a SP in the [master] database and mark it as system object, this SP can then be… Read more
Recently I published an open-source course/workshop to learn Power BI Desktop. Fellow MVP Dan English (blog | twitter) gave me the excellent feedback that IMDB actually doesn’t like people scraping their website for data. Furthermore, the OMDB API appears to have fallen almost out of funds and is… Read more
I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you ask? Well, 4-5 system sessions were holding locks on the database (and blocking each other). Which meant I wasn’t able to get exclusive use of the database which is required… Read more
In the last post in my ongoing series about ETL best practices, I discussed the importance of error handling in ETL processes, reviewing best practices for application flow to prevent or gracefully recover from a systematic error or data anomaly. In this post, I’ll dig a bit further into that… Read more
We had a schedule conflict so today’s meeting will be pushed until next Wednesday. However, we have a last-minute meeting tonight (this afternoon, tomorrow, whichever time zone you’re in).
In this newsletter:
- Add SSRS to the SQLServer PowerShell Provider?
- Tonight: PowerShell ? SQL Server: Modern Database Administration with dbatools
I’ve been going over some demos for a presentation that I’ll be giving this year and I thought I’d write this quick post about something that keeps catching me out…
…but first, a bit of shameless self promotion. I’ll be giving my session on an Introduction to SQL Server &… Read more
Continuation from the previous 97 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing with the spirit of the previous blog post on the string data type limitations I decided to add a couple more items that are showing some current limitations of the Columnstore Indexes and the… Read more
I’ve been testing and working with SQL Clone for the last few months, trying to help the devs at Redgate ensure this product is ready to go when it’s released. I’ve written a few pieces on this blog, and I’ve got a new one up on the Redgate blog that… Read more
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the month’s host. This month’s host is Matt Gordon (t|b) and his topic is Fixing Old Problems With Shiny New Toys. I’ll be talking about the… Read more
1 comments, 193 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 14 February 2017
Splitting Strings in SQL
A problem that has plagued SQL developers through the years is splitting strings. Many techniques have been used as more capabilities were added to SQL Server including XML datatypes, recursive CTEs and even CLR. I have… Read more
Sometimes you have a requirement to grant permissions to every database on an instance. Historically this has required creating a user (database level principal) on each database and granting it the correct permission. And making sure to grant those permissions to the model database so that future databases have the… Read more
In this module you will learn how to use the Mekko Chart Power BI Custom Visual. The Mekko Chart visual is helpful when you need to analyze two different dimensions on a single chart.
Module 38 – Mekko Chart
Learning Tree are showing you the love with some great courses on offer for £750 plus VAT
Why don't you get your boss to treat you to training the spring.
Blow away the cobwebs and learn something…