We Hired!
The response to our most recent job position was incredible, and I’d like to thank all of the folks who...
2017-02-21
398 reads
Heading Back to SQL Bits
I’m honored to be selected to speak at SQL Bits 2017 this April in Telford. This is my favorite SQL...
2017-02-21
565 reads
Giving a Security Webinar on Thursday
On Thursday, February 23rd at 3 PM EST I’m giving a webinar on designing a successful database security model with...
2017-02-21
368 reads
Power BI Custom Visuals Class (Module 39 – Waffle Chart)
In this module you will learn how to use the Waffle Chart Power BI Custom Visual. The Waffle Chart visual...
2017-02-21
1,018 reads
Permanent Employment v Contracting: How the figures stack up
In my latest learning tree newsletter, I discussed analysing some of the salary survey data that the good folks over...
2017-02-24 (first published: 2017-02-21)
3,501 reads
Error while loading Excel data into database
Issue: I am trying to load data from Excel 97 – 2003 sheet into a database table. I have written a...
2017-02-28 (first published: 2017-02-21)
4,886 reads
How to sign a SQL Server CLR Assembly in Visual Studio 2015
It took me quite a while to figure out how to sign a SQL Server CLR Assembly (like a CLR...
2017-02-22 (first published: 2017-02-21)
6,838 reads
Improve performance by replacing temp tables with memory optimized tables - Part 3
Welcome to the last part of this series, you can find the previous post here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/01/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-1/) and here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/08/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-2/).
Previously we...
2017-02-24 (first published: 2017-02-21)
5,077 reads
SQL Server vNext: sys.dm_db_stats_histogram
Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics histogram...
2017-02-21
378 reads
External SQL files vs. Stored procedures in SSIS development
[2017-Feb-21] I'm creating this particular blog post more for myself to remember and use it as a reference to related discussions...
2017-02-23 (first published: 2017-02-21)
3,332 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
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...
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