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
608 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,340 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,707 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)
5,846 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
569 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,756 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,888 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
703 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,319 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,352 reads
Blogs
Responsible AI: Why Leaders Need More Than Just Guardrails
By Chris Yates
In the rush to adopt artificial intelligence, many organizations have quickly built ethical frameworks,...
TempDB Performance Tuning in SQL Server 2022 vs 2016 vs 2019
By Rohit Garg
What Is TempDB and Why It Matters TempDB is a shared system database in SQL...
Optimize Azure Fabric Pipelines with This Key Spark Setting
By Daniel Janik
Boost Your Azure Fabric Pipelines: Don’t Overlook This Crucial Spark Setting Are your Azure...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
When DBAs Should Consider Using SQL Server to Store Vector Data and If It Makes Sense
Comments posted to this topic are about the item When DBAs Should Consider Using...
Row Count task in data flow fails with "unspecified error"
Hi all, I have a data flow task with: Flat File Source (csv) ->...
Question of the Day
Capacity Planning for an Existing SQL Server Workload?
You're tasked with planning capacity for a new SQL Server database workload. Which of the following is the most accurate way to determine how much CPU, memory, and I/O throughput your workload requires? What single or multiple tools would you use to answer the questions around resource needs?
See possible answers