SQL Saturday #285 Atlanta
It’s been a couple of months since my last SQLSaturday and it’s time! Atlanta is my third SQL Saturday that I’ll...
2014-02-15
481 reads
Blog Posts
SQL Saturday #285 Atlanta
It’s been a couple of months since my last SQLSaturday and it’s time! Atlanta is my third SQL Saturday that I’ll...
2014-02-15
220 reads
#Excel “smart list”: drop-down list dependent upon user’s choice of another drop-down list
When data entry is strictly defined, it is nice to have data validation list in place, so entries are uniform....
2014-02-14
706 reads
Application Data Asset Library
TwitterGoogle+The post Application Data Asset Library appeared first on Derek Wilson - Blog .
2014-02-14
768 reads
Friday Followup For February 14, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-02-14
480 reads
How to Eliminate Sales Commissions #sales
Three months ago, when the few paper calendars that remain on earth flipped over to 2013, ThoughtWorks, a 2,000-employee software...
2014-02-14
406 reads
Learning About Reporting & Visualization
Today I watched DATAVIZ YOU THOUGHT YOU COULD NOT DO WITH SSRS by Jason Thomas. The intro felt long, but...
2014-02-14
754 reads
Making Virtual Teams Work: Ten Basic Principles #remotework
Consider this now familiar view from the field:
“I’ve run a virtual team for the past 18 months in the development...
2014-02-14
1,135 reads
Powershell in a Month Day 17 – Security Alert
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-02-14
983 reads
Querying Linked Server without OPENQUERY
I already post an article how to setup Linked Server in SQL Server and querying on linked Server using open...
2014-02-14
77,183 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