Hadoop and Data Warehouses
I see a lot of confusion when it comes to Hadoop and its role in a data warehouse solution. Hadoop should...
2014-05-12 (first published: 2014-05-06)
5,411 reads
Filetable–Moving files programmatically
I’ve been playing with Filetable and I was asked an interesting question. Can I move files to a folder programmatically?
It’s...
2014-05-06
1,829 reads
SQL Server Debugging with WinDbg – an Introduction
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-05-13 (first published: 2014-05-05)
5,517 reads
SQLSaturday #305 Business Analytics Edition Dallas–RECAP
So, I am flying home thinking about the event Saturday and many things are running through my head. No, not...
2014-05-05
825 reads
SQLServerCentral Editorial: Better, Faster, and Cheaper
Better, Faster, and Cheaper was published today and I hope you’ll read it, and then challenge your own assumptions for...
2014-05-05
631 reads
Last Weeks Top “Reading” Links #82
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-05-05
541 reads
Applied SQL: Orphan a user, fix orphaned users (sp_FixOrphanedUsers)
Ever heard of orphaned users? It’s a database user account, disconnected from its associated login. You typically get this when...
2014-05-05
939 reads
Cumulative Update – 12 for SQL Server 2008 R2 Service Pack 2 Is Now Available !
The 12th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the...
2014-05-05
1,812 reads
Cumulative Update – 1 for SQL Server 2014 RTM Rollback by Microsoft !
The 1st cumulative update release for SQL Server 2014 RTM was released by Microsoft.
But due to issues in setup Microsoft...
2014-05-05
973 reads
Why is there a sysobjects when we already have sys.objects?
Once upon a time in a version of SQL far far away we had system tables that were easy to...
2014-05-05
722 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Anyone knows where to download SQLexpress edition for 2022
Where to download earlier version of SQL server express 2022? Thanks
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
SSL/TLS Cert Validity Periods Decreasing
Hi, to all of you who are using CA certs on SQL Server boxes...
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers