Excel Tip #29: Forcing Slicers to Filter Each Other when Using CUBE Functions
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2015-10-09
935 reads
How do you choose a source control system for your SQL Server database
If you already have a source code repository for your app code or other databases or you have another team that uses source control then just use theirs.
If you...
2015-10-09
12 reads
SQLRelay Reading - Build a CI Pipeline in 55 Minutes Talk
I had a lot of fun yesterday presenting my talk on how to go from not having your database in version control to deploying to a CI database, running...
2015-10-09
15 reads
Thank You Community
All I can say is, “Wow…Thank you!”. I won a seat on the PASS Board of Directors and it’s very...
2015-10-09
437 reads
Deployed Target Metadata with PoSH
This article shows a deeper dive that will show how to expose the Deployed Target Metadata with PoSH and familiarity with this powerful tool.
Related Posts:
PowerShell to Backup XE Session...
2015-10-09
6 reads
Deployed Target Metadata with PoSH
Having just covered the methods to discover the metadata for a deployed session including the details about the session settings,...
2015-10-09
564 reads
Untrusted Check Constraints
Check constraints are useful for more than just verifying the data that goes into your tables. The query optimizer can...
2015-10-09
1,284 reads
SQL Server Contracting – The first 14 months (or so)
Crikey, where did that time go! I have been so busy adjusting to my new work life style I have completely neglected my blog.. Well now that I seem...
2015-10-09
23 reads
SQL Server Contracting - The first 14 months (or so)
Crikey, where did that time go! I have been so busy adjusting to my new work life style I have...
2015-10-09
191 reads
log reader uses single CPU
For replication even if you have multi core CPU it uses only one as log reader agent has single threaded...
2015-10-09
439 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