Free learning materials
If you are new to a technology, you might want to have a place to get you started. It would be great if can be free and can guide...
2015-10-02
22 reads
Oregon SQL Saturday 2015 Keynote
This year we are honored to have a particularly special guest kicking off our SQL Saturday event on October 24th. ...
2015-10-02
246 reads
Oregon SQL Saturday 2015 Keynote
This year we are honored to have a particularly special guest kicking off our SQL Saturday event on October 24th. ...
2015-10-02
469 reads
Step by Step SSIS–Aggregate Transformation TIP #118
Dear Friends,
In the series of step by step SSIS tutorial this is another post. In this post we will see...
2015-10-02
2,038 reads
SQL Server – Configuring custom Load Balancing in SQL Server 2012 and 2014 using Read-Only Routing
Starting with SQL Server 2012, AlwaysOn Availability Groups provided group level high availability for any number of databases for multiple...
2015-10-01
1,429 reads
SQL Server – Dynamically Generate Scripts for Configuring Read-Only Routing URLs and Lists
Read-only routing refers to the ability of SQL Server to route incoming read-intent connection requests, which are directed to an...
2015-10-01
477 reads
SQL Server – Script to generate Read-Only Routing URLs
If you are familiar with the new feature Read-Only Routing introduced in SQL Server 2012 with AlwaysOn then you should...
2015-10-01
515 reads
New Whitepaper: Deciding Between Merge and Peer-to-Peer Replication
Replication is still a major component of SQL Server today even with Availability Groups as an alternative to certain scenarios....
2015-10-01
692 reads
SQL Saturday Southampton Pre-con
It’s been a while since my last pre-con, in fact it’s been a while since my last SQL Saturday with...
2015-10-01
538 reads
October speaking schedule: Two Saturdays and a Summit
October is going to be a very busy month for me! Three conferences and a pre-con are on the agenda.
This...
2015-10-01
373 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