Virtual Lab – Design and Setup
This is part of a series where I set up a virtual lab for testing and misc work. The other...
2014-02-06
1,297 reads
Blog Posts
Virtualization resource consumption counters lie to you
OK, so maybe they do not lie to you, but I got your attention. In virtualized environments, the performance statistics...
2014-02-06 (first published: 2014-01-28)
2,146 reads
Your top 10 favorite Excel posts of 2013
The most popular Excel blog posts of 2013 reflect your interest in the new capabilities we’ve added to Excel this...
2014-02-06
357 reads
Automate T-SQL Merge For Loading Dimensions
If you’re a data warehouse developer, chances are you use T-SQL Merge statement to process slowly changing dimensions. If you’ve...
2014-02-05
1,348 reads
Free data & statistics, data collection, analysis, visualization and sharing – knoema.com
Knoema is a knowledge platform. The basic idea is to connect data with analytical and presentation tools. As a result,...
2014-02-05
559 reads
Just use Version Control
There are free systems out there. If you have no budget, and want to get started, download one of these:
Subversion:...
2014-02-05 (first published: 2014-01-28)
2,949 reads
Master Data Services for the Beginner Part 03
Introduction
In yesterday’s discussion we looked at creating entities and their related attributes. We learnt that a ‘model’ could be very...
2014-02-05 (first published: 2014-01-28)
6,229 reads
New Data Science – What’s Next?
While every organization is different, their “big data” is often very similar. It typically comprises massive amounts of data across...
2014-02-05
411 reads
Powershell – Extract Versions for SQL Features
Over the last few months I’ve been directed to ensure that all of our SQL Servers in the Development and...
2014-02-05
1,538 reads
Presenting at Code Camp Orlando
I’ll be at Code Camp Orlando on March 22, 2014 doing a presentation on storing credit cards in SQL Server...
2014-02-05
631 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers