PASS Summit 2015 Highlights
The week of the PASS Summit is always one of the highlights of my year. Even though I keep connected...
2015-11-04
280 reads
PASS Summit 2015 Highlights
The week of the PASS Summit is always one of the highlights of my year. Even though I keep connected...
2015-11-04
405 reads
Why Ask Why?
Spend any time around a 4 year old, and you will inevitably find yourself involved in a conversation which evolves into this:
Please do this thing Why? Reasonable answer Why? Restatement...
2015-11-04
12 reads
Columnstore Indexes – part 72 (“InMemory Operational Analytics”)
Continuation from the previous 71 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have previously written on the Rowstore...
2015-11-03
552 reads
The Whirlwind That Is October – Part 3
October has been such a whirlwind of PASS activity for me. Two SQL Saturdays and the PASS Summit. This post...
2015-11-03
513 reads
SQL New Blogger Challenge, Week 1: Just write!
It’s already time for week 1 of this round of the SQL New Blogger Challenge! I have to admit that...
2015-11-03
370 reads
Looking Back at Summit 2015
Last week was the 2015 PASS Summit in Seattle. It’s the largest SQL Server specific gathering of data professionals in...
2015-11-03
675 reads
Configuring the Azure SQL Database Firewall
Azure SQL Database is a Platform as a Service (PaaS) that provides a relational database for use over the internet....
2015-11-03
600 reads
ScriptDom Visualizer
Writing code to generate TSql using the ScriptDom is hard. There is a seemingly bewildering array of objects you can...
2015-11-03
524 reads
ScriptDom Visualizer
Writing code to generate TSql using the ScriptDom is hard. There is a seemingly bewildering array of objects you can use and where you use different types is unclear,...
2015-11-03
18 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