TUGA IT Conference 19-21st of May 2016
Between 19th-21st of May 2016, we (TUGA Association) are organising a major IT event in Portugal – TUGA IT.
Targeting Microsoft Data...
2015-10-06
565 reads
SQLSaturday Portugal – I am not the principal organiser anymore
Unless you have been sleeping under the rock in the past 5 days, if you are a twitter user, you...
2015-10-06
429 reads
TechFuse Minnesota Follow Up
My Session: Using Azure SQL Database for Enterprise Needs
On 10/6/2015, I presented on Azure SQL Database at TechFuse Minnesota. Some...
2015-10-06
478 reads
Testing Sum By Month
I’ve been on a testing kick, trying to formalize the ad hoc queries I’ve run into something that’s easier to...
2015-10-06
561 reads
Testing Sum By Month
I’ve been on a testing kick, trying to formalize the ad hoc queries I’ve run into something that’s easier to...
2015-10-06
666 reads
Index selectivity and index scans
There was a question raised some time back ‘If an index is not selective, will the query operators that use...
2015-10-14 (first published: 2015-10-06)
4,408 reads
How I Got my Start at Pragmatic Works
October 4th of this month was my seven year anniversary as an employee of Pragmatic Works. Things have changed a...
2015-10-06
564 reads
Today at 12pm Central: #MinionEnterprise Talk – Backup Management!
Register here. In our monthly series about Minion Enterprise – the new SQL Server management solution – Sean and Jen will show you how...
2015-10-06
646 reads
New Article: Loading Fixed Width Files to Staging Tables
My article “SSIS Design Pattern – Staging Fixed Width Flat Files” is published on SQLServerCentral.com. In the article, I provide a...
2015-10-06
664 reads
Extended Event Management Power Tools
PowerShell can pack a pretty big punch when dealing with Extended Events. Using PowerShell as one of your Extended Events Management Tools, there could be a bit of a...
2015-10-06
9 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
advice on ssrs version control
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
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
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