Data Warehousing Tip #3 – Build thin slice
My third data warehousing tip is to build thin slice. Deliver subsets of valuable functionality. Get feedback and buy in,...
2019-01-16 (first published: 2019-01-07)
2,841 reads
How to Change Suspect Mode to Normal Mode in SQL Server Database
If you are reading this, you are desperately looking for solutions to change suspect mode to normal mode. It also means that your database has gone into the suspect...
2019-01-07
27 reads
How to Change Suspect Mode to Normal Mode in SQL Server Database
If you are reading this, you are desperately looking for solutions to change suspect mode to normal mode. It also...
2019-01-07
227 reads
Profiler Is Dead, Long Live Extended Events
OK, so profiler isn’t actually dead, it has however been deprecated since 2012 and has had no new features since...
2019-01-07
631 reads
A Monumental Migration to SQL Server 2016 - Part 1
A bit over a year ago, I blogged about my experience migrating a test SQL Server instance from a VM to a physical machine with a little help from...
2019-01-07
14 reads
Creating my own Map Shapefiles for Power BI
(2019-Jan-06) In the past, I used to always rely on shapefiles crafted by others to create my map visualizations in...
2019-01-15 (first published: 2019-01-06)
6,793 reads
When does it make sense to hire a data science consulting company?
Going into 2019, data science and machine learning is all the hype. Organizations in every industry are starting to realize...
2019-01-06
47 reads
Last Week Reading (2019-01-06)
Good morning chaps! Bunch of news from data’s world freshly served. Press Introduction to Testing Your PowerShell Code with Pester...
2019-01-06
172 reads
Hello Cristian,
Hello Cristian,
Thank you for sharing the link and your contribution. The idea behind the article is to be able to upload any file while the server is been provisioned....
2019-01-06
19 reads
Short Circuiting Your Session
It isn't very often that one would consider a short circuit to be a desired outcome. In SQL Server we have a cool exception to that rule - Extended...
2019-01-05
19 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
A Worse Computer; A Better Car
Comments posted to this topic are about the item A Worse Computer; A Better...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers