Day 6 – Lost in Space
This is the sixth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2013-12-30
1,207 reads
Blog Posts
Entity Data Modeling with Visual Studio
While there are a lot of tools out there for data modeling, there is one option that is free if...
2013-12-30 (first published: 2013-12-26)
13,064 reads
Final December Giveaway!
Today I'm giving away the book Professional SQL Server 2012 Internals and Troubleshooting. If you live outside the continental US,...
2013-12-30
509 reads
Installed SQL SERVER 2012? maybe you’d like to re-set your shortcuts!
TweetG’day,
Just a quick post on a seemingly trivial matter that others may find useful.
The post was prompted by the Simple-Talk...
2013-12-30
1,375 reads
Kissing 2013 Goodbye
The end of the year is here, which means it’s time to look back and review my goals and reflect...
2013-12-30
1,221 reads
Last Weeks Top “Reading” Links #64
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2013-12-30
1,183 reads
Memory Timeouts
Recently I was asked to investigate a timeout issue that was causing SSIS package executions to fail.
The timeouts seemed to...
2013-12-30
1,315 reads
SSIS For Loop Skip Files
When running a For Each Loop through a set of files, sometimes you will have specific files that you do...
2013-12-30 (first published: 2013-12-23)
2,689 reads
SSRS Interactive Sorting a Matrix
Sorting a matrix report can be done interactively. To perform interactive sorting, your report you will need a cell to...
2013-12-30
1,863 reads
Wishing all visitors a very happy new year 2014
Wishing all visitors
A Very Happy & Prosperous
New Year 2014
Happy New Year! Thanks to visit queryinqsql.com.
Last year I started this Blog,and post...
2013-12-30
1,462 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