Currys having apostrophe trouble
Before I start I just want to say that much of this post is mere speculation on my part and...
2014-04-08
610 reads
SQL Server Rocks!
Pluralsight = Essential Training
Update: 11th Sep 2016 - See comment that pricing tiers have been adjusted since this blog post
I've been aware of Pluralsight...
2014-03-25
1,342 reads
FIGlet SQLCLR ASCII Font Art
If you haven’t heard of the name before, you must have seen what it does at some point. FIGlet which...
2014-02-13
1,737 reads
Basic RegEx in SSMS
Have you ever had that moment where you have gone "Geez.. I wish I'd learnt this stuff ages ago" after...
2014-02-04 (first published: 2014-01-27)
6,007 reads
And that is 2013
I’ve been blogging for a couple of years now and although I’ve never been a prolific blogger (and never will!),...
2013-12-23
571 reads
Getting the read/write ratio for a database
EDIT: Please also see in depth comment from Brent Ozar on my main site which extends the query provided below...
2013-11-30
4,790 reads
Removing HTML formatting tag - BR - from XML using XQuery
This is a personal pet hate of mine.. Mixing HTML formatting tags directly with XML that aren’t escaped or contained...
2013-11-07 (first published: 2013-10-31)
3,944 reads
What to do next certification wise
I feel rather flat today. I passed the 3rd entry level 2012 exam a few hours ago, data warehousing to...
2013-09-19
707 reads
Just Wow!! features
Over the years with each release I’m often impressed by some of the features contained in SQL server but every...
2013-08-30
1,326 reads
Crash when inserting to a FileTable with a parallel plan
Whilst doing some ad-hoc work on some data on a 2012 SP1 instance I came across an issue with the...
2013-07-25
1,359 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
SQL Art, Part 3: Happy Easter Fun in SSMS
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers